LM102 Microsoft Excel 2016 Essentials
(LM102)
LM102.1.1. What is Excel Used For
LM102.1 Getting Started
LM102.1.1. What is Excel Used For
LM102.1.2. Using the Menu System
LM102.1.3. Using the Quick Access Toolbar
LM102.1.4. Understanding Workbooks Worksheets
LM102.1.5. Using the Formula Bar
LM102.1.6 Using the Status Bar.mp4
LM102.1.7. Using Navigation Tools
LM102.1.8. Using Shortcuts Mini Toolbar
LM102.1.9. Creating New Workbooks
LM102.1.10. Using Excel Help
Chapter One Test
Feedback LM102.1
LM102.2 Entering Data
LM102.2.1 Exploring Data Entry _ Editing technique...
LM102.2.2 Entering Data with Autofill
LM102.2.3 Working with Dates Times
LM102.2.4 Using Undo and Redo
LM102.2.5 Adding Comments-1.mp4
LM102.2.6 Using Save or Save As
Chapter Two Test
Feedback LM102.2
LM102.3 Creating formulas and Functions
LM 102.3.1 Creating Simple Formulas
LM 102.3.2 Copying Formula into Adjacent Cells
LM 102.3.3 Calculating Year-to-Date Totals
LM 102.3.4 Creating Percentage-Change Formula
LM 102.3.5 Work with Relatives Absolute Mixed Refe...
LM 102.3.6 Using SUM and AVERAGE
LM 102.3.7 Using Other Common Functions
Chapter Three Test
Feedback LM102.3
LM102.4 Formatting
LM102.4.1 Explore Font Style _ Effects.mp4
LM102.4.2 Adjust roe heights _ column widths.mp4
LM 102.4.3 Work with Alignment Warp Text
LM 102.4.4 Designing Borders
LM102.4.5 Explore numerics _ special formatting.mp...
LM102.4.6 Format numbers _ data.mp4
LM102.4.7 Use conditinal formatting.mp4
LM102.4.8 Create _ Use tables.mp4
LM 102.4.9 Insert Shapes Arrows Visual Features
Chapter Four Test
Feedback LM102.4
LM102.5 Adjust Worksheet Layout and Data
LM102.5.1 Insert _ delete rows _ columns.mp4
LM 102.5.2 Hide Unhide Rows Columns
LM102.5.3 Moving copying _ inserting data.mp4
LM 102.5.4 Find Replace Data
Chapter Five Test
Feedback LM102.5
LM102.6 Printing
LM102.6.1 Explore page layout tab _ page layout vi...
LM 102.6.2 Preview Page Breaks
LM102.6.3 Work with page setup _ print controls.mp...
Chapter Six Test
Feedback LM102.6
LM102.7 Charts
LM 102.7.1 Creating Charts
LM102.7.2 Explore chart types.mp4
LM 102.7.3 Format Charts
LM 102.7.4 Work with Axes Titles Other Chart Eleme...
LM102.7.5 Create in-cell charts with sparklines.mp...
LM102.7.6 New charts in Excel 2016.mp4
Chapter Seven Test
Feedback LM102.7
LM102.8 Adjust Worksheet Views
LM102.8.1 Freeze _ unfreeze panes.mp4
LM102.8.2 Split screens horizontally _ vertically....
LM102.8.3 Collapsing _ expanding data views with o...
Feedback LM102.8
LM102.9 Multiple Worksheets and Workbooks
LM102.9.1 Display multiple worksheets _ workbooks....
LM 102.9.2 Rename Insert and Delete Sheets
LM 102.9.3 Move Copy Group Sheets
LM102.9.4 Use formulas to link worksheets _ workbo...
LM 102.9.5 Locate and Maintain Links
Chapter Nine Test
Feedback LM102.9
LM102.10 IK VLOOK and Power Functions
LM102.10.1 Use IF Functions _ Relations operators....
LM102.10.2 Get approximate table data with VLOOKUP...
LM102.10.3 Get exact table data with VLOOKUP funct...
LM102.10.4 Use COUNTIF family of functions.mp4
Chapter Ten Test
Feedback LM102.10
LM102.11 Security and Sharing
LM 102.11.1 Unlock Cells Protect Worksheets
LM 102.11.2 Protect Workbooks
LM 102.11.3 Assign Passwords to Workbooks
LM 102.11.4 Share Workbooks
LM 102.11.5 Track Changes
Chapter Eleven Test
Feedback LM102.11
LM102.12 Data Management Features
LM102.12.1 Sort Data.mp4
LM 102.12.2 Insert Subtotals in a Sorted List
LM102.12.3 Use Filters.mp4
LM102.12.4 Split data into multiple columns.mp4
LM102.12.5 Split _Combine columnar data with Flash...
LM 102.12.6 Remove Duplicate Records
LM102.12.7 Use validation tools.mp4
Chapter Twelve Test
Feedback LM102.12
LM102.13 Data Analysis Tools
LM 102.13.1 Use Goal Seek
LM 102.13.2 Use Solver
LM102.13.3 Use Scenario Manager.mp4
LM102.13.4 Use data tables.mp4
Chapter Thirteen Test
Feedback LM102.13
LM102.14 Pivot Tables
LM102.14.1 Create Pivot Table.mp4
LM102.14.2 Manipulating PivotTable data.mp4
LM 102.14.3 Group by Date and Time
LM 102.14.4 Group by Other Factors
LM 102.14.5 Use Slicers to Clarify Manipulate Fiel...
LM102.14.6 Use PivotCharts.mp4
Chapter Fourteen Test
Feedback LM102.14
LM102.15 Introduction to Macros
LM 102.15.1 Exploring the Need for Macros
LM 102.15.2 Create a Simple Macro
LM102.15.3 Run a macro.mp4
Chapter Fifteen Test
Feedback LM102.15
LM102.16 Simulation Files
Opening a New Workbook demo
Opening a New Workbook training
Opening a New Workbook assessment
Finding AutoSum Function demo
Finding AutoSum Function training
Finding AutoSum Function assessment
Using AutoSum demo
Using AutoSum training
Using AutoSum assessment
AutoSum for Non-contiguous Cells demo
AutoSum for Non-contiguous Cells training
AutoSum for Non-contiguous Cells assessment
Subtracting Cells demo
Subtracting Cells training
Subtracting Cells assessment
Calculating Average demo
Calculating Average training
Calculating Average assessment
Course Feedback
Course info
×
Course info
LM102 Microsoft Excel 2016 Essentials
(LM102)
Content
LM102.1 Getting Started
LM102.1.1. What is Excel Used For
sample
LM102.1.2. Using the Menu System
LM102.1.3. Using the Quick Access Toolbar
LM102.1.4. Understanding Workbooks Worksheets
LM102.1.5. Using the Formula Bar
LM102.1.6 Using the Status Bar.mp4
LM102.1.7. Using Navigation Tools
LM102.1.8. Using Shortcuts Mini Toolbar
LM102.1.9. Creating New Workbooks
LM102.1.10. Using Excel Help
Chapter One Test
Feedback LM102.1
LM102.2 Entering Data
LM102.2.1 Exploring Data Entry _ Editing techniques - 1.mp4
LM102.2.2 Entering Data with Autofill
sample
LM102.2.3 Working with Dates Times
LM102.2.4 Using Undo and Redo
LM102.2.5 Adding Comments-1.mp4
LM102.2.6 Using Save or Save As
Chapter Two Test
Feedback LM102.2
LM102.3 Creating formulas and Functions
LM 102.3.1 Creating Simple Formulas
sample
LM 102.3.2 Copying Formula into Adjacent Cells
LM 102.3.3 Calculating Year-to-Date Totals
LM 102.3.4 Creating Percentage-Change Formula
LM 102.3.5 Work with Relatives Absolute Mixed References
LM 102.3.6 Using SUM and AVERAGE
LM 102.3.7 Using Other Common Functions
Chapter Three Test
Feedback LM102.3
LM102.4 Formatting
LM102.4.1 Explore Font Style _ Effects.mp4
LM102.4.2 Adjust roe heights _ column widths.mp4
LM 102.4.3 Work with Alignment Warp Text
LM 102.4.4 Designing Borders
LM102.4.5 Explore numerics _ special formatting.mp4
LM102.4.6 Format numbers _ data.mp4
LM102.4.7 Use conditinal formatting.mp4
LM102.4.8 Create _ Use tables.mp4
LM 102.4.9 Insert Shapes Arrows Visual Features
Chapter Four Test
Feedback LM102.4
LM102.5 Adjust Worksheet Layout and Data
LM102.5.1 Insert _ delete rows _ columns.mp4
LM 102.5.2 Hide Unhide Rows Columns
LM102.5.3 Moving copying _ inserting data.mp4
LM 102.5.4 Find Replace Data
Chapter Five Test
Feedback LM102.5
LM102.6 Printing
LM102.6.1 Explore page layout tab _ page layout view.mp4
LM 102.6.2 Preview Page Breaks
LM102.6.3 Work with page setup _ print controls.mp4
Chapter Six Test
Feedback LM102.6
LM102.7 Charts
LM 102.7.1 Creating Charts
LM102.7.2 Explore chart types.mp4
LM 102.7.3 Format Charts
LM 102.7.4 Work with Axes Titles Other Chart Elements
LM102.7.5 Create in-cell charts with sparklines.mp4
LM102.7.6 New charts in Excel 2016.mp4
Chapter Seven Test
Feedback LM102.7
LM102.8 Adjust Worksheet Views
LM102.8.1 Freeze _ unfreeze panes.mp4
LM102.8.2 Split screens horizontally _ vertically.mp4
LM102.8.3 Collapsing _ expanding data views with outlining.mp4
Feedback LM102.8
LM102.9 Multiple Worksheets and Workbooks
LM102.9.1 Display multiple worksheets _ workbooks.mp4
LM 102.9.2 Rename Insert and Delete Sheets
LM 102.9.3 Move Copy Group Sheets
LM102.9.4 Use formulas to link worksheets _ workbooks.mp4
LM 102.9.5 Locate and Maintain Links
Chapter Nine Test
Feedback LM102.9
LM102.10 IK VLOOK and Power Functions
LM102.10.1 Use IF Functions _ Relations operators.mp4
LM102.10.2 Get approximate table data with VLOOKUP function.mp4
LM102.10.3 Get exact table data with VLOOKUP function.mp4
LM102.10.4 Use COUNTIF family of functions.mp4
Chapter Ten Test
Feedback LM102.10
LM102.11 Security and Sharing
LM 102.11.1 Unlock Cells Protect Worksheets
LM 102.11.2 Protect Workbooks
LM 102.11.3 Assign Passwords to Workbooks
LM 102.11.4 Share Workbooks
LM 102.11.5 Track Changes
Chapter Eleven Test
Feedback LM102.11
LM102.12 Data Management Features
LM102.12.1 Sort Data.mp4
LM 102.12.2 Insert Subtotals in a Sorted List
LM102.12.3 Use Filters.mp4
LM102.12.4 Split data into multiple columns.mp4
LM102.12.5 Split _Combine columnar data with Flash Fill.mp4
LM 102.12.6 Remove Duplicate Records
LM102.12.7 Use validation tools.mp4
Chapter Twelve Test
Feedback LM102.12
LM102.13 Data Analysis Tools
LM 102.13.1 Use Goal Seek
LM 102.13.2 Use Solver
LM102.13.3 Use Scenario Manager.mp4
LM102.13.4 Use data tables.mp4
Chapter Thirteen Test
Feedback LM102.13
LM102.14 Pivot Tables
LM102.14.1 Create Pivot Table.mp4
LM102.14.2 Manipulating PivotTable data.mp4
LM 102.14.3 Group by Date and Time
LM 102.14.4 Group by Other Factors
LM 102.14.5 Use Slicers to Clarify Manipulate Fields
LM102.14.6 Use PivotCharts.mp4
Chapter Fourteen Test
Feedback LM102.14
LM102.15 Introduction to Macros
LM 102.15.1 Exploring the Need for Macros
LM 102.15.2 Create a Simple Macro
LM102.15.3 Run a macro.mp4
Chapter Fifteen Test
Feedback LM102.15
LM102.16 Simulation Files
Opening a New Workbook demo
Opening a New Workbook training
Opening a New Workbook assessment
Finding AutoSum Function demo
Finding AutoSum Function training
Finding AutoSum Function assessment
Using AutoSum demo
Using AutoSum training
Using AutoSum assessment
AutoSum for Non-contiguous Cells demo
AutoSum for Non-contiguous Cells training
AutoSum for Non-contiguous Cells assessment
Subtracting Cells demo
Subtracting Cells training
Subtracting Cells assessment
Calculating Average demo
Calculating Average training
Calculating Average assessment
Course Feedback
Completion rules
All units must be completed
Leads to a certificate with a duration: Forever
×
Congratulations!
Course completed!
Download certificate
Continue
Go to next course
×
You didn't quite make it
Unfortunately, you didn't reach a passing score for this course
Go to course list
×
Notice
×
Notice
×
Notice