EXCEL 2019 ALL-IN-ONE

Introduction

What’s New in Excel 2019/Office 365

• Why use Excel
• New interface of Excel 2019/Office 365
• Workbooks and Worksheets
• New Functions in Excel 2019/Office 365
• MAXIFS
• New charts in Excel 2019/Office 365
• Funnel chart
• Easier sharing in Excel 2019/Office 365 
• New features in Excel 2019/Office 365
• Enhancements in pivot table
• Summary

Entering Data in Excel

• Entering data manually
• Importing Data using Get & Transform data
• Applying data validation
• Summary

Transforming and Managing Data

• Summary

Formulas and Functions

• Writing Excel formulas and functions
• Functions
• Basic calculations
• COUNT functions (COUNT, CountA, CountBlank)
• Conditional calculation
• Logical functions
• IF
• Text functions
• Summary

Data Analysis

• Pivot tables
• Calculation and grouping options
• Power Pivot and Power Query
• Loading connection through Power Query
• Creating calculated columns in Power Pivot
• What-If Analysis 
• Analysis ToolPak
• Forecast Sheet
• Summary

Data Visualization

• Charts
• Pivot Charts
• Slicer
• Timeline
• Sparklines
• Conditional Formatting (CF)
• Power Map
• Summary

Data Extraction

• Print Excel Files
• Understanding page view
• Understanding page setup options
• Page orientation
• Export or Upload to Power BI
• Share files via Email
• Export data in different file formats
• Summary

Automation in Excel through Macros

• Macros
• Difference between Macros and VBA
• Record a macro
• Save a Macro
• Run a Macro
• Assign Macro to an Object
• Check the VBA Code
• Edit or delete a Macro
• Macro security settings
• Summary