To Become Excel Pro Give a Missed Call @8595948890

Advanced Microsoft Excel Training Course

Our advanced Excel course lets you master the most widely used spreadsheet, MS Excel. We provide the best online classes to help you learn Excel workbook, tables. cells, creating dashboard. interactive components, charting, filtering. sorting. Pivot tables. and data processing with real-world datasets. Join this Microsoft Excel training now and up skill your self.

Enroll Now
logo icon

A Complete Course to Become Ms-Excel Pro

@ 2499/- 1999/-

This course includes

about icon
Live Class

You will get interactive live classes directly by Experts.

about icon
Video Classes

You will get intractive Video classes directly by experts

about icon
Master Classes

Weekly Master Classes on newest trends and topics.

about icon
Assessment

Periodical assignments that make you industry ready.

about icon
Access of LMS

You will get access to Learning Management System (LMS).

about icon
Access of Job Portal

Job Assurance to certified and deserving students.

Course Overview

Master the basics and advanced features of MS Excel to effectively apply them in your daily tasks. This MS Excel course will give you an overview of working with the powerful spreadsheet application, MS Excel. This course includes creating dashboards, interactive components, data consolidation, and debugging. This training is useful for working on financial, mathematical, and statistical data processing and implementing complex Macros.

What you will learn

  • What Will You Learn
  • Basic and advanced concepts of MS Excel
  • Deploying formulae and logical functions
  • Using sorting and filtering on Excel spreadsheet data
  • Excel charting principles
  • Data quality issues
  • Using a Pivot table for explaining advanced option
  • Advanced functions such as DSUM and DMAX
  • Using VBA Editor for editing macros
  • Working on practical VBA projects
@ 2499/- 1999/-
Enroll Now

This course includes:

Live Class

Access of LMS

Access of Job Portal

30 Hours

Weekly Assessment

Weekly Assignment

Share Gift this course

Course content

Module-1

INTRODUCTION OF MS EXCEL

  • Advantages of using MS Excel & Various Purpose of use Excel
  • Understanding of Workbook , Worksheet , Columns, Rows & Cells
  • Ribbon & Tab
  • Quick access bar , Formula bar , Name bar , Status bar
  • Enter Data & Saving Workbook
  • Applying fonts, background colors, and borders & Alignment
  • Inserting and Hide/ unhide Columns & Rows
  • Formatting Cell

Module-2

SORTING DATA

  • Basic Sorting & Shortcut keys
  • Sorting Using Custom List
  • Horizontal Sorting
  • Conditional Formatting

FILTERING DATA

  • Basic Filter & Shortcut Keys
  • Filter Problem # 1 (Copy Filtered Data without hidden rows)
  • Filter Problem # 2 (Pasting Values on Filtered Data)
  • Filter Problem # 3 (Performing Calculation on Filtered Data)
  • Advanced Filter (Using Complex Criteria's)

Module-3

BASIC OF FORMULA / FUNCTIONS

  • Formula Writing
  • Exercise of Formula Writing
  • "Excel files for practice"

SUM COUNT AVERAGE FUNCTIONALITY (WITH CONDITIONS)

  • SumIf & SumIfs
  • Exercise of SumIf & SumIfs
  • Count Functions
  • Exercise of Count Functions
  • AverageIf & AverageIf
  • Exercise of AverageIf & AverageIfs
  • "Excel files for practice"

Module-4

FINANCIAL FUNCTIONS (USEFUL FOR NON-FINANCE GUYS TOO)

  • Loan Calculation (PMT, PPMT, IPMT etc.)
  • Exercise of Loan Calculation (PMT, PPMT, IPMT etc.)

DATE & TIME FUNCTION

  • How Excel Records Date & Timer
  • Now, Today & Autofill
  • DateValue & TimeValue
  • DatedIf
  • Practice Exercise

Module-5

LOGICAL FUNCTIONS (WORKING WITH CONDITIONS)

  • If Functionality
  • If with AND
  • If with OR
  • If with AND & OR, IF with Countif
  • Nested If

LOOKUP FUNCTIONALITY

  • Vlookup Introduction
  • Vlookup (Exact Match)
  • Unique Example of Vlookup
  • Type of References (Use of $ Sign)
  • Double Vlookup
  • Vlookup on Duplicate Values
  • Vlookup (Approximate Match)
  • Vlookup with IF (Conditional Vlookup)
  • Nested Vlookup
  • Unique Example of Vlookup
  • Reverse Vlookup
  • Practice Exercise
  • Hlookup (Exact Match)
  • Hlookup (Approximate Match)

Module-6

DATA CONSOLIDATION (MULTIPLE WORKBOOKS WORKSHEETS)

  • Consolidate Data using Excel Inbuilt Function
  • Excel Files for Practice

DATA VALIDATION

  • By Number , text , Date , List ( Dropdown)
  • Input Message & Error Messege
  • Dependent Data Validation

Module-7

PIVOT TABLE & TECHNIQUES

  • Understanding pivot Table
  • Using Pivot Table in Real Scenario
  • Exercise- Using Pivot Table in Real Scenario
  • Refreshing Data in Pivot table
  • Summarizing Value by Sum, Count , Average, Max & Product
  • Grouping in Pivot Table
  • Pivot Chart
  • Using Slicers (A Visually attractive Filter)
  • Excel Files for Practice

WHAT-IF ANALYSIS & SOLVER ADD-IN

  • Goal Seek (A Reverse Approach)
  • One Way Data Table
  • Two Way Data Table
  • Scenario Manager
  • Solver Add-In

Module-8

AUTOMATION IN EXCEL (MACROS)

  • Record your first Macro
  • Assigning Macros to a Shape, Button, Picture
  • Editing or Deleting a Macro

Other Advance Topics

  • Format Painter
  • Freeze Pans
  • Removing Duplicates
  • Transposing Data
  • Paste Special
  • Group & Ungroup
  • Hyperlink
  • Flash Fill
  • Sparklines
  • Clean symmetrical data
  • Print Settings
  • Custom Formatting

Module-9

Excel Dashboard

  • Objective to Create Dashboard
  • Create Pivot Table & Charts
  • Design Dashboard
  • Use Macro to Automatically Refresh all when row data is changed or new data is added
  • Exercise files for practice

Protecting and Security

  • Password Protect workbook (file) for open & modify
  • Password Protect Sheet
  • Password protect workbook structure (Review => protect Sheet)
  • Hide & Unhide Sheet Data

Featured review

Sonam Malhotra
18 courses
11 reviews

4.4 (1,660 ratings) 6,756 students

MARG trains and certifies students on various technologies helping them to be prepared for the industry. MARG academy's training solutions are designed to help students to stay competitive today as well as in the future. I really like the commitment of MARG academy.

Was this review helpful?
Report
ADVANCED MICROSOFT EXCEL TRAINING COURSE

INDUSTRY BASED ASSIGNMENT

Q& A SESSION