Learning Outcomes

In this course, we will cover the following:

  1. Formatting (basic and conditional);
  2. The find and replace all function;
  3. Handy shortcuts;
  4. Auto-fill and fill to the right;
  5. Freeze pane;
  6. Filter and sort;
  7. Text to column and concatenate;
  8. Transpose and value-paste;
  9. Basic math in Excel and Google Sheets;
  10. How formulas work;
  11. Pivot tables and VLOOKUPs;
  12. How to insert a table and graph;
  13. Real-world uses of Excel and Google Sheets; and
  14. How other tools can help in similar ways.




Course Curriculum

  Module 1 - Starter Kit for Excel and Google Sheets for Accountants and Businesses
Available in days
days after you enroll
  Module 2 - Getting started
Available in days
days after you enroll
  Module 3 - Formatting Data
Available in days
days after you enroll
  Module 4 - Working with Data
Available in days
days after you enroll
  Module 5 - Tools - Formulas
Available in days
days after you enroll
  Module 6 - Tools - Analytics
Available in days
days after you enroll
  Module 7 - Course Summary
Available in days
days after you enroll