Included Exercise Files
Skill Level : Beginner
Duration : 2h 8m
Language : English
Released : 9/24/2018
Size : 348,38 Mb
Start mastering Excel, the world-renowned powerful spreadsheet program, with Excel expert Dennis Taylor. Learn how to enter data, organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of data and cells, build charts, and create PivotTables. Find out how to use the IF, VLOOKUP, and COUNTIF family of functions. See how to use data analysis tools, including Goal Seek and Solver. Discover how to automate tasks with macros, manage data, and more.
Topics include:
Navigating Excel tabs and menus
Entering data
Creating formulas and functions
Formatting rows, columns, cells, and data
Working with alignment and text wrap
Adjusting rows and columns
Finding and replacing data
Printing and sharing worksheets
Creating charts and PivotTables
Inserting and deleting sheets
Using power functions such as IF and VLOOKUP
Password-protecting worksheets and workbooks
Sorting data
Analyzing data with Goal Seek and Solver
Creating and running macros
