In this instructor led, online training course, students will learn the fundamentals of Scrum, Scrum framework, how to master Scrum, planning a project with Scrum, and keeping Scrum healthy.
In this instructor led, online training course, students will learn the fundamentals of Scrum, Scrum framework, how to master Scrum, planning a project with Scrum, and keeping Scrum healthy.
Working with Kanban boards is an overview workshop on the values of using a Kanban approach in any project management framework, including the values and the steps to create a Kanban board. Students will learn about how to set up their own board and see some different situations that may arise during their workflow. The course will end with a demo and an interactive Kanban board using an online platform. Students will be encouraged to log in and use a live Kanban board and work together to build out the project assigned. The ability to create and use a Kanban board with a good understanding of how they work and why they are so effective will influence your future projects, whether they are Agile projects, Waterfall projects or a tailored approach.
01: Formatting a Pivot Table (7:42)
02: Changing Pivot Table Options (8:38)
03: Presenting Data With Pivot Charts (4:29)
04: Using Slicers (7:45)
05: Using Timeline Slicers (1:51)
01: Creating a Pivot Table (12:14)
02: Summarizing data in a Pivot Table (8:38)
03: Grouping data in a Pivot Table (6:33)
01: Using Advanced Chart Features (4:44)
02: Applying Trendlines (4:36)
03: Creating and Applying Chart Templates (3:31)
04: Inserting Graphics (9:15)
05: Modifying Graphics (12:38)
01: Creating tables (6:45)
02: Modifying table styles (7:10)
03: Using the Quick Analysis shortcut (1:56)
04: Summarizing data in tables (4:35)
01: Querying data (7:16)
02: Using the SUBTOTAL function (4:43)
03: Using the SUBTOTAL feature (7:09)
01: Sorting data Part 1 (5:31)
02: Sorting data Part 2 (6:00)
03: Filtering data Part 1 (5:25)
04: Filtering data Part 2 (8:06)
05: Filtering data Part 3 (8:28)
01: Working with Text Functions Part 1 (4:22)
02: Working with Text Functions Part 2 (4:55)
03: Working with Text Functions Part 3 (3:49)
04: Working with Text Functions Part 4 (8:56)
05: Working with Math functions (7:55)
06: Calculations options (2:47)
01: Working with logical functions (9:03)
02: Working with conditional functions (8:16)
03: Multiple criteria functions (5:23)
04: Using nested functions (5:57)
05: Using IFS and SWITCH functions (6:21)
01: Working with date functions – Part 1 (9:15)
02: Working with date functions – Part 2 (4:38)
03: Working with date functions – Part 3 (3:41)
04: Working with time functions – (5:50)
01: Using named ranges – Part 1 (5:16)
02: Using named ranges – Part 2 (5:32)
03: Using named ranges – Part 3 (5:10)