Course Requirement (What software needed):

• Microsoft Excel 2020 In your Device
• Need to create Database/Table/Simple Data Range
  

Learn everything you need to know about pivot tables in this comprehensive course. Go all the way from answering “what is a pivot table?” to building portfolio ready projects.


Enroll now to go through a deep dive of the most popular spreadsheet tool on the market, Microsoft Excel. Build your own spreadsheets from scratch, and actually understand how they work! Concise, yet comprehensive and informative.

Build Projects Including:

1) Build your first basic pivot table to start.

2) Build an expense report from start to finish.

3) Learn how to perform sales report analysis with pivot tables and get that raise.

4) Learn to slice data with powerful data slicer tools and link slicers to multiple pivot tables.

5) Connect to databases to import your data sources and format large datasets.