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 (20 Example)
• Subtotal (10 Example)
• 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
All types of Error in Excel
• Handling all types of error in excel like (#n/a, #name, #ref, #values, #num, #null, #div)
• Circular reference.
• Iserr (1 types of example)
• Isna (1 types of example)
• Iserror (5 types of example)
• Iferror (5 types of example)
All types of Calculation Function
• Count (10 types of example)
• Counta (1 types of example)
• Countblank (1 types of example)
• Countif (20 types of example)
• Countifs (10 types of example)
• Sum (30 types of example & array)
• Sumif (10 types of example)
• Sumifs (10 types of example)
• Sumproduct (40 types of example)
• Average (3 types of example)
• Averageif (3 types of example)
• Averageifs (2 types of example)
• Min (5 types of example)
• Max (5 types of example)
• Small (5 types of example)
• Large (5 types of example)
• Aggregate (10 types of example)
• Rank (1 types of example)
• Frequency (2 types of example)
• And many more function
All types of logical function
• If (20 types of example & array)
• Or (5 types of example)
• And (5 types of example)
• True (1 types of example)
• False (1 types of example)
• Not (1 types of example)
All types of the date function
• Date (1 types of example)
• Time (1 types of example)
• Edate (3 types of example)
• Eomonth (3 types of example)
• Month (2 types of example)
• Weekday (10 types of example)
• Weeknum (10 types of example)
• Networkdays (1 types of example)
• Datedif (3 types of example)
• Datevalue & Timevalue (1 example of each)
• 3 types of the calendar by using the above function
All types of text function
• Left (5 types of example)
• Right (5 types of example)
• Mid (10 types of example)
• Substitute (10 types of example)
• Replace (3 types of example)
• Find (5 types of example)
• Search (5 types of example)
• Len (5 types of example)
• Rept (5 types of example)
• Text (5 types of example)
• Other text function
All types of lookup function
• Choose (5 types of example)
• Indirect (20 types of example)
• Address (5 types of example)
• Match (5 types of example)
• Hyperlink (3 types of example)
• VLookup (50 types of example)
• Hlookup (20 types of example)
• Lookup (20 types of example)
• Index (40 types of example)
• Offset (50 types of example)
• Array function
Data analysis tools
• Pivot table (20 types of example)
• 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 (20 types of example)
Dynamic chart & dashboard

  • Dynamic chart (10 types of example)
  • 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 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 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

2 Months (Sat to Sun – 2 Hours Class 9:00 AM to 8:00 PM) and (Mon to Fri – 1 Hour Class 8:00 AM to 10 AM) online classes.

 Fees: – 6000 INR/

 Class Videos, Notes, PDF Books

ADVANCED EXCEL & MIS

 

Leave a Reply

Your email address will not be published. Required fields are marked *