Start your AI Journey

Mastering Excel 2019

Current Status

Not Enrolled

Price

$19.95

Get Started

or

Learn how to use Microsoft Office Excel 2019 program. This is a step by step training program that you can learn fast and easy.

Course Content

Expand All

Lesson 1 Getting started with Excel 2019 8 Topics Sample Lesson

Expand

Lesson Content

0% Complete 0/8 Steps

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

Expand

Lesson Content

0% Complete 0/7 Steps

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

Expand

Lesson Content

0% Complete 0/8 Steps

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

Expand

Lesson Content

0% Complete 0/6 Steps

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

Expand

Lesson Content

0% Complete 0/7 Steps

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

Expand

Lesson Content

0% Complete 0/10 Steps

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

Expand

Lesson Content

0% Complete 0/5 Steps

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

Expand

Lesson Content

0% Complete 0/4 Steps

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

Expand

Lesson Content

0% Complete 0/3 Steps

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

Expand

Lesson Content

0% Complete 0/2 Steps

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

Related Posts :-

Your cart (items: 0)

Products in cart
Product	Details	Total
	Available on backorder Previous price: Discounted price:	Save