Mastering Excel 2019

Lesson 1 Getting started with Excel 2019
8 Topics
1.1 Introduction to Excel Spreadsheet
1.2 Interface of Excel 2019
1.3 Customizing the Quick Access toolbar
1.4 Understanding the Status Bar
1.5 Using Zoom-in and Mini Toolbar
1.6 Using Simple Keyboard Keys to Move Around
1.7 Online Help
Assessment Test #1
Lesson 2 Basic Operations
7 Topics
2.1 Creating and Converting Workbooks
2.2 Understanding Type of Data Copy
2.3 Entering Data using Enter and Tab
2.4 Performing basic operations: edit, move, copy and delete
2.5 Entering Data using AutoFill
2.6 Using Flash Fill and adding comments to the cell
Assessment Test #2
Lesson 3 Formatting Sheets, Cells & Tables
8 Topics
3.1 Changing Font Settings of a Cell
3.2 Applying Number Formats
3.3 Adjusting row height and column width
3.4 Hiding/unhiding rows and columns
3.5 Applying Borders, Shading and Gradient Fill
3.6 Using cell formatting
3.7 Using Table Formatting
Assessment Test #3
Lesson 4 Formulas & Functions
6 Topics
4.1 Using Formulas
4.2 Entering Formulas
4.3 Using Sum Formulas
4.4 Using Sum, Average and SumIF Function
4.5 Using Vlookup Function
Assessment Test #4
Lesson 5 Editing Graphics
7 Topics
5.1 Inserting pictures
5.2 Editing pictures
5.3 Using SmartArt
5.4 Inserting shapes
5.5 Overlapping, grouping,& hiding graphics
5.6 Capturing a Screenshot
Assessment Test #5
Lesson 6 Charting
10 Topics
6.1 Inserting Charts
6.2 Adding Chart Elements
6.3 Changing Source Data
6.4 Changing Chart Layout and Format
6.5 Formatting Chart Elements
6.6 Enhancing a chart
6.7 Hierarchical & Statistical Charts
6.8 Creating Sparklines
6.9 Using 3D Maps
Assessment Test #6
Lesson 7 Managing Data Lists & Pivot Table Report
5 Topics
7.1 Creating and Filtering a Data List
7.2 Using Sort & Filter
7.3 Using Subtotal
7.4 Creating PivotTable Report
Assessment Test #7
Lesson 8 Automating Tasks with Macros
4 Topics
8.1 Installing Developer Tab
8.2 Recording Macro
8.3 Editing Macro
8.4 Macro Security
Lesson 9 Helpful Keyboard shortcuts & hints
3 Topics
9.1 Creating Excel Spreadsheet/chart in Word and PowerPoint
9.2 Using Keyboard Shortcuts
9.3 Helpful Hints
Lesson 10 Tips & Tricks
2 Topics
10.1 Expand and collapse the ribbon and full-screen views
10.2 Faster Way to copy and move tasks within cells and worksheets
Excel 250 Keyboard Shortcuts
Previous Topic
Next Lesson

Assessment Test #1

Mastering Excel 2019 Lesson 1 Getting started with Excel 2019 Assessment Test #1

Please click the following link to start the assessment test. This is an interactive test that you need to interact with the content. 

Assessment Test 1

Previous Topic
Back to Lesson
Next Lesson