In this course, trainees will learn the basic features of Microsoft Excel 2021. Trainees will have a systematic guidance through handling data in spreadsheets. They will learn how to create and use formulas, functions, tables, and charts that can help them calculate and analyze numeric data. The main focus of the course is on providing basic understanding of spreadsheet building.
Introduction & File Management Basics o Introducing Excel 2021 o Introducing the Backstage View o Customizing the Interface o Managing Excel Files Working with Data o Identifying Data Types o Copying & Moving Data o Finding & Replacing Data o Formatting Numbers o Formatting Text o Formatting Cells o Copying & Clearing Formats o Sorting & Filtering Data Lists o Excel & Database Programs Working with Functions o Functions Overview o Relative & Absolute References o 3-D References o Statistical Functions o Logical Functions o Text Functions Visualizing Data o Creating Excel Tables o Formatting Excel Tables o Editing Excel Tables o Calculating Values in Excel Tables o Creating Charts o Formatting Chart Elements o Customizing Chart Elements o Creating Sparklines o Customizing Sparklines Managing Worksheets o Navigating Worksheets o Changing the Worksheet View o Customizing the Workspace o Linking Data to Different Worksheets o Inserting Hyperlinks o Freezing Panes o Splitting Windows o Arranging & Hiding Windows Printing o Preparing Worksheets for Printing o Previewing & Printing Data
Microsoft Windows 10 or later versions
YAT Official Courseware
This course includes several labs to ensure you will gain the targeted skills and experience.
This course covers the entire topics required for Microsoft Office Specialist (MOS) exam.
All contents copyright 2020 YAT, Inc. All rights reserved
Terms & Conditions Privacy Statement
