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

[img]/uploads/1.filenext.gif99/img]