Excel 2016

Lesson 1 Getting started with Excel 2016
7 Topics
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
6 Topics
2.1 Creating and Converting Workbooks
2.2 Understanding Type of Data
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
Lesson 3 Formatting Sheets, Cells and Tables
7 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
Lesson 4 Formulas and Functions
5 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
Lesson 5 Editing Graphics
6 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
Lesson 6 Chart Design
9 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
Lesson 7 Managing Data Lists and Pivot Table Report
4 Topics
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
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
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
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
10.4 Tips #4
250 Excel Keyboard Shortcuts
Previous Topic
Next Topic

1.5 Using Zoom-in and Mini Toolbar

Excel 2016 Lesson 1 Getting started with Excel 2016 1.5 Using Zoom-in and Mini Toolbar
Previous Topic
Back to Lesson
Next Topic