MS Excel. Module 1: Intermediate
Description
Enhance your data management and analysis skills with our "MS Excel: Intermediate" course.
This training is ideal for individuals who are familiar with the basics of MS Excel and want to expand their knowledge to include more advanced features and functionalities. Participants will learn how to efficiently create and manage workbooks, perform data operations, and visualize data, preparing them for the MO-200 certification exam.
This course dives into the intermediate features of MS Excel and is divided into five detailed modules:
- Manage Worksheets and Workbooks
- Manage Data Cells and Ranges
- Manage Tables and Table Data
- Perform Operations by Using Formulas and Functions
- Manage Charts
By the end of this course, participants will be able to:
- Efficiently manage and navigate within workbooks and worksheets.
- Manipulate and format data cells and ranges to present information clearly.
- Create, modify, and analyze data within tables.
- Use formulas and functions to perform complex data operations.
- Create and format charts to visualize data effectively.
Participants will gain the skills needed to apply these features in a professional setting, enhancing their productivity and data analysis capabilities. Successful completion of the course prepares
is issued on the Luxoft Training form
Objectives
Participants are expected to demonstrate correct application of the principal features of MS Excel and complete tasks independently.
Roadmap
- Manage worksheets and workbooks (3 hours: 1.5h theory, 1.5h practice)
- 1.1 Import data into workbooks
- 1.2 Navigate within workbooks
- 1.3 Format worksheets and workbooks
- 1.4 Customize options and views
- 1.5 Configure content for collaboration
- Manage data cells and ranges (2 hours: 1h theory, 1h practice)
- 2.1 Manipulate data in worksheets
- 2.2 Format cells and ranges
- 2.3 Define and reference named ranges
- 2.4 Summarize data visually
- Manage tables and table data (2 hours: 1h theory, 1h practice)
- 3.1. Create and format tables
- 3.2. Modify tables
- 3.3. Filter and sort table data
- Perform operations by using formulas and functions (2 hours: 1h theory, 1h practice)
- 4.1 Insert references in formulas
- 4.2 Calculate and transform data by using functions
- 4.3 Format and modify text by using functions
- Manage charts (2 hours: 1h theory, 1h practice)
- 5.1 Create charts
- 5.2 Modify charts
- 5.3 Format charts
TOTAL: 11 hours (50% theory, 50% practice)