Microsoft Excel 2019

This course covers Beginners Level, Intermediate as well as Advance Level
that caters need of everyone who wants to learn Microsoft Excel in depth.

What you'll learn

Learning Objectives

Identify the different components of the Excel worksheet.

Master Microsoft Excel from Beginner to Advanced

Learn the most common Excel functions used in the Office

Modifying and formatting a worksheet

Performing calculations using Excel 2019

Developing a workbook and printing workbook contents

Presenting data using charts

Maintain large sets of Excel data in a list or table

excel-logo

₹1500  ₹6000  75% off

This Course Includes:

Virtual classroom

132 Lessons

Live and recorded Videos

Lifetime Access.

One key for one Computer

All Sessions on Google Meet

Certificate of Completion

Course Curriculum

  • Microsoft Excel Version History
  • Version wise Features Comparison
  • Advantages of Microsoft Excel
  • Quick facts and figures about Microsoft Excel
  • What's new in Microsoft Excel
  • Portability features with earlier versions
  • Application Areas of Microsoft Excel
  • Microsoft Excel and Analytics
  • Microsoft Excel and BIG Data
  • Excel Beyond Excel
  • Understanding Excel Navigation System
  • Transformation from Menus to Ribbon
  • Overview of Ribbon, Groups & Tabs
  • Customizing Excel Ribbon
  • Importing and Exporting Customization Settings
  • Understanding Contextual Tabs
  • Overview of Quick Access Toolbars
  • Adding and Removing tools from Quick Access Toolbar
  • Navigating Back Stage View
  • Understanding Modules of Back Stage View
  • Excel Keyboard Shortcuts
  • Format Cell Basics
  • Navigating Format Cells Dialog Box
  • Understanding Excel Data Types
  • Understanding Custom Formatting
  • Transformation from Data Type to Custom
  • Creating custom Date Formatting
  • Creating custom Time Formatting
  • Creating custom Number Formatting
  • Creating custom Text Formatting
  • Conditional Custom Formatting
  • Custom Color Formatting
  • Format Cells to multiple places
  • Keyboard Shortcuts for Cell Formatting
  • A walkthrough to Formatting Options in Home Tab
  • Working with Paste Special - Magical
  • Splitting Data using Text to Columns
  • Sorting Data with Basic & Custom Options
  • Working with Excel Comments
  • Working with Goto Options – Magical
  • Working with Freeze Panes
  • Working with Grouping & Subtotals
  • Excel Security – Protecting a Selected Range
  • Excel Security – Protecting an Entire Sheet
  • Excel Security – Allow users to edit Range
  • Excel Security – Protecting Workbook Structure
  • Excel Security – Full Protection of Workbook
  • Excel Security – Partial Protection of Workbook
  • Working on Excel Data Backup
  • Introduction to Cell Referencing
  • Importance of Cell Referencing
  • Understanding Relative Referencing
  • Understanding Absolute Referencing
  • Understanding Mixed Referencing
  • Common challenges while using Referencing
  • Difference between Functions & Formulas
  • Concept of Nested Formulas
  • Formula Auditing
  • Various Calculation Modes and How to use them
  • Circular References – What are they?
  • Concept of Wild Cards
  • Concept of important Functions: AND, OR, NOT, COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS, MAX, MIN, LARGE, SMALL, UPPER, LOWER, PROPER, RIGHT, LEFT, MID, SEARCH, TEXT, VALUE, POWER, SUM, SUMIF, SUMIFS, AVERAGE, AVERAGEIF, AVERAGEIFS, EXACT, CONCATENATE, LEN, SUBSTITUTE, NETWORKDAYS, NETWORKDAYS.INTL, DATE, TIME, DAY, MONTH, YEAR, HOUR, MINUTE, SECOND, WORKDAY, WORKDAY.INTL, EOMONTH, DATEDIF, VALUE, INT, ISERROR, ISTEXT, ISNUMBER, ISBLANK, ISODD, ISEVEN, MATCH, INDEX, IF, VLOOKUP – 1D, VLOOKUP – 2D, Reverse LOOKUP, HLOOKUP, CHOOSE, RANDBETWEEN, ROW, ROWS, COLUMN, COLUMNS, MOD, IFERROR, SUBTOTAL, SUMPRODUCT, OFFSET, ADDRESS, INDIRECT, REPT
  • Combinations of the above Functions
  • Data Consolidation using 3D Formulas
  • Concept of Precedents
  • Concept of Dependents
  • Introduction to Name Management in Excel
  • Overview of Name Box
  • Creating, editing and deleting Name
  • Understanding Name Scope
  • Defining Static and Dynamic List using names
  • Displaying Name Map in Excel Worksheet
  • Creating Single and Multidimensional Arrays using Name Manager
  • Use of Names in advance Reports
  • Common challeges in Name Management
  • Use of Name Manager for Extracting Data - The Magical
  • Introduction to Data Validation
  • Creating basic Data Validation
  • Creating Data Validation for Test
  • Creating Data Validation for Numbers
  • Creating Data Validation for Date and Time
  • Creating basic drop down list using Data Validation
  • Creating dynamic list using Data Validation
  • Creating Basic Dependent List
  • Creating Multilevel Dependent List
  • Use of Basic Formulas in Data Validation
  • Creating complex validation using Formulas
  • Hacks of Data Validation
  • Applying Data Validation to Multiple Places
  • Using Custom Error Alerts in Validation Conflicts
  • Using Data Validation as a Smart Comments
  • Steps to remove Data Validation
  • Highlighting Invalid Data
  1. Introduction of Excel Tables
  2. Power of Excel Tables
  3. Time Saving features of Excel Tables
  4. Calculation Logic of Excel Tables
  5. Format As Table
  6. Understanding Table Formatting Options
  7. Filters, Can Get Multiple Filters In The Same Sheet
  8. Total Row, Ability To Select Type Of Summary
  9. Structured References – What Are They?
  10. Advantages Of Tables
  11. Convert Table To Named Range
  12. Compatibility Of Tables With Excel 2003 And Earlier
  13. Limitation of Excel Tables
  • Introduction to Conditional Formatting
  • Understanding Static vs Dynamic Formatting
  • Text based Conditional Formatting Rules
  • Numbers based Conditional Formatting Rules
  • Date based Conditional Formatting Rules 
  • Dealing with Unique and Duplicates in Conditional Formatting 
  • Top and Bottom Rules in Conditional Formatting 
  • Introduction to Data Bars, Icon Sets, Color Scales
  • Creating Dashboard using Conditional Formatting
  • Creating Conditional Formatting using Basic Functions
  • Use Single Formatting with Multiple Conditions
  • Implementing Conditional Formatting in Attendance Trackers - Case Study
  • Using Complex Formulas in Conditional Formatting
  • Setting Priorities on Conditional Formatting Conflicts
  • Developing Smart Signalling System using Conditional Formatting
  • Reusing Conditional Formatting
  • Clear Conditional Formatting Rules
  • Introduction of Excel Tables
  • Power of Excel Tables
  • Time Saving features of Excel Tables
  • Calculation Logic of Excel Tables
  • Format As Table
  • Understanding Table Formatting Options
  • Multiple Filters In The Same Sheet
  • Total Row, Ability To Select Type Of Summary
  • Structured References – What Are They?
  • Advantages Of Tables
  • Convert Table To Named Range
  • Compatibility Of Tables With Earlier Versions
  • Limitation of Excel Tables
  • Introduction to Charts
  • Understading elements of Chart
  • Activating Chart Elements
  • Major charts used in Industry
  • Visualizing data using Column Charts
  • Visualizing data using Bar Charts
  • Visualizing data using Line Charts
  • Visualizing data using Pie Charts
  • Creating Combination Chart
  • Changing Chart Themes
  • Using Picture in Charts
  • Introduction to Tiny Charts – Sparklines
  • Creating Column Sparklines
  • Creating Line Sparklines
  • Creating Win-Loss Sparklines
  • Introduction to Advanced Charting
  • Why PivotTables? 
  • Structuring Your Source Data 
  • Inserting Your First PivotTable 
  • Navigating the Field List 
  • PivotTable Options: "Analyze" & "Design" 
  • Selecting, Clearing, Moving & Copying Pivots 
  • Refreshing & Updating Pivots 
  • Generating New Report from PivotTable
  • Managing Grand Totals
  • PivotTable Subtotals
  • Dealing with Growing Source Data
  • Removing & Reviving Data from Cache 
  • How PivotTables Works?
  • Format Cells vs Number Format
  • PivotTable Number Formatting 
  • Automatically Formatting Empty Cells in PivotTable (Pro Tip)
  • Understanding Table Layouts & Styles 
  • Customizing Headers & Labels
  • Introduction to Data Sorting in PivotTable
  • PivotTable Sorting Options
  • Filtering Data in PivotTables
  • Filter using Wild Cards
  • Using Slicers & Timelines to Filter Data 
  • Controlling multiple Pivots using Slicers and Timelines
  • Working on PivotTable Grouping
  • Date Grouping in PivotTable
  • Grouping in Numbers and Text
  • Value Summarization Modes 
  • Working on "Show Values As" Calculations 
  • Performing custom calculations using Calculated Fields 
  • Calculations in Pivots vs. Raw Data 
  • Inserting a Calculated Item for combined calculation
  • The Solve Order & List Formulas Tools 
  • Introduction to PivotCharts 
  • Applying Slicers & Timelines to Multiple Charts 
  • Building dynamic dashboards using Slicer and Timeline
  • Consolidating data from multiple sheets in few seconds
  • Consolidating data from multiple files in few seconds
  • Creating custom Page in PivotTable
  • Splitting Data to Multiple Reports from huge data in seconds
  • Developing Dynamic Tutorial using Slicer and Pivot (Pro Tip)
  • Challenges in PivotTables - What Next?
  • Introduction to Excel Filter
  • Data Filtering Techniques
  • Introduction to Auto Filter
  • Auto Filter Checkbox
  • Filter using free text
  • Using predefined modes in Text Filter
  • Using predefined modes in Number Filter
  • Effectively using Custom Filters
  • Using Color Filtering
  • Conditional Formatting Icons Filtering
  • Filter using wild Cards
  • Refershing modified data while keeping Filter Intact
  • Challenges in Auto Filter
  • Introduction to Advance Filter
  • Exploring Advance Filter Dialog Box
  • Advance Filter Modes
  • Implementing AND, OR, NOT in Advance Filter
  • Advance Filter with basic calculation
  • Using Excel Functions in Advance Filter
  • Using Advance Filter as a Lookup Tool
  • Extracting unique list with Advance Filter
  • Clearing Filters
  • Introduction to Arrays
  • Introduction to Excel Array Formulas
  • Why and when to use Array Fomulas?
  • The internal logic behind Arrays
  • Concept of Logical Operators in Array Formulas
  • The CSE Method
  • Comparision Matrix with Excel conditional functions
  • Array Formulas using basic Excel Functions
  • How to create complex Array Formulas?
  • How to Master Array Formulas - What Next?
  • Introduction to What-If Analysis
  • Why and when to use What-If Analysis?
  • Working with Goal Seek for Reverse calculation
  • Multiple case studies on Goal Seek
  • Challenges in Goal Seek
  • Working with Data Table for Sensitivity analysis
  • Understanding 1 Variable and 2 Variables Data Table
  • Selection Mechanism in Data Table
  • Developing Bank Loan comparision analysis using Data Table
  • Working with Scenario Manager for Scenarios Management
  • Understanding Input & Output Variables in Scenario Manager
  • Bank Loan Scenario Management - Case Study
  • Introduction to Solver Add-In
  • Understanding Algorithms and Optimizations
  • Why and When to use Solver
  • Creating Business Models
  • Case Study - Resource Management
  • Case Study - Logistics Optimization
  • Case Study - Salary Management

Still thinking whether to buy this course ?

Let's get your doubts cleared.

How can I attend this training?

Once you make the payment, you will receive the credentials from our team to attend the training. As It will be a live classroom training, you will need these credentials to join the training. You can attend this training from any device - Laptop, Desktop, Tablet, Mobile.

How can I join Microsoft Excel Expert Course ?

You can join this Course by making ONLINE PAYMENT HERE. You can also deposit Cash / Cheque / NEFT to below account :-

Bank :- AXIS BANK
A/c Name : “Extrosoft Technology Private Limited”
Current A/c No : 919020020358803
IFSC Code : UTIB0000642
Branch : RADHAKRISHNA MARKET, PATEL CHOWK BIHAR

What about Doubts and Queries ?

As it will be an online classroom training, you can ask your queries in the same time as you do in a physical classroom training. You will really find it easy to learn and enjoy the training since they are designed with simple yet in-depth explanations.

Is this course a basic or advanced one ?

We cover everything from basic to advanced level. We will start from basic level with STEP by STEP and slowly slowly move to the advanced level. You don't have to do any Excel course in future.

Is it difficult to learn ?

Absolutely NOT. Topics are explained through step by step process in a very simple language which is easy for students to understand and learn. You just need to have basic knowledge of computers.

Any person who has no prior knowledge of computer can enroll for this program?

Yes

After completion of the Program, is there any certification for the program.

Yes, On successful passing in MCQ Format online examination, you will get soft copy of the course completion certificate once you complete the course.

What is Examination process?

Once you complete your course, you can appear for Online Exams which are in MCQ format.

What are the career prospects for a candidate after completing the course?

Become Job ready on completion of Course

Will I Get Refund?

If you don't get the value of your investment within 5 days of training completion just drop us a e-mail at contact@dikshanta.com and I'll initiate the 100 % refund immediately. There is absolutely ZERO risk for you. All risk on me, nothing to loose for you. Just telling, there is absolutely zero refund request due to quality until now

Let's Invest on your self learning..

Regular Fees ₹ 6000/-

₹ 1500

(Offer ends on 10-Jan-2021)
Training | Certification | Videos | Lifetime Support

DEMO COURSE VIDEO

Why Choose Us

The team has got 15 years experience in teaching and guiding the students to sustain and advance in their career path.

online-tool

Live online training

As it is a virtual classroom training, you can ask your queries in real time as you do in the physical classroom training. 

structure

Learn anytime, anywhere

Video recordings are done for all the classes. It helps you to revise the topics. It is also helpful if you miss a class.

low-cost

Attend from Anywhere

You can attend the training from anywhere in the world. You just have to login from any device to attend the class

trainers

Practice Files & Assignments

You will have the access to our google drive. After each class, we share you the files, assignments, videos, notes there

why-choose-us

REMEMBER.. "EDUCATION IS NOT AN EXPENSE : IT'S AN INVESTMENT"

JOIN OUR UPCOMING BATCH

Seats are limited. Choose the batch that suits you.

EVENING BATCH

Start Date :  10 January 2021

Days          :   Mon, Wed, Fri

Timing       :   07:00 PM to 08:00 PM

Duration   :   2 Months

Seats         :    30

EVENING BATCH

Start Date :  10 January 2021

Days          :   Tue, Thurs, Sat

Timing       :   09:00 PM to 10:00 PM

Duration   :   2 Months

Seats         :    30

Hurry ! Seats are limited

Let's Invest on your self learning..

Regular Fees ₹ 6000/-

₹ 1500

(Offer ends on 10-Jan-2021)
Training | Certification | Videos | Lifetime Support

Dikhanta-03

We offers a variety of courses - technology courses for IT students, career programs for students wanting to enter the IT sector, certification courses for IT professionals to enhance their career and basic IT programs for school students, housewives/senior citizens etc.

SALES QUERIES

REGISTERED OFFICE

Extrosoft Technology Private Limited
17/215, Teghra Begusarai
Bihar 851133, India

Scroll to Top
× Available on SundayMondayTuesdayWednesdayThursdayFridaySaturday