TOIT Training

Log in

Menu
Contact Sales
Roadmap

Data Analytics With Excel

Last updated: May 6, 2026

Overview

Emily Taylor will show you how to create pivot tables for dynamic data insights in Excel. The session will include writing essential functions to streamline data processing and cleaning data using Power Query Editor, while also covering quick data modeling and how to utilize Power Pivot.

Curriculum

  • 20 Sections
  • 0 Lessons
  • 88 Minutes
Expand all sectionsCollapse all sections
  • 01. Introduction
    0
    • 02. Why Use DAX?
      0
      • 03. CALENDAR
        0
        • 04. CALENDARAUTO
          0
          • 05. DATE
            0
            • 06. DATEDIFF
              0
              • 07. DATEVALUE
                0
                • 08. DAY
                  0
                  • 09. EDATE
                    0
                    • 10. EOMONTH
                      0
                      • 11. MONTH, QUARTER, YEAR
                        0
                        • 12. HOUR, MINUTE, SECOND
                          0
                          • 13. NOW, TODAY
                            0
                            • 14. WEEKDAY, WEEKNUM
                              0
                              • 15. TIME
                                0
                                • 16. TIMEVALUE
                                  0
                                  • 17. UTCNOW, UTCTODAY
                                    0
                                    • 18. NETWORK DAYS
                                      0
                                      • 19. YEARFRAC
                                        0
                                        • 20. Class Wrap Up
                                          0

                                          Instructor

                                          User Avatar
                                          ToIT
                                          2 Students
                                          1351 Courses
                                          course thumbnail
                                          Free
                                          Student:
                                          0 Students
                                          Lesson:
                                          0 Lessons
                                          Duration: 88 Minutes
                                          Quiz:
                                          0 Quizzes
                                          Level: Beginner