TypeOnline Course
Student Enrolled32
(1 ratings)
Buy NowBook Now

What you’ll learn

  • Master Microsoft Excel from Beginner to Advanced
  • Build a solid understanding on the Basics of Microsoft Excel
  • Learn the most common Excel functions used in the Office
  • Harness the full power of Microsoft Excel by automating your day to day tasks through Macros and VBA
  • Maintain large sets of Excel data in a list or table
  • Create dynamic reports by mastering one of the most popular tools, PivotTables
  • Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more
  • Access to a Professional Trainer with 10+ years of Excel Training
Section 1Excel for Beginners
Lecture 1Course Overview
Lecture 2Getting Started MS Excel
Lecture 3Entering and Editing Text and Formulas
Lecture 4Basic Excel Functions
Lecture 5Modifying Excel Sheets
Lecture 6Formatting Data in Excel Worksheet
Lecture 7Inserting Images and Shapes
Lecture 8Creating basic charts in Excel
Lecture 9Printing Excel Worksheets
Section 2Excel for intermediate
Lecture 10Working with Excel List
Lecture 11Excel list Functions
Lecture 12Excel Data Validation
Lecture 13Pivot table
Section 3Excel for Advanced users
Lecture 14Working with Name Range
Lecture 15IF Function
Lecture 16Working With Excel Based Function
Lecture 17Protecting Excel Workbook

Leave a Reply