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 Topic

1.3 Customizing the Quick Access toolbar

Excel 2019 Lesson 1 Getting started with Excel 2019 1.3 Customizing the Quick Access toolbar
Previous Topic
Back to Lesson
Next Topic