Datanalytics

Home

❯

Excel

Folder: Excel

15 items under this folder.

  • Nov 03, 2025

    2.1-Formula and Function

    • DataAnalysis
    • Excel
    • Reference
    • VALUE
    • REF
    • DIV/0
    • N/A
  • Nov 03, 2025

    1.2-Introduction to Data Analytics

    • Oct 31, 2025

      5.2-Power Query Creating data model

      • Oct 30, 2025

        1.3-Data Structure and Conditional Formatting

        • Oct 30, 2025

          1.4-Fill Handler & Data Manipulation Guide

          • Oct 30, 2025

            2.2-VLOOKUP, HLOOKUP & SUMIFS...

            • N/A
            • REF
          • Oct 30, 2025

            2.3-Advanced VLOOKUP and Filters Techniques

            • N/A
          • Oct 30, 2025

            2.4-What If and Data Preparation

            • Oct 30, 2025

              3.1-Pivot Table Introduction and Data mapping

              • Oct 30, 2025

                3.2-Pivot Table Analysis Creation, Formatting, What If Analysis

                • Oct 30, 2025

                  4.1-Power Pivot & Power BI, Understanding Table Structure

                  • Oct 30, 2025

                    4.2-Power Pivot, Using few DAX functions

                    • Oct 30, 2025

                      5.1-Power Query Introduction

                      • Oct 30, 2025

                        6.1-DashBoard Creation with Power Pivot, Power Query and DAX

                        • Oct 30, 2025

                          6.2-Dashboard Creation and Discussion


                          Created with Quartz v4.5.2 © 2025

                          • GitHub
                          • Discord Community