Play Video
  1.  The Power Of Excel
  2.  How To Use The Menu System
  3.  How To Use the Quick Access Toolbar
  4.  Understanding Workbooks And Worksheets
  5.  How To Use The Formula Bar
  6.  How To Use The Status Bar
  7.  How To Use The Navigation Tools
  8.  How To Use The Short Cut Menus & The Mini Toolbar
  9.  How To Create New Workbook
  10.  How To Use The Excel Help
  1.  Exploring Data Entry And Editing Methods
  2.  Auto Fill Data Entry Methods
  3.  Understanding Dates And Times
  4.  How To Use Undo And Redo
  5.  How To Add Comments
  6.  Using The Save and Save as Command
  1.  How To Create Simple Functions
  2.  How To Copy A Formula Into Adjacent Cells
  3.  How To Create Year To Date Totals
  4.  How To Create A Percentage Change Formula
  5.  Understanding Absolute and Relative Reference
  6.  How To Use SUM And AVERAGE Function
  7.  How To Use Other Excel Functions
  1.  How To Style And Effect Fonts
  2.  How To Adjust Column Width And Row Heights
  3.  How To Use The Alignment And Wrap Text
  4.  How To Design and Use Borders
  5.  How To Use Special Formatting Methods
  6.  How To Format Dates And Numbers
  7.  How To Use Conditional Formatting
  8.  How To Create And Use Tables
  9.  how To Insert Shapes And Others Visual Elements
  1. How To Insert And Delete Columns And Rows
  2. How To Hide and Unhide Rows And Columns
  3. How To Move, Copy, And Insert Data
  4. How To Find and Replace Data
  1. Exploring Page Layout Methods
  2. How To Preview Page Breaks
  3. Page Setup And Printing Controls
  1. How To Create Charts
  2. Exploring Chart Types
  3. How To Format Charts
  4. Axes, Titles, and Other Chart Elements
  5. Exploring New 2016 Charts
  1.  Freezing and Unfreezing Pans
  2.  How To Split Screen Horizontally and Vertically
  3.  How To Collapse And Expand Data Views
  1. How To Display Workbooks And Multiple Worksheets
  2. How To Rename, Insert And Delete Worksheet
  3. How To Move, Copy And Group Worksheet
  4. Linking Worksheets And Workbooks By Formulas
  5. How To Locate And Maintain Links
  1. If functions and Relational Operators
  2. Using The Vlookup Function for Approximate Match type
  3. Using The Vlookup Function for Exact Match type
  4. How To Use CountIF, SumIF and AverageIF Functions
  1.  How To Protect Worksheets
  2.  How To Assign Passwords Workbooks
  3.  How To Protect Workbooks
  1.  How to Sort Data in Excel
  2.  How To Insert Subtotals In A Sorted Data
  3.  How To Use Filters
  4.  How To Split Data In To Multiple Columns
  5.  How Use Flash fill For Splitting And Combining Data
  6.  How To Remove Duplicate Data
  7.  Using Validation Tools To The Best
  1.  How To Use Goal Seek
  2.  How To Use Solver
  3.  How To Use Scenario Manager
  4.  How To Use Data Tables
  1.  How To Create Pivot Tables
  2.  Manipulating Pivot Table Data
  3.  Date and Time Grouping
  4.  Extended Grouping Analysis
  5.  How To Use Slicers
  6.  How To Use Pivot Charts
Explore other tips