Part 1: Create and format workbooks
Explore the editions of Excel 2019
Become familiar with new features in Excel 2019
Customize the Excel 2019 app window
Arrange multiple workbook windows
Add buttons to the Quick Access Toolbar
Customize the Excel 2019 app window
2 Work with data and Excel tables
Manage data by using Flash Fill
Manage data by using Flash Fill
3 Perform calculations on data
Create formulas to calculate values
Sidebar: Operators and precedence
Summarize data that meets specific conditions
Set iterative calculation options and enable or disable automatic calculation
Find and correct errors in calculations
Create formulas to calculate values
Summarize data that meets specific conditions
Set iterative calculation options and enable or disable automatic calculation
Find and correct errors in calculations
Apply workbook themes and Excel table styles
Change the appearance of data based on its value
Apply workbook themes and Excel table styles
Change the appearance of data based on its value
Part 2: Analyze and present data
Limit data that appears on your screen
Summarize data in worksheets that have hidden and filtered rows
Find unique values within a data set
Define valid sets of values for ranges of cells
Limit data that appears on your screen
Define valid sets of values for ranges of cells
Sort data by using custom lists
Look up information in a worksheet
Sort data by using custom lists
Look up information in a worksheet
7 Combine data from multiple sources
Use workbooks as templates for other workbooks
Link to data in other workbooks and worksheets
Consolidate multiple sets of data into a single workbook
Use workbooks as templates for other workbooks
Link to data in other workbooks and worksheets
Consolidate multiple sets of data into a single workbook
8 Analyze alternative data sets
Examine data by using the Quick Analysis Lens
Define an alternative data set
Define multiple alternative data sets
Analyze data by using data tables
Vary your data to get a specific result by using Goal Seek
Find optimal solutions by using Solver
Analyze data by using descriptive statistics
Examine data by using the Quick Analysis Lens
Define an alternative data set
Define multiple alternative data sets
Analyze data by using data tables
Vary your data to get a specific result by using Goal Seek
Find optimal solutions by using Solver
Analyze data by using descriptive statistics
Perform business intelligence analysis using charts
Summarize your data by using sparklines
Create diagrams by using SmartArt
Create and manage mathematical equations
Perform business intelligence analysis using charts
Summarize your data by using sparklines
Create diagrams by using SmartArt
Create and manage shapes and mathematical equations
Create and manage mathematical equations
10 Use PivotTables and PivotCharts
Analyze data dynamically by using PivotTables
Filter, show, and hide PivotTable data
Create PivotTables from external data
Create dynamic charts by using PivotCharts
Analyze data dynamically by using PivotTables
Filter, show, and hide PivotTable data
Create PivotTables from external data
Create dynamic charts by using PivotCharts
Part 3: Collaborate and share in Excel
11 Print worksheets and charts
Add headers and footers to printed pages
Prepare worksheets for printing
Fit your worksheet contents to the printed page
Change page breaks in a worksheet
Change the page printing order for worksheets
Add headers and footers to printed pages
Prepare worksheets for printing
12 Automate repetitive tasks by using macros
Set macro security levels in Excel 2019
Run a macro when you open a workbook
Insert form controls into a worksheet
Run macros when you click a button
Run a macro when you open a workbook
Insert form controls into a worksheet
13 Work with other Microsoft Office apps
Include Office documents in workbooks and other files
Link Office documents to Excel workbooks
Embed files in Excel and other Office apps
Include Office documents in workbooks and other files
14 Collaborate with colleagues
Save workbooks for electronic distribution
Protect workbooks and worksheets
Work with OneDrive and Excel Online
Save workbooks for electronic distribution
Add protection to workbooks and worksheets
Work with OneDrive and Excel Online
Part 4: Perform advanced analysis
15 Perform business intelligence analysis
Define relationships between tables
Analyze data by using Power Pivot
Bring in external data by using Power Query
Define relationships between tables
Analyze data by using Power Pivot
Bring in external data by using Power Query
16 Create forecasts and visualizations
3.144.82.21