Introduction to Microsoft Excel training empowers participants with key skills to create and edit worksheets, implement formulas and functions, and sort and filter detailed data with tables and slicers. Visualize the numbers in a consumable and professional format analyzing data with charting, conditional formatting, sparklines, and pivot tables.
Microsoft Excel Training Delivery Methods
In-Person
Online
On-Demand
Microsoft Excel Training Information
In this Microsoft Excel training, you will learn to:
Efficiently navigate and manipulate worksheets and workbooks
Implement an income and expense statement with formulas, functions and names
Design a reusable data entry template that protects formulas
Implement conditional formatting to analyze sales information
Connect, prepare and validate data employing editing tools, formulas, and Flash Fill
Identify, sort and select detailed data with tables and slicers
Present and analyze data with conditional formatting, charting, sparklines, and printing parameters
Construct IF functions that make decisions – present results visually
Combine data with 3-D formulas
Analyze summary data with PivotTables and implement a quick dashboard
Exclusive LinkedIn group membership for peer and SME community support
Leverage continued support with after-course one-on-one instructor coaching and computing sandbox
Microsoft Excel Training Exam Information
4thdacad end-of-course exam included
Microsoft Excel Training Instructor-Led Course Outline
Module 1: Introduction to Microsoft Excel
Working with cell ranges—navigating and selecting cells with the mouse and keyboard
Entering and editing data
Employing AutoFill to enter data
Inserting and deleting rows, columns, or cells
Adjusting column width and row height
Manipulating data with cut, copy, paste, with the clipboard, or with dragging the mouse
Leveraging multiple worksheets
Module 2: Formulas and Functions
Module 3: Worksheet Formatting and Presentation
Module 4: Getting Data In and Out
Module 5: Sorting, Selecting and Subtotaling data
Module 6: Present Data Visually
Module 7: Introducing Advanced Features
Microsoft Excel Training On-Demand Training Bundle
On-Demand Training Bundle Benefits
This product offers access to a library of Microsoft Office on-demand courses, including Excel, Word, PowerPoint, and more. In addition, during your annual access to this offering, you may attend one of our 1-day review sessions focused specifically on Creating & Designing Excel Workbooks Training.
On-Demand Training Bundle Course List
Unlimited Access Microsoft Excel Training Premium Blended Training
Premium Blended Training Benefits
This product offers access to a library of Microsoft Office on-demand courses, including Excel, Word, PowerPoint, and more. During your annual access to this offering, you may attend one of our 1-day review sessions focused specifically on Creating & Designing Excel Workbooks Training. Enrolling in this bundle also grants you access to any of our multi-day instructor-led course events of this course, 1361, Introduction to Microsoft Excel Training.
How to Schedule Your Instructor-Led Training
Once payment is received, you will receive details for your Unlimited Access Training Bundle via email. At that time, you may call or email our customer service team for assistance in enrolling in the event date of your choice.
Premium Blended Training On-Demand Course List
Premium Blended Training Instructor-Led Contents
العربية