apply now

about course

As in modernization, every organization works on databases to analyze and visualize the things in the organization. Excel includes a large number of cells to format and manipulate the data and solve mathematical functions. You can organize the data in the spreadsheet using formulas, pivot tables, and graphic tools to present data. Excel helps to sort the data speedily and accurately with a comprehensive set of tools, using logical and look-up excel functions to transform, link, and analyze the data.

software that you will learn in this course

course content

1) EXCEL INTRODUCTION

1. An overview of the screen, navigation and basic spreadsheet concepts
2. Various selection techniques
3. Shortcut Keys

2) CUSTOMIZING EXCEL

1. Customizing the Ribbon
2. Using and Customizing AutoCorrect
3. Changing Excel's Default Options

3) ADVANCE EXCEL: FORMULAS & FUNCTIONS

1. Mathematical Operations: Sum, Product, Power, Sqrt, Mod, Aggregate
2. Conditional Sums: Sumif, Sumifs Advanced Mathematical Operations: Sumproduct, Su7nsq, Series sum.
3. Other Operations: Round, Roundup, Round down
4. Rand, Randbetween, Fact, Roman
5. Data Lookup Functions: Vlookup, Hlookup
6. Lookup, Choose, Match, get pivot data. Logical Functions: And, Or, Not, If, Iferror, Ifna, True, False.
7. Cell/Range: Address, Index, Index, Offset
8. Other Hyperlink, Transpose, Formula text
9. Day, Hour, Minute, Month, Networkdays, Now, Second, Today, Weekday, Year
10. Networkday.intl, Weeknum, Days360, Edate, EOMonth
11. Pmt, Ppmt, Ipmt, PV, Fv, Rate
12. . Iserror, Iserr, Isna.Error.Type, Isref, Iseven, Isodd, Isnumber, N, Isblank. Row, Column, Rows, Columns, Areas.
13. Max, Min, Count, Counta, Countblank, Countif, Countifs
14. Average, Averageif, Mode.sngl
15. Mode.mult, Frequency, Rank, Rank.eq
16. Len, Left, Right, Mid, Lower, Upper, Proper, rept.
17. Substitute, Trim, concatenate,value, find, Replace, Char, Code

4) FORMATTING AND PROOFING

1. Currency Format
2. Format Painter
3. Formatting Dates
4. Custom and Special Formats
5. Formatting Cells with Number formats, Font formats, Alignment, Borders, etc
6. Basic conditional formatting

5) Advanced Paste Special Techniques

1. Paste Formulas, Paste Formats
2. Paste Validations
3. Transpose Tables

6) Sorting and Filtering

1. Filtering in Text, Numbers & Colors
2. Sorting Options
3. Advanced Filters on 15-20 different criteria(s)

7) Printing Workbooks

1. Setting Up Print Area
2. Customizing Headers & Footers
3. Designing the structure of a template
4. Print Titles - Repeat Rows / Columns

8) What if Analysis

1. Goal Seek
2. Scenario Analysis
3. Data Tables (PMT Function)
4. Solver Tool

9) Data Validation

1. Number, Text, Date & Time Validation
2. Custom validations based on formula for a cell
3. Dynamic Dropdown List Creation using Data Validation-Dependency List
4. Print Titles - Repeat Rows / Columns

10) Pivot Tables

1. Creating Simple Pivot Tables
2. Basic and Advanced Value Field Setting
3. Classic Pivot table
4. Choosing Field
5. Filtering Pivot Tables
6. Modifying PivotTable Data
7. Grouping based on numbers and Dates
8. Calculated Field & Calculated Items
9. Arrays Functions
10. What are the Array Formulas, Use of the Array Formulas?
11. Basic Examples of Arrays (Using ctrl+ shift+enter).
12. Array with if, len and mid functions formulas.
13. Array with Lookup functions.
14. Advanced Use of formulas with Array.

11) Charts and slicers

1. Various Charts i.e. Bar Charts / Pie Charts / Line Charts
2. Using SLICERS, Filter data with Slicers
3. Manage Primary and Secondary Axis

12) Excel Dashboard

1. Planning a Dashboard
2. Adding Tables and Charts to Dashboard
3. Adding Dynamic Contents to Dashboard

jobs You’ll get after completing the course

Excel becomes an important tool and is always in demand by various organizations or institutions. People who specialize in using excel can work in MNC companies or either work as full-time employees or as a freelancer. Advance excel course opens up multiple career options that you can choose as your career path and get a higher handsome salary package, Below are some excel fields that you can choose for yourself after doing this course.

job profile after completing this course	average salary ( 1+ year experience )
data analyst	36k - 94k
data analyst	36k - 94k
MIS executive	36k - 94k
market research analyst	30k - 64k
project managers and coordinators	38k - 117k
metrics and analytics specialist	66k - 120k

features & facilites

backup class

frees installment

100% job assistance

live project

flexible timing

expart trainer

free library

practical larning