ADVANCED EXCEL & MIS
• Introduction of MIS.
• Introduction of ad-hoc reporting & routine reporting.
• Basic & advance excel training.
• Dashboard training.
• Interview tips.
• PDF file & Videos.
Basic & Advance Excel
• Introduction of excel.
• Introduction of different excel version and features.
• Save file in different format (.xlsx, .xlsm, .xls, .xlsb, .xltx, .xltm, .xlt, .pdf and many more).
• Paste special.
• GoTo special.
• Fill series.
• Conditional formatting (with wizard & with function).
• Cell formatting & number formatting.
• Sort & Filter.
• Find & Select.
• Basic and Advanced Filter.
• Hyperlink (wizard & function).
• Flash Fill.
• Text to Column (Delimited & Fixed Width)
• Remove Duplicate 
• Data Validation  (wizard & function)
• Subtotal
• Print excel sheet.
• Slicer in the Pivot Table.
• Import & export data from excel to other application.
• Goal Seek.
• Data table.
• Customize excel.
• And many more basic tricks.
Protection & Security
• Cells & range protection
• Content & formula protection
• Worksheet protection
• Workbook protection
• Track changes
• Share workbook
Error in Excel
• Handling all types of error in excel like (#n/a, #name, #ref, #values, #num, #null, #div)
• Circular reference.
• Iserr
• Isna
• Iserror
• Iferror
Mathematical Function
• Count
• Counta
• Countblank
• Countif
• Countifs
• Sum
• Sumif
• Sumifs
• Sumproduct
• Average
• Averageif
• Averageifs
• Min
• Max
• Small
• Large
• Aggregate
• Rank
• Frequency
Logical function
• If and Nested If
• Or
• And
• True
• False
• Not
Date & Time function
• Date
• Time
• Edate
• Eomonth
• Month
• Weekday
• Weeknum
• Networkdays
• Datedif
• Datevalue & Timevalue
• Make a calendar by using the above function
Text function
• Left
• Right
• Mid
• Substitute
• Replace
• Find
• Search
• Len
• Rept
• Text
Lookup function
• Choose
• Indirect
• Address
• Match
• Hyperlink
• VLookup
• Hlookup
• Lookup
• Index
• Offset
• Array function
Data analysis tools
• Pivot table
• All Pivot Table function & features.
• Pivot table from multiple worksheet & multiple workbooks using SQL query at a time.
• Pivot table from MS Access.
• Pivot table from SQL server.
• Pivot chart
Dynamic chart & dashboard

  • Dynamic chart
  • Dashboard

MS Excel Power BI Tools
• An Overview of Power BI Tools.
• Introduction of Power Query.
• Introduction of Power view.
• Introduction of Power Pivot
• Introduction of Power map.
• Creating KPI
• Interview Tips.
• PDF File & Videos.

Power Query
• Installing a Power Query.
• Creating a Power Query.
• Options of Loading Data.
• Creating Data Transforms.
• Editing Queries.
• Getting the initial data.
• Initial transforms to prepare the data.
• Splitting Columns, Merging Columns.
• Creating Custom Columns.
• Indexing Rows.
• Grouping and pivoting data
Power Pivot
• Importing SQL Server tables
• Importing Access and Excel data
• Using Filter into rows/columns
• Using Data and diagram view
• Hiding from the client view
• Create Relationships
• Creating a Pivot Table from Power Pivot.
• Adding to data models.
• Using the function in the pivot table
• Creating hierarchies
Power View
• Enabling Power View, and quick an overview.
• Creating Power View from Tables.
• Using Filter Slicer, Views and Tiles.
• Insert image and text boxes.
• Creating Charts.
• Formatting Charts.
• Using Different Types of Charts.
Power Map
• Enabling Power Map, and quick an overview.
• Creating a Power Map from Tables.
• Editing Power Map.
• Using the Map Layout option.
• Using multiple Map

Course duration & fees.

Learn VBA & Macro

3 Months (Sat or Sun – 2 Hours Class, Morning 9:00 AM to Evening 7:00 PM) online classes.

 Fees: – 7000 INR/

 Class Videos, Notes, PDF Books

ADVANCED EXCEL & MIS