· Change workbook appearance using styles and themes
· Create new workbooks based on built-in templates
· Format cells according to their contents
· Insert and formatting pictures, screenshots, Clip Art, and shapes
· Display data visually using SmartArt graphics
· Exchange data between Excel and other programs
· Filter data by using advanced criteria
· Control data entry inputs using forms and validation rules
· Summarize values using outline, subtotals, and consolidation
· Display, summarize , and analyze data using PivotTables & PivotCharts
· Perform what-if analysis to see the effect of changing variables
· Create formulas using meaningful range names instead of cell references
· Search for data using the lookup functions
· Summarize values using conditional functions
· Identify, evaluate, and correct formula errors
· Protect and secure workbooks
· Share workbooks with workgroups
· Master collaboration techniques like tracking changes and adding comments
· Record, run, and modify macros
· Save display and print settings using custom views
· Define and organize files using workbook properties
· Customize the interface elements
Description
In this course, trainees will learn the advanced features of Microsoft Excel 2021. They will learn how to apply advanced formatting to cells; insert, format, and organize illustrations; display, summarize, and analyze values; automate repeated tasks; and customize interface elements and workbook properties.
Audience :
This course is intended for advanced-level users who would like to master Excel sophisticated features.
Topics :
Advanced Formatting Techniques
o Applying, Modifying & Creating Cell Styles
o Applying, customizing & saving Themes
o Working with Templates
o Using Conditional Formatting
Working with Illustrations
o Inserting pictures, Screenshots & Clip Art
o Inserting SmartArt Graphics
o Formatting and Organizing Illustrations
Working with Data
o Importing and Exporting Data
o Applying Custom & Advanced Filter
o Setting Data Validation Criteria
o Using Data Forms
Summarizing and Analyzing Tools
o Displaying Data Outline & Subtotals
o Consolidating Data in Multiple Worksheets
o Design PivotTable and PivotChart
o Analyzing Inputs Using Scenario Manager & Data Tables
o Analyzing Outputs Using Goal Seek
Advanced Functions and Formulas
o Managing Named Ranges
o Using Lookup Functions
o Using Conditional Functions
o Tracing & Correcting Formula Errors
Collaboration & Workgroup Skills
o Protecting Cells, Worksheets & Workbooks
o Checking Workbooks for Compatibility, Accessibility & Personal Information
o Preventing Accidental Changes
o Inserting Digital Signatures
o Sharing Workbooks
o Tracking Changes
o Inserting Comments
o Exchanging, Comparing & Merging Files
Automation and Customization
o Working with Macros
o Designing Worksheet Forms
o Saving Custom Views
o Customizing the Workbook Properties
o Customizing the Program Interface
Recommended Knowledge :
Microsoft Excel 2021 - Core Level
Category :
Training Materials :
YAT Official Courseware
Labs :
This course includes several labs to ensure you will gain the targeted skills and experience.
Credential :
With the core level, this course covers the entire topics required for the Microsoft Office Specialist (MOS) exam.
