Ratna Deep Paul Excel & Power Bi
No reviews yet

Fantastic! I can help you design a comprehensive curriculum for learning Excel and Power Bi. Here's an overview of how I would structure the lessons from basic to advanced topics for both Excel and Power BI.

Part 1: Excel Mastery
Module 1: Excel Basics

Introduction to Excel: Overview of the interface, workbook structure, navigation, and key tools.
Data Entry and Formatting: Entering data, basic cell formatting (fonts, colors, alignment, borders, number formats), and basic operations like copy, paste, and fill.
Basic Formulas and Functions:
Arithmetic Operations: SUM, AVERAGE, MIN, MAX, etc.
Basic Logical Functions: IF statements.
Relative and Absolute References.
Module 2: Intermediate Excel

Working with Data: Sorting, filtering, data validation, and conditional formatting.
Lookup Functions:
VLOOKUP, HLOOKUP, and XLOOKUP.
INDEX and MATCH for more dynamic lookups.
Text Functions: LEFT, RIGHT, MID, CONCATENATE, TEXT, etc.
Date and Time Functions: TODAY(), NOW(), DATE(), and more.
Module 3: Advanced Excel

Advanced Functions:
SUMIFS, COUNTIFS, ARRAYFORMULA functions.
INDIRECT, OFFSET, and CHOOSE.
Pivot Tables and Pivot Charts: Data analysis using pivot tables, creating pivot charts, and grouping and filtering in pivot tables.

Part 2: Power BI Mastery
Module 1: Power BI Basics

Introduction to Power BI: Overview of the interface, connecting data sources, and understanding data models.
Data Importing and Cleaning: Importing from Excel, databases, and other sources. Using Power Query to clean and transform data.
Basic Visualizations: Creating simple visualizations like bar charts, pie charts, and tables.
Module 2: Data Modeling in Power BI

Understanding Relationships: Creating relationships between tables, cardinality, and cross-filtering directions.
Power BI Service:
Publishing reports and dashboards to Power BI Service.
Sharing reports with others and setting up workspaces.
Scheduling data refresh and configuring security roles.

Subjects

  • Power BI dashboard Beginner-Expert

  • Excel Advanced Beginner-Expert

Experience

  • Data Analytic/Area Sales Manager (Dec, 2023–Mar, 2024) at I am a Data Analyst and Sales Manager in Forcefox India Pvt Ltd
    I have appointed as a Area Sales Manager, and looking for Northeast Assam,Meghalaya,Tripura Sales Growth, where I have to make a daily report in Excel, and also making the Dashboard in Power Bi to summarize every month Data which shows the exact position of the company...

    Here, In Teacheron Platform where I can explore all my ground level experience which is also related and helpful for making practical report by using Excel and Power Bi.

Education

  • BACHAELOR OF ARTS (Jul, 2012–Jun, 2015) from I.G.N.O.U from Shillong–scored 2nd Div

Fee details

    ₹500–1,000/hour (US$5.90–11.79/hour)

    Online Mode Of Teaching

Reviews

No reviews yet. Be the first one to review this tutor.