Join our comprehensive Excel and Power BI training program, designed for professionals who want to master data analysis and visualization; this expert-led course covers everything from the basics of Excel functions and formulas to advanced Power BI techniques, including data modeling, DAX calculations, and creating interactive dashboards, ensuring you gain the skills needed to transform raw data into actionable insights, enhance your decision-making capabilities, and boost your career prospects; with hands-on exercises, real-world examples, and personalized support, you’ll learn how to efficiently manage and analyze large datasets, automate repetitive tasks, and present your findings in a visually compelling manner, making you an invaluable asset to any organization; don’t miss this opportunity to elevate your data skills and stay ahead in the competitive job market—enroll now and start your journey towards becoming a data expert!
For any doubts regarding the lessons, please reply via email only to support@rowscolumns.com. We will check and respond ASAP.
We are happy to assist with course-related queries. However, the service-related inquiries are offering as the paid consultation and recommend reaching out to “consulting@rowscolumns.com”.
Kindly note that upon enrollment, the course fee is fully non-refundable.
Course Content
Module 1 – Getting Started in Excel
You don't currently have access to this content
Module 2 – Excel Essentials
You don't currently have access to this content
Module 3 – Managing Worksheets
You don't currently have access to this content
Module 4 – AutoFill – Custom List – Table
You don't currently have access to this content
Module 5 – Excel Formulas & What To Be Aware Of
You don't currently have access to this content
Module 6 – Logical Formulas
You don't currently have access to this content
Module 7 – Logical Formulas (Part-2)
You don't currently have access to this content
Module 8 – Data Analysis & Validation
You don't currently have access to this content
Module 9 – Data Management System
You don't currently have access to this content
Module 10 – Data Management System (Part-2)
You don't currently have access to this content
Module 11 – Lookup & Reference Formulas
You don't currently have access to this content
Module 12 – Lookup & Reference Formulas (Part-2)
You don't currently have access to this content
Module 13 – Data Analysis with Pivot Table
You don't currently have access to this content
Module 14 – Data Analysis with Pivot Table (Part-2)
You don't currently have access to this content
Module 15 – Conditional Formatting Essentials
You don't currently have access to this content
Module 16 – Conditional Formatting (Part-2) +page setting & Password Management
You don't currently have access to this content
Module 17- Other Various Features & Assignment.
You don't currently have access to this content
Module 17.1 – Getting Started With PowerBI
You don't currently have access to this content
Module 17.2 – Power BI Components
You don't currently have access to this content
Module 17.3 – A Case Study (HR Analytical Report)
You don't currently have access to this content
Module 17.4 – Case Study (Comparison Report)
You don't currently have access to this content
Module 17.5 – A Case Study (Sales Analytics Report)
You don't currently have access to this content
Module 18.1 – Power Query Interface
You don't currently have access to this content
Module 18.2 – Column Transformation
You don't currently have access to this content
Module 18.3 – Row Transformation
You don't currently have access to this content
Module 18.4 – Text Transformation
You don't currently have access to this content
Module 18.5 – Number Transformation
You don't currently have access to this content
Module 18.6 – Date Transformation
You don't currently have access to this content
Module 18.7 – Conditional Transformation
You don't currently have access to this content
Module 18.8 – Data Consolidation in Power BI
You don't currently have access to this content
Module 18.9 – Data Consolidation in Excel
You don't currently have access to this content
Module 18.10 – A Case Study (Financial Statement)
You don't currently have access to this content
Module 18.11 – Case Study (Payroll Data)
You don't currently have access to this content
Module 18.12 – Case Study (Invoice Data)
You don't currently have access to this content
Module 18.13 – Power Query in Excel Overview
You don't currently have access to this content
Module 19.1 – Power Pivot – Data Modeling with Star Schema
You don't currently have access to this content
Module 19.2 – Case Study (Sales Analysis)
You don't currently have access to this content
Module 19.3 – Snow Flake Schema
You don't currently have access to this content
Module 19.4 – Introduction to Dax
You don't currently have access to this content
Module 19.5 – Dax Operators
You don't currently have access to this content
Module 19.6 – Logical Function
You don't currently have access to this content
Module 19.7 – Text Function
You don't currently have access to this content
Module 19.8 – Dax Date & Time (Part -1)
You don't currently have access to this content
Module 19.9 – Date & Time Function (Part-2)
You don't currently have access to this content
Module 19.10 – Math Function
You don't currently have access to this content
Module 19.11 – Statistics Function
You don't currently have access to this content
Module 19.12 – Filter Function-Calculate
You don't currently have access to this content
Module 19.13 – Filter Function – Filter
You don't currently have access to this content
Module 19.14 – Filter Function – All
You don't currently have access to this content
Module 19.15 – Filter Function – Related
You don't currently have access to this content
Module 19.16 – Time Intelligence Function (Part 1)
You don't currently have access to this content
Module 19.17 – Time Intelligence Function (Part 2)
You don't currently have access to this content
Module 19.18 – Time Intelligence Function (Part 3)
You don't currently have access to this content
Module 19.19 – Power BI Dax Overview with 2 Business Cases
You don't currently have access to this content
Module 19.20 – Measures vs Calculated Columns
You don't currently have access to this content
Module 20.1 – Introduction to Power View
You don't currently have access to this content
module 20.2 – Filtering Features
You don't currently have access to this content
Module 20.3 – Hierarchy Reports
You don't currently have access to this content
Module 20.4 – Slicer Visualization
You don't currently have access to this content
Module 20.5 – Categorical visualization (Part 1)
You don't currently have access to this content
Module 20.6 – Categorical visualization (Part 2)
You don't currently have access to this content
Module 20.7 – Trend Visualization
You don't currently have access to this content
Module 20.8 – Bookmark & Selection Pane
You don't currently have access to this content
Module 20.9 – Grouping-Binning-Sorting
You don't currently have access to this content
Module 20.10 – KPI Visuals
You don't currently have access to this content
Module 20.11 – Map Visuals
You don't currently have access to this content
Module 20.12 – Table visualization
You don't currently have access to this content
Module 21.1 -Power BI Service – Data Sharing in Different Ways
You don't currently have access to this content
Module 21.2 – Row-level security (RLS)
You don't currently have access to this content
Module 21.3 – Top Tricks in Power BI
You don't currently have access to this content
PBI Project – 1
You don't currently have access to this content
PBI Project – 2
You don't currently have access to this content
PBI Project – 3
You don't currently have access to this content
