Productivity

LM102 Microsoft Excel 2016 Essentials (LM102)


Description
Learn to use Excel 2016 Essentials
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 certification with a duration: Forever