Data Analytics With Excel – TOIT Training

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

2 Students

1077 Courses

course thumbnail

Free

Student:

0 Students

Lesson:

0 Lessons

Duration: 88 Minutes

Quiz:

0 Quizzes

Level: Beginner