Start mastering Excel, the world's most popular and powerful spreadsheet program, with Excel expert Dennis Taylor. Learn how to best enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data and cells, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and automating tasks with macros.
Working with the Excel interface
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
Analyzing data with Goal Seek and Solver
Creating and running macros show more No sub-Tutorials exists in this Tutorial.
Write Your Review