- Home
- Courses
- Project Management
- Data Analysis
Curriculum
- 48 Sections
- 292 Lessons
- 40 Weeks
Expand all sectionsCollapse all sections
- Orientation Guide1
- Graduation Ceremony1
- MID TERM TEST2
- Final Exams4
- Real Class Sessions Beginner Excel 202316
- 5.2Study Materials30 Weeks
- 5.3Study Materials 218 Weeks
- 5.4Classroom: Introduction Day and Class of Saturday 25th of Feb, 20236 Hours
- 5.5Classroom: Sunday Class of 26th of Feb, 20236 Hours
- 5.6Classroom: Thursday Class of March 2, 20233 Hours
- 5.7Classroom: Saturday Class of March 4th, 20236 Hours
- 5.8Classroom: Sunday Class of March 5, 20235 Hours
- 5.9Classroom: Thursday Class of March 9, 20232 Hours
- 5.10Classroom: Saturday Class of March 11, 20236 Hours
- 5.11Classroom: Sunday Class of March 12, 20236 Hours
- 5.12Classroom: Thursday Class of March 16, 20232 Hours
- 5.13Classroom: Saturday Class of March 18, 20236 Hours
- 5.14Classroom: Sunday Class of March 19, 20236 Hours
- 5.15Classroom: Class of Thursday 23rd of March, 20232 Hours
- 5.16Classroom: Saturday Class of March 25, 20236 Hours
- 5.17Sunday Class of March 26, 20236 Hours
- Real Class Sessions Intermediate Excel 202314
- 6.1Classroom: Sunday Class of March 26, 20236 Hours
- 6.2Classroom: Thursday Class of March 30, 20232 Hours
- 6.3Classroom: Saturday Class of April 1, 20236 Hours
- 6.4Classroom: Sunday Class of April 2, 20236 Hours
- 6.5Classroom: Saturday Class of April 8, 20235 Hours
- 6.6Classroom: Sunday Class of April 9, 20235 Hours
- 6.7Classroom: Thursday Class of April 13, 20232 Hours
- 6.8Classroom: Saturday Class of April 15, 20235 Hours
- 6.9Classroom: Sunday Class of April 16, 20235 Hours
- 6.10Classroom: Thursday Class of April 20, 20232 Hours
- 6.11Classroom: Saturday Class of April 22, 20235 Hours
- 6.12Classroom: Sunday Class of April 23, 20236 Hours
- 6.13Classroom: Class of Thursday 27th of March, 20232 Hours
- 6.14Classroom: Saturday Class of April 29, 20235 Hours
- Real Class Sessions Advanced Excel 20239
- 7.1Classroom: Sunday Class of April 30, 20236 Hours
- 7.2Classroom: Thursday Class of May 04, 20232 Hours
- 7.3Classroom: Saturday Class of May 06, 20236 Hours
- 7.4Classroom: Sunday Class of May 07, 20236 Hours
- 7.5Classroom: Thursday Class of May 11, 20231 Hour
- 7.6Classroom: Saturday Class of May 13, 20235 Hours
- 7.7Classroom: Sunday Class of May 14, 20235 Hours
- 7.8Classroom: Thursday Class of May 18, 20232 Hours
- 7.9Classroom: Saturday Class of May 20, 20235 Hours
- Real Class Sessions Power BI 202313
- 8.1Classroom: Sunday Class of May 21, 20235 Hours
- 8.2Classroom: Thursday Class of June 1, 20232 Hours
- 8.3Classroom: Saturday Class of June 3, 20236 Hours
- 8.4Classroom: Sunday Class of June 4, 20236 Hours
- 8.5Classroom: Thursday Class of June 8, 20232 Hours
- 8.6Classroom: Saturday Class of June 10, 20236 Hours
- 8.7Classroom: Sunday Class of June 11, 20236 Hours
- 8.8Classroom: Thursday Class of June 15, 20232 Hours
- 8.9Classroom: Saturday Class of June 17, 20236 Hours
- 8.10Classroom: Sunday Class of June 18, 20236 Hours
- 8.11Classroom: Thursday Class of June 22, 20232 Hours
- 8.12Classroom: Saturday Class of June 24, 20236 Hours
- 8.13Classroom: Sunday Class of June 25, 20236 Hours
- Real Class Sessions Tableau 202310
- 9.1Classroom: Thursday Class of June 29, 20232 Hours
- 9.2Classroom: Saturday Class of July 01, 20235 Hours
- 9.3Classroom: Sunday Class of July 02, 20236 Hours
- 9.4Classroom: Thursday Class of July 6, 20232 Hours
- 9.5Classroom: Saturday Class of July 08, 20236 Hours
- 9.6Classroom: Sunday Class of July 09, 20236 Hours
- 9.7Classroom: Thursday Class of July 13, 20232 Hours
- 9.8Classroom: Saturday Class of July 15, 20236 Hours
- 9.9Classroom: Sunday Class of July 16, 20236 Hours
- 9.10Classroom: Thursday Class of July 20, 20232 Hours
- Real Class Sessions SQL 20235
- Resume and Interview Preparation1
- STUDY MATERIALS2
- ASSIGNMENTS0
- Real Practice Group Session3
- INTRODUCTION TO EXCEL5
- UNDERSTANDING EXCEL'S INTERFACE/FEATURES6
- BASIC TERMINOLOGIES USED IN EXCEL13
- FUNDAMENTALS TO DATA ENTRY IN EXCEL2
- BASIC EXCEL FORMULAE6
- REFERENCES IN EXCEL FORMULAS3
- FUNCTIONS IN EXCEL5
- MODIFYING YOUR WORKSHEET IN EXCEL7
- 22.1Modifying Rows, Columns, and Cells
- 22.2Change the Height and Width of rows and columns in your worksheet
- 22.3Wrap text and Line Breaks in cells
- 22.4Merge Cells in Excel
- 22.5Centering Across Selection
- 22.6Insert, Move, Hide/Unhide, and Copy a whole worksheet Name, Rename your worksheet
- 22.7Delete your Worksheet(s)
- DATA FORMATTING12
- 23.1What “formatting” in excel mean
- 23.2Importance of formatting excel worksheets and cells
- 23.3Ways to Format Cells within Excel
- 23.4Styling Elements
- 23.5Data Alignment within the Cell(s)
- 23.6Shading, Background Colors, and Text colors in the cell
- 23.7Format Painter – Formatting made Faster
- 23.8Borders of the Cell(s)
- 23.9Formatting numbers. Categories in the number section
- 23.10Data turned into Table
- 23.11How to Use Conditional Formatting
- 23.12Custom theme for a new workbook
- ADVANCED FORMATTING IN EXCEL5
- BASIC DATA VISUALIZATION TOOLS IN EXCEL7
- SECURITY AND PROTECTION IN EXCEL5
- HOW TO PRINT YOUR WORKSHEET6
- ALL ABOUT EXCEL TEMPLATES5
- BONUS - SECRET TIPS/TRICKS TO BECOMING AN EXCEL PROFESSIONAL0
- MICROSOFT EXCEL INTERMEDIATE - EXCEL LIST11
- 30.1Understanding List Structure – what to do and avoid doing
- 30.2Multi-Level Excel Data Sorting
- 30.3Sorting Dates Data
- 30.4Using Sorting to Delete blank rows,
- 30.5Custom Sorting in Excel
- 30.6Single-Level Excel Data Sorting
- 30.7Filter – What is a Filter in Excel?
- 30.8Filtering Data with the AutoFilter
- 30.9Using the Advanced Filter
- 30.10Filtering Based on a Single Condition
- 30.11Filtering Based on Multiple Conditions and Columns
- EXCEL LIST FUNCTIONS6
- EXCEL DATA VALIDATION10
- 32.1Understanding Data Validation – what is this about? When is data validation useful?
- 32.2How to Validate Data in Excel
- 32.3Data Validation Examples
- 32.4How to Edit Data Validation in Excel
- 32.5How to Copy Data Validation rules to other cells in Excel
- 32.6Finding Cells with Data Validation
- 32.7How to Remove Data Validation
- 32.8How to Validate an Entry based on another cell
- 32.9How to Create your very own Meaningful Error Message(s)
- 32.10Data Validation Tips
- IMPORTING AND EXPORTING DATA7
- PIVOT TABLES9
- 34.1Understanding Pivot Tables? Why Pivot Tables? Benefits
- 34.2Inserting Pivot Table
- 34.3Formatting Data with Pivot Tables
- 34.4Sorting Data with Pivot Tables
- 34.5Filtering Data with Pivot Tables
- 34.6Grouping Data with Pivot Tables
- 34.7Refreshing Pivot Tables
- 34.8How to Design and Improve pivot table
- 34.9Deleting an Excel Pivot Table
- POWER PIVOT TOOLS - DATA MODELING IN EXCEL AND POWERFUL DATA ANALYSIS9
- 35.1Introduction to Excel Power Pivot
- 35.2The power behind the Power Pivot Tool – Power Pivot vs Basic Excel
- 35.3How to get and Install the Power Pivot Add-in
- 35.4Importing CSV files to the Data Mode
- 35.5Viewing the Data Model in Power Pivot
- 35.6Create Relationships between the tables
- 35.7Create a PivotTable from Data Models
- 35.8Power Pivot KPIs
- 35.9Data Analysis Expressions (DAX)
- USING SLICERS IN EXCEL0
- LARGE DATASETS OF EXCEL DATA4
- MICROSOFT EXCEL - ADVANCED0
- ADVANCED LOGIC AND CONDITIONAL EXCEL FUNCTIONS5
- LOOKUP FUNCTIONS IN EXCEL0
- VSTACK FUNCTION IN EXCEL0
- POWER QUERY10
- BONUS TOPICS2
- TABLEAU - BEGINNER TO ADVANCED LEVEL12
- 44.1Introduction to Tableau, Data Visualization, and Analytics
- 44.2Components of Tableau
- 44.3Download Tableau Desktop. Installation of the Software
- 44.4Getting started – Data Visualization using Tableau
- 44.5Why use Tableau? What makes it attractive?
- 44.6Connecting to various data sources
- 44.7Shelves and cards in detail
- 44.8Functions in Tableau
- 44.9Creating basic Charts and reports
- 44.10Table and Cross Tab reports
- 44.11Annotations
- 44.12Creating Calculated Columns
- Advancing with Tableau - Advanced Calculations and Functions Improving Dashboards6
- IMPROVE DASHBOARDS7
- POWER BI SECTION 118
- 47.1Introduction to Power BI
- 47.2Power BI Desktop Installation
- 47.3Different types of charts
- 47.4Basic Charts in Power BI
- 47.5Overview of Power BI Desktop
- 47.6How to Create a Map in Power BI
- 47.7Table and Matrix
- 47.8Subtotal and Total in Matrix
- 47.9Other Charts in Power BI
- 47.10Cards and Filters
- 47.11Slicers
- 47.12How to build Power BI Dashboards
- 47.13How Data types and Data Sets work
- 47.14Power BI Query Editor
- 47.15DAX Series
- 47.16Demo on Generating a Power BI Report
- 47.17Power Query
- 47.18Data Transformations Using Power Queries
- POWER BI CURRICULUM SECTION 214
- 48.1Renaming Tables
- 48.2Promoting the First Row
- 48.3Data Shaping
- 48.4Introduction to Enhancing Data Structure
- 48.5Introduction to Designing a Data Model
- 48.6Working with Tables
- 48.7Fact vs Dimension
- 48.8Breaking Down Tables
- 48.9Creating Hierarchy
- 48.10Relationships aka Cardinality
- 48.11Creating Relationships
- 48.12Reviewing the Model Interface
- 48.13Creating RLS Roles in Desktop
- 48.14Assigning Users to RLS Roles in Service