Microtek Learning Logo

Microsoft Excel - Basics To Advanced Training

5
(5)

Learn how you can effectively use Microsoft Excel in real-world scenarios to automate tasks, analyze data, and generate concise one-page reports. Even if you have never used Excel before, you will be able to acquire the necessary skills and abilities through this Microsoft Excel Training - Basics To Advanced Excel Training.

Redefine Your Microsoft Excel Skills with Microtek Learning

  • Learn how to use Microsoft Excel tool from Basics to Advanced level
  • Master in Pivot Tables, Formulas, Xlookup and More
  • Learn the most advanced formulas, functions
  • Blended Model Support + Extended Learning
  • 24 Hrs Instructor Led Training + Flexible Batches
  • Placement Assistance
  • Accredited By : Microsoft Partner Logo
  • Category : MS Office

Course Price : $999 Per Participant

Course Description

This MS Excel course has been designed by an experienced professional. All of this was achieved using the latest Office 365 software and an updated version of MS Excel. In this course, you will gain a comprehensive understanding of Excel Fundamentals, including all the essential formulas and functions.

Microsoft Course Microsoft Course
500+

Courses

experience experience
20+

Years of Experience

learners learners
95K+

Global Learners

What you will learn

  • green-tick Excel Basics
  • green-tick Shortcuts and Important Tools
  • green-tick Difficult formulas
  • green-tick Charts and Pivot tables
  • green-tick SUMIF, IFS, COUNTIF, IFS
  • green-tick Array
  • green-tick Conditional Formatting
  • green-tick Vlookup/ Hlookup/ Xlookup
  • green-tick Text, Numbers, Math, Lookup functions, Statistical functions

Prerequisites

  • No prerequisites required

Hottest Job of 21st Century

Who should attend this course?

  • Individuals Seeking Jobs
  • Freshers
  • Sales Professionals
  • Marketing Professionals
  • Business Professionals
  • Data Analysts and Programmers
  • Business Intelligence Professionals
  • Strategists
  • Individuals looking for a career in analytics

 

 

Why you should learn Excel?

Why you should learn Excel?

 

Maat The Batch

Microsoft Learning PartnerMicrosoft Learning Partner

Microtek Learning is a Microsoft Certified Partner for Learning Solutions. This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).

Schedules

Oops! For this course, there are currently no public schedules available. Clicking on "Notify Me" will allow you to express your interest.

For dates, times, and location customization of this course, get in touch with us.

You can also speak with a learning consultant by calling 800-961-0337.

Curriculum

  • Add/ Remove/ Delete/ Color a Worksheet, Copy & Move, Hide
  • Font, Text Color, Background Color, Size, Bold, Italic, Underline, Merge, Wrap, Alignment, Comment, Hyperlink
  • Cut, Copy, Paste, Format Painter
  • Borders, Add/ Remove rows & columns
  • Sort, Filter
  • As Values
  • As Link
  • As Formula
  • As Transpose
  • Find/ Find All
  • Replace/ Replace All
  • Format
  • Group/ Ungroup
  • Custom Filter
  • Remove Duplicates
  • Count, Sum, Average, Max, Min, Large, Small
  • Excel Functions
  • Text Functions
  • Date & Time Functions
  • If Function, AND & OR Operators
  • Informational Functions
  • List
  • Typed List
  • Mobile Number Validation
  • Employee Feedback Validation
  • Only Text Values
  • Only Upper Case Values
  • Prevent Future Dates
  • List with Named Range
  • Restrict Text Length
  • Dynamic List
  • Dependent Drop Down List
  • SUMIF, IFS, COUNTIF, IFS
  • Format as Table & Add on Capabilities
  • Array with Sum & Max Functions
  • Inbuilt Conditional Formatting
  • Custom Conditional Formatting
  • Dynamic Search & Highlight
  • Partial Match
  • Auto Fill
  • Flash Fill
  • Custom Lists
  • Vlookup Basic
  • Vlookup with Array
  • Vlookup with Multiple Criteria
  • Vlookup with Range
  • Vlookup with Named Range & Benefits
  • Vlookup with Match Function
  • Vlookup with Column Reference
  • Vlookup with Table
  • Vlookup with Dropdown
  • Two-Way Lookup
  • Partial Vlookup
  • Vlookup to left side
  • Case Sensitive Lookup
  • Vlookup with Trim Function
  • Vlookup if IFERROR
  • Vlookup with Multiple Column Search
  • Vlookup with Two Tables
  • Vlookup with Duplicate Values
  • Bonus: Hlookup & Xlookup
  • Offset - Basic
  • Offset with Sum - Horizontal
  • Offset with Sum - Vertical
  • Offset with Match
  • Offset with Average
  • Offset with Countif
  • Index Function Basic
  • Index Function with Area Number
  • Match Function Basic
  • Index & Match Functions as a replacement to Vlookup Function
  • Index & Match Functions with Drop Down
  • Interface
  • Data Introduction: Super Store Data
  • Create Your First Pivot Table
  • How To Make Pivot Table Dynamic
  • Slicer & Timeline
  • Group & Ungroup Dates
  • Conditional Formatting In Pivot
  • Create Your First Chart
  • How To Make Pivot Chart Dynamic
  • Chart Gap
  • Top 10 Customers
  • Compare One sub-category Against Others
  • Profit & Sales Correlation
  • Trend Analysis
  • Introduction: How Is Power Pivot Different From Pivot Table
  • Avoid Vlookup Using Data Model
  • Create Your Dashboard
  • Introduction: Why Power Query
  • Data From Web
  • Combine Files From Folder In 1 click
  • Protect Sheet
  • Protect Workbook
  • Make Your Workbook Read Only
  • Concat
  • TEXTJOIN Function
  • MINIFS And MAXIFS Function
  • IFS Function
  • SWITCH Function
  • Filter
  • Unique
  • Sort
  • Sortby
  • Sequence
  • Randarray
  • Certification Details

    The purpose of this Microsoft Excel Training - Basics To Advanced Excel Training is to assist students in successfully completing the Excel certification exam provided by Microtek Learning. The entire course is designed to align with the certification exam, helping you pass it with ease and increasing your chances of securing top positions at prestigious multinational corporations.

    During your Microsoft Excel training, you will have the opportunity to work on real-world projects and assignments. These practical experiences will be highly relevant to industry scenarios, enabling you to make significant progress in your career with ease. At the end of this program, there will be quizzes that closely resemble the questions on the certification exam.

    You will receive a Microtek Learning course completion certificate once you have finished the training. This certification is highly regarded by leading multinational corporations (MNCs) such as Cognizant, Ericsson, Hexaware, Cisco, Saint-Gobain, Sony, Standard Chartered, Mu Sigma, Genpact, TCS, and many others.

    Certificate Of Completion

     

    Our Alumni Works At

    Our Alumni Works At

    Course Details

    • cert cert-green
      Certification: YES
    • enroll enroll-green
      Enrolled: 1948
    • duration duration green
      Duration: 2 Days

    Talk to Learning Advisor