What is covered in the Bootcamp?
This Bootcamp covers creating automated reports in Microsoft Excel. We will cover all must know formulas for analysts as well as adding automation to the report. Automated reports are a must know for analysts!
Prerequisite: Microsoft Excel beginner knowledge such as formatting, data entry, and basic math functions
Courses will be released on a weekly basis starting Saturday, February 13th. The courses are self paced and can be taken at your leisure.
Course 1: Template Build-out
Course 2: Cell Referencing
Course 3: Lookups
Course 4: If Statements (Part 1)
Course 5: If Statements (Part 2)
Course 6: Aggregate If Statements
Course 7: Pick Lists
Course 8: Macros (Part 1)
Course 9: Macros (Part 2)
Course 10: Automation
Certificate of Completion
You will receive a certificate of completion upon submission of all homework assignments and portfolio by the specified deadline.
Refund Policy: No Refunds