MS Excel Online Training

Visit Tutorial Page ( Report)

Microsoft Excel is a commercial spreadsheet application, written and distributed by Microsoft for Microsoft Windows and Mac OS X. At the time of developing these training modules, we have used Microsoft Excel version 2016. Microsoft Excel is a spreadsheet tool capable of performing calculations, analyzing data, and integrating information from different programs.

  • MS Excel - Basics
    • Excel - Home
    • Excel - Introduction
    • Excel - Basics
    • Excel - Create & Close Files
    • Excel - Tabs & Groups
    • Excel - Editing Data
    • Excel - Formatting
    • Excel - Characteristics Of Cell
    • Excel - Cell Reference
    • Excel - Speak Cells
    • Excel - Text To Columns
    • Excel - Comments
  • MS Excel - Filling
    • Excel - Copying & Filling
    • Excel - Fill Series
    • Excel - Advanced Fill
    • Excel - Flash Fill
  • MS Excel - Worksheet
    • Excel - Viewing Worksheets
    • Excel - Custom View
    • Excel - Adjusting Worksheet
    • Excel - Working With Worksheets
    • Excel - Compare Two Sheets
    • Excel - View Files Side By Side
  • MS Excel - Logical Functions
    • Excel - Logical Test
    • Excel - IF Function
    • Excel - Nested IF
    • Excel - AND Function
    • Excel - Not And If Error
    • Excel - Auditing Tools
  • MS Excel - Functions & Formulas
    • Excel - Text Functions
    • Excel - Date Functions Part 1
    • Excel - Date Functions Part 2
    • Excel - Date Functions Part 3
    • Excel - Name Range
    • Excel - Name Range With Formulas
    • Excel - Basic Formulas
    • Excel - Count Functions
    • Excel - Statistical Functions
    • Excel - Maths & Trigonometry
  • MS Excel - Lookup
    • Excel - VLookup With Exact Match
    • Excel - VLookup Approximate Match
    • Excel - VLookup With Trim
    • Excel - H-Lookup
    • Excel - VLookup Rules
    • Excel - Lookup Function
    • Excel - Lookup Full Record
    • Excel - Index Function
    • Excel - Match Function
  • MS Excel - Protection
    • Excel - Protect Cells
    • Excel - Protect Sheet
    • Excel - Protect File
    • Excel - Protect Workbook
  • MS Excel - Hyperlink
    • Excel - Hyperlink To Sheet
    • Excel - Hyperlink To File
    • Excel - Hyperlink To Webpage
    • Excel - Hyperlink To Update
  • MS Excel - Page Setup
    • Excel - Print Page Setup
    • Excel - Header & Footer
  • MS Excel - Sort & Filters
    • Excel - Data Sorting
    • Excel - Advanced Filters
    • Excel - Filtering Data
  • Tables & Subtotal
    • Excel - Basic Table
    • Excel - Advanced Table
    • Excel - Subtotal
  • MS Excel - Charts
    • Excel - Column Chart
    • Excel - Design A Column Chart Part:1
    • Excel - Design A Column Chart Part:2
    • Excel - Pie, Bar, Column & Line Chart
    • Excel - XY Scatter Chart
    • Excel - Spark Line Chart
    • Excel - Pivot Chart
  • MS Excel - Pivot Tables
    • Excel - Pivot Table Example 1
    • Excel - Pivot Table Example 2
    • Excel - Pivot Table Example 3
    • Excel - Pivot Table Grouping
    • Excel - Pivot Table Slice
    • Excel - Pivot Table Timeline
  • MS Excel - Consolidate
    • Excel - Consolidation
    • Excel - Consolidation Extended
  • MS Excel - Conditional Formatting
    • Excel - Conditional Formatting Part 1
    • Excel - Conditional Formatting Part 2
    • Excel - Advanced Conditional Formatting
  • MS Excel - Data Validation
    • Excel - Data Validation
    • Excel - Data Validation Error Alert
    • Excel - Dependent Dropdown List
  • MS Excel - Importing Data
    • Excel - Import Live Data From Web
  • MS Excel - Objects
    • Excel - Insert Objects
    • Excel - Create Objects
  • MS Excel - Shortcuts
    • Excel - Shortcuts Ctrl+A To Ctrl+Z
    • Excel - Shortcuts Alt+A To Alt+Z
    • Excel - Shortcuts Alt + Single Key
    • Excel - Shortcuts F1 To F12
    • Excel - Shortcuts Single Key
    • Excel - Shortcuts Shift+F1 To Shift+F12
    • Excel - Shortcuts Shift+Single Key
    • Excel - Shortcuts Ctrl+F1 To Ctrl+F12
    • Excel - Shortcuts Ctrl + Special Characters
    • Excel - Shortcuts Ctrl+Single Key
    • Shortcuts Ctrl+Shift+A To Ctrl+Shift+Z
    • Shortcuts Ctrl + Shift + Special Characters
    • Excel - Shortcuts Ctrl + Shift + Single Key
    • Shortcuts Ctrl+Shift+F1 To Ctrl+Shift+F12
    • Excel - Shortcuts Alt+F1 To Alt+F12
Write Your Review

Reviews