Error Page

MS EXCEL (BASIC - ADVANCE)

• Data Types, Tabs & Complete Ribbon
• Basic Formatting (Data Validations, Conditional Formatting, Filters, FIND & REPLACE, Sorting etc.)
• Basic to Intermediary Calculations (SUM, SUMIF, COUNTIF, COUNTIFS, MAX, MIN, MAXIFS, MINIFS, etc.)
• Basic to Intermediary Lookup Functions (LOOKUP, VLOOKUP, HLOOKUP, XLOOKUP, etc.)
• #ERRORS in EXCEL & Validations for them
• Basic to Advanced Charts & Graphs (PLOTS, COMBI CHARTS, BAR CHARTS, etc.)
• Advanced Formulas & Functions (DATE/TIME Functions, NESTED FUNCTIONS, ARRAY FUNCTIONS, FINANCIAL FUNCTIONS, REAL WORLD CALCULATIONS)

MS POWERPOINT (BASIC - ADVANCE)

• PowerPoint Options, Tabs, Complete Ribbon
• PowerPoint Aesthetics, Layouts, Charts, Shapes & Gradients
• Intermediary to Advanced: Attachments (Audio & Videos), Hyperlinking, Custom Buttons, Macros for PPTs, recording PPTs, etc.

POWER BI (BASIC - ADVANCE)

• Understanding Power BI, Power BI Desktop, Power BI Service & Mobile
• Navigating and setting up personal Power BI environment
• Understanding different Databases (JSONs, Dataverse, Power BI Dataset, OData Feed, SharePoint)
• Preparing Data for Analysis in Excel (Data Cleaning & Data Formatting included
• ETL (Extract, Transform & Load) hardwiring for every Dashboard.
• Power Query & Data Cleaning & Formatting using Power Query
• Advanced: Different Views to navigate and setup Dashboard visualization (Report View, Table View & Model View)
• Understanding & Setting up Unilateral, Bilateral & Multilateral Connections using Model View for smooth flow of data and visualizations.
• Connections to established Databases using Power BI Service

REAL-WORLD CALCULATIONS & TOPICS (MORE in our Syllabus Attachment)

REAL-WORLD DASHBOARDS (BASIC - ADVANCE)

Please feel free to go through our curriculum & decide. Once you do, we're here to help you throughout the journey. Looking forward to seeing you in our sessions!

Thank you!

From TEAM EXCELZONE