Intermediate MS Excel Landing Page

Microsoft Excel:
Intermediate Skills and Techniques

Take your Microsoft Excel skills to the next level with this intermediate course. You will learn how to use advanced excel functions to perform complex calculations and data analysis, create dynamic charts that automatically update with your data, apply conditional formatting and data validation to enhance your worksheets, and troubleshoot errors in formulas and data. You will also discover how to work with multiple worksheets and workbooks, link them with external references and hyperlinks, import and export data from different sources, and create interactive dashboards for better decision-making.

This course is designed for intermediate Microsoft Excel users who want to improve their efficiency and productivity. You should have a basic understanding of Microsoft Excel before taking this course.

Course Features:

Length

Approximately 40.5 hours of streamed multimedia content.

Course Structure

100% online, self-paced.
6 Parts | 12 Modules | 33 Topics.

Interactive and Responsive

Reinforce your learning with 33 practice questions.
Study on the go! [PC | Tablet | Mobile]

Course Community

Collaborate and engage with other students and your instructor.

Key Learning Objectives:

Advanced Functions and Data Analysis

Explore logical, lookup, text, date and time, alongside array formulas and nested functions.

Data Visualization

Select suitable chart types, tailor chart components, adjust chart axes and data series, incorporate trendlines and error bars, and create dynamic charts for automatic updates.

Data Validation

Apply rules and icons based on specific criteria, develop customized formats and formulas, validate data inputs, and pinpoint and rectify formula and data inaccuracies.

Worksheet Management

Arrange worksheets with grouping, tabs, and color schemes, amalgamate data from diverse sources, create formulas referencing other workbooks or worksheets, and embed hyperlinks for accessing web pages or documents.

Data Connections

Establish connections with external data sources, manipulate and filter data, update data connections, and export data into alternative formats.

Interactive Dashboards

Construct interactive dashboards to present key metrics for informed decision-making, employ slicers and timelines for interactive data filtration, and leverage Power View for interactive report generation.