1 - Getting Started with Microsoft
Office Excel 2019
·
Navigate
the Excel User Interface
·
Use
Excel Commands
·
Create
and Save a Basic Workbook
·
Enter
Cell Data
·
Use
Excel Help
2 - Performing Calculations
·
Create
Worksheet Formulas
·
Insert
Functions
·
Reuse
Formulas and Functions
3 - Modifying a Worksheet
·
Insert,
Delete, and Adjust Cells, Columns, and Rows
·
Search
for and Replace Data
·
Use
Proofing and Research Tools
4 - Formatting a Worksheet
·
Apply
Text Formats
·
Apply
Number Formats
·
Align
Cell Contents
·
Apply
Styles and Themes
·
Apply
Basic Conditional Formatting
·
Create
and Use Templates
5 - Printing Workbooks
·
Preview
and Print a Workbook
·
Set
Up the Page Layout
·
Configure
Headers and Footers
·
6 - Managing Workbooks
·
Manage
Worksheets
·
Manage
Workbook and Worksheet Views
·
Manage
Workbook Properties
Excel
2019 - Part 2
Upon successful completion of this course, you will be able to
leverage the power of data analysis and presentation in order to make informed,
intelligent organizational decisions. You will: Work with Functions Work with
Lists Analyze Data Visualize Data with Charts. Create advanced formulas.
Analyze Data with PivotTables and Pivot Charts.
1 - Working with Functions
·
Work
with Ranges
·
Use
Specialized Functions
·
Work
with Logical Functions
·
Work
with Date & Time Functions
·
Work
with Text Functions
2 - Working with Lists
·
Sort
Data
·
Filter
Data
·
Query
Data with Database Functions
·
Outline
and Subtotal Data
3 - Analyzing Data
·
Create
and Modify Tables
·
Apply
Intermediate Conditional Formatting
·
Apply
Advanced Conditional Formatting
4 - Visualizing Data with Charts
·
Create
Charts
·
Modify
and Format Charts
·
Use
Advanced Chart Features
5 - Analyzing Data with PivotTables
and PivotCharts
·
Create
a PivotTable
·
Analyze
PivotTable Data
·
Present
Data with PivotCharts
·
Filter
Data by Using Timelines and Slicers
