Course Description

If you work with numbers, names, dates, or other important data, you need to create spreadsheets to manage this information. Microsoft Excel is the most widely-used spreadsheet software to organize, store, and optimize data. If you're ready to learn Excel 2019, this course will teach you the basics.

You will learn how to create a spreadsheet using several time-saving functions. You will also learn how to use macros and buttons, how to sort and analyze your data, and more. By course completion, you will know how to best organize large sets of data into a spreadsheet with this powerful business productivity tool.

Course Outline

• Excel Basics
• Creating a Worksheet
• Time-Savers
• Relative, Absolute, Mixed, and Circular References
• 3-Dimensional Workbooks
• Sorting, Subtotaling, and Filtering
• Charting Basics
• Advanced Charting Techniques
• Intro to Excel's Statistical Functions
• Financial Functions
• Worksheet Automation
• Mastering Excel's IF Function