This course teaches students about working with multiple worksheets and workbooks, using lookup functions and formula auditing, sharing, and protecting workbooks, automating workbook functionality, creating Sparklines and mapping data, and forecasting data. Many of the powerful functions and capabilities of Excel go beyond what is intuitive and require expert skills. This course enables you to master advanced tools and features of MS Excel 2013 MS Excel certification is a smart investment in building expertise in finance or business.
- Course 01 – Working with Multiple Worksheets and Workbooks
- Course 02 – Using Lookup Functions and Formula Auditing
- Course 03 – Sharing and Protecting Workbooks
- Course 04 – Automating Workbook Functionality
- Course 05 – Creating Sparklines and Mapping Data
- Course 06 – Forecasting Data
Audience
This series is designed for students to gain the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros.
Career Path
In high-growth industries, entry-level employees who hold a Microsoft Office Specialist (MOS) certification can earn up to $16,000 more, annually, than their peers. Five times as many high-growth/high-salary positions require experience with Office than all non- Microsoft software skills combined. Twenty-nine percent of tomorrow’s high-growth/high-wage positions require Office or Office- related skills.
Available CEUs for Course Series Completion: 8
Students can earn up to 8 CEUs for fully completing this course series. This information will be displayed on the certificate of completion.