2702 - Microsoft Excel Boot Camp: From Rookie to Rockstar
Course Description
Do you think Excel is boring? Well, you haven't met instructor Greg Creech! Join Greg in the Microsoft Excel Boot Camp as he infuses fun and humor while providing a comprehensive and in-depth learning experience that prepares students for career advancement through a thorough knowledge of Excel. Students will learn the most popular and useful tools in Excel for functions, analytics, information management and manipulation, and greater productivity.
We designed this course for novice to intermediate-level users of Excel, especially for the day-to-day user, who wants to expand their Excel skillset into advanced areas of Excel. The Excel Boot Camp aids in the preparation for the Microsoft Excel certification exam, and the instructor will advise the students on the process and advantages of Excel certification.
This course is offered in three formats. Students can attend class live online (1) or live in-person (2) at our Century Center location. They can also choose the flexibly-paced (3) format that only meets with the instructor for office hours. Please register for the option that best suits your needs. A full description of the formats can be found here: Microsoft Excel Boot Camp.
Prerequisite:
To be successful in this class, participants should already have the following skills:
- Comfortable navigating in Windows: can save and download files and use copy, cut and paste
- Know how to enter and edit data in a cell when using MS Excel
- Know how to do basic formatting of numbers, dates, and text
- Comfortable editing and creating SUM, AVERAGE, and COUNT functions in MS Excel
- Know how to sort and filter data tables in MS Excel
Participants who need to review these skills should consider taking Microsoft Excel Basics prior to registering for this course.
Participants are required to have access to MS Excel in order to complete this course.
Learner Outcomes
After completing this course, participants will be able to:
- Create and edit popular and complex functions with ease
- Analyze information with SubTotals, PivotTables, and Scenario Manager
- Manage and manipulate large data tables using Format as Table, Text-to-Columns, and text functions
- Increase productivity with keyboard and mouse shortcuts, macros, and the Quick Access toolbar
- Develop and implement Excel workbooks with security and protection
- Build a financial workbook and data table for loans and an amortization schedule
- Insert charts and graphs to provide a visual representation of the data