What’s new in Excel 2019
- Creating workbooks
- Entering text, numbers and working with dates
- Navigating workbooks
- Page setup and print options
- Working with rows, columns, and cells
- Cut, Copy and Paste
- Introduction to Functions and Formulas
- Formatting in Excel, including formatting cells and numbers
- Creating charts and graphs
- Sorting and Filtering
- Introduction to PivotTables
- Logical and lookup formulas – the basics
Advanced Microsoft Excel 2019
- What’s new/different in Excel 2019
- Advanced charting and graphing in Excel
- How to use detailed formatting tools
- Lookup and advanced lookup functions
- Financial functions including calculating interest and depreciation
- Statistical functions
- Connecting to other workbooks and datasets outside of Excel e.g. MS Access and the web.
- How to create awesome visualizations using sparklines and data bars
- Mastery of PivotTables and Pivot Charts
- Scenario Manager, Goal Seek and Solver
- Advanced charts such as Surface, Radar, Bubble and Stock Charts
Course Features
- Lectures 13
- Quizzes 14
- Duration 24 hours
- Skill level All levels
- Language English
- Students 101
- Assessments Yes
-
Excel 2019
- Course Exercise Files
- What’s New In Excel
- Course Overview
- Overview of the Excel
- Creating Workbooks
- Entering Text and Numbers
- Creating Basic Formulas
- Relative References
- Order of Operations
- Working with Ranges
- Module 2 – Practice Exercise
- Saving Workbooks
- Navigating Workbooks
- Page Setup & Print Options
- Working with Rows, Columns and Cells
- Moving Data
- Formulas & Functions
- Working with Sheets
- Formatting Worksheets
- Charts, Working with Names, Sorting and Filtering
- Outlining and Subtotaling Working with Views, Linking Advanced Formula Creation
- Pivot Tables, Additional Excel Features Shortcuts
- Functions. Date and Time Functions ,Text Functions,Logical Functions
- Lookup Functions, Financial Functions, Statistical Functions
- Connecting to External, Data Tables, Pivot Tables
- Data Analysis
- Graphs and Charts, Surface Charts, Radar Charts, Bubble Charts, Spark lines, Stock Charts
