Microsoft Excel

Course details

• Microsoft Excel 2019 New Features: Learners will discover the latest features and enhancements in Excel 2019.
• Getting Started with Microsoft Office Excel: This module will teach learners the basics of navigating and using Excel.
• Performing Calculations: Participants will learn how to perform various calculations and use Excel as a calculator.
• Modifying a Worksheet: Learners will understand how to edit and manipulate worksheet content effectively.
• Formatting a Worksheet: This module covers formatting techniques to make data visually appealing and organized.
• Printing Workbooks: Participants will learn how to print Excel workbooks and customize print settings.
• Managing Workbooks: This module focuses on tasks like saving, opening, and managing multiple workbooks.
• Working with Functions: Learners will explore Excel functions for data analysis and automation.
• Working with Lists: This module will teach learners how to work with and manage data lists in Excel.
• Analyzing Data: Participants will discover techniques for data analysis and interpretation in Excel.
• Visualizing Data with Charts: Learners will create various types of charts to represent data visually.
• Using PivotTables and PivotCharts: This module covers the creation and utilization of PivotTables and PivotCharts for data summarization.
• Working with Multiple Worksheets and Workbooks: Participants will learn how to manage and link data across multiple sheets and workbooks.
• Using Lookup Functions and Formula Auditing: Learners will explore lookup functions and tools for formula auditing and error detection.
• Sharing and Protecting Workbooks: This module teaches learners how to share and secure Excel workbooks.
• Automating Workbook Functionality: Participants will learn about automation techniques like macros and VBA.
• Creating Sparklines and Mapping Data: Learners will create sparklines and visualize data on maps in Excel.
• Forecasting Data: This module covers forecasting techniques using Excel.
• Excel Templates: Participants will explore the use of Excel templates for efficient document creation.