• LOGIN
  • No products in the cart.

Excel is the most powerful tool to manage and analyze various types of Data. This tutorial covers in-depth lessons on how to use various Excel formulas, Tables and Charts for managing small to large scale business process.

Syllabus

Introduction:

  • Introduction to Microsoft Excel
  • How to Add, Subtract, Multiply, Divide in Excel
  • Excel Data Validation, Filters, Grouping
  • Introduction to formulas and functions in Excel
  • Logical functions (operators) and conditions in Excel
  • Visualizing data using charts in Excel
  • Case Study: Managing personal finance using Microsoft Excel

Advance Stuff:

  • Connecting Microsoft Excel to External Data Source
  • Pivot Tables in Excel: Beginner’s Guide
  • Creating Advanced Charts in Excel
  • Excel in the cloud: Office 365
  • CSV vs Excel (.xls) – What’s the Difference?
  • VLOOKUP and other advance Functions
  • Case Study

Macros & VBA in Excel:

  • Introduction to Macros in Excel
  • Creating your First Visual Basic for Applications (VBA) in Excel

 

 

 

 

Course Curriculum

Basic Functions and Graphs
Advance Functions
Macros and VBA

Course Reviews

N.A

ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

TAKE THIS COURSE
577 STUDENTS ENROLLED

    Related Courses

    Advanced Course Search

    Categories

    X