Excel 2016

Current Status

Not Enrolled

Price

$19.95

Get Started

or

Course Content

Expand All

Lesson 1 Getting started with Excel 2016 7 Topics Sample Lesson

Expand

Lesson Content

0% Complete 0/7 Steps

1.1 Introduction to Excel Spreadsheet

1.2 Interface of Excel 2016

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 (new feature)

Lesson 2 Basic Operation

Lesson 3 Formatting Sheets, Cells and Tables 7 Topics

Expand

Lesson Content

0% Complete 0/7 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

Lesson 4 Formulas and Functions

Lesson 5 Editing Graphics 6 Topics

Expand

Lesson Content

0% Complete 0/6 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

Lesson 6 Chart Design 9 Topics

Expand

Lesson Content

0% Complete 0/9 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

Lesson 7 Managing Data Lists and Pivot Table Report 4 Topics

Expand

Lesson Content

0% Complete 0/4 Steps

7.1 Creating and Filtering a Data List

7.2 Using Sort & Filter

7.3 Using Subtotal

7.4 Creating PivotTable Report

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 and 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 and Tricks 4 Topics

Expand

Lesson Content

0% Complete 0/4 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

10.3 Depreciation

250 Excel Keyboard Shortcuts