Excel 2016 Expert
You’ll develop the cultural awareness and critical thinking skills you need to analyze and produce a broad range of discourse in a full spectrum of careers — and to make a difference in whatever you do.
- 6 Moduls / 3 Weeks
- Intakes: Asynchronous, Apply to Enroll
Overview
Welcome to the Excel 2016 Expert workshop. Excel can help you interpret data for insights. This course covers workbook options and settings, custom data formats and layouts, advanced formulas and advanced charts and tables that can help you become an Excel expert.
Learning Outcomes
At the end of this course, participants should be able to:
- Save a workbook as a template, with colors, fonts, cell styles and themes
- Reference data using structured references or data in another workbook
- Protect a workbook from further editing
- Prepare a workbook for internationalization
- Apply custom data formats and validation
- Apply advanced conditional formatting and filtering
- Use form controls
- Work with macros
- Define and use named ranges
- Apply functions in formulas using logical functions, math & trig functions, statistical functions and date & time functions
- Get & transform data
- Perform what if analysis
- Troubleshoot formulas
- Create advanced charts
- Create and manage PivotTables
- Create and manage PivotCharts
Course Modules
| Module Name | ||
|---|---|---|
| Module One: Getting Started | ||
| Module Two: Manage Workbook Options and Settings | ||
| Module Three: Apply Custom Data Formats and Layouts | ||
| Module Four: Create Advanced Formulas | ||
| Module Five: Create Advanced Charts and Tables | ||
| Module Six: Wrapping Up |
Do you have more questions?
Contact us
1050 West Lakes Drive, # 225
West Covina, CA 91790
How to Apply?
- You Apply
Tell us a little about yourself and we’ll help with the rest. Our convenient online application tool only takes 10 minutes to complete.
- We Connect
After you submit your application, an admissions representative will contact you and will help you to complete the process.
- You Get Ready
Once you’ve completed your application and connected with an admissions representative, you’re ready to create your schedule.