Description
The Microsoft Excel Associate Course is a survey of Microsoft Excel for newer users. Through this 17-week experience we will facilitate learning around topics from the four foundational pillars of Excel competency: Worksheet & workbook formatting, data management, introductory formulas and functions and built in data visualization tools.
This course is structured around the objectives Microsoft sets for certification as an Excel Associate. For students that meet the qualifications, Create My Excel can administer testing and Excel Associate certification on behalf of Microsoft.
Sessions Overview:
Worksheet & Workbook Formatting (Sessions 1 – 3)
- Importing Data
- Navigating within & formatting sheets and workbooks
- Customizing Options & Views
- Configuring content for effective collaboration
Data Management (Sessions 4 – 8)
- Manipulating Data
- Formatting cells & ranges
- Defining & using named ranges
- Visually summarizing Data
- Creating, modifying, filtering & sorting tables
- Formatting and modifying charts
Introductory Formulas & Functions (Sessions 9 – 11)
- Introduction to Formulas
- Introductory descriptive statistic formulas and text formulas
Data visualization (Sessions 12 – 14)
- Charts & graphs overview
- Formatting and modifying charts
Certification Preparation (Sessions 15 – 17)
Use discount code “BrionHurley” to save 10% OFF
