- The proper set-up of your project plan from start dates to calendars
- How to create an effective schedule that you are able to manage effectively
- Working with durations and resources
- Setup a project
- Setup the schedule and calendar
- Create and work with tasks
- Use an Agile approach to effectively manage a project’s schedule, scope, budget, quality, and team
- Tangible, effective methods of team-based planning
- Creating transparent communication among and with customers
- About the differences in Agile
- Roles and Responsibilities
- User stories
- Scrum framework
- Scrum roles
- Scrum process
- Benefits of the Kanban approach
- Definition of done
- How to set up a Kanban Board
- Applying and modifying PivotTable styles
- Formatting numbers
- Refreshing a PivotTable
- Creating PivotTables using multiple methods
- Configuring the layout of a PivotTable
- Creating hierarchies and subtotals
- Creating Dual-Axis and Combo charts
- Applying and modifying Trendlines on a chart
- Creating and applying Chart Templates
- Creating a table from existing data
- Applying table tools to modify a table
- Formatting a table with Table Styles
- Calculating aggregates based on changing criteria using database functions such as DSUM and DAVERAGE
- Applying and modifying the SUBTOTAL function within a filtered list
- Adding Subtotals to data using the Subtotals feature
- Sorting data using Quick Sort options
- Sorting by multiple columns, custom lists, or colors using the Sort Options dialog box
- Applying Autofilter to view specific data