Excel (2019) Essential Training

Download Now


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