Platform Banner

Planner - Advanced views and reporting Tutorial

Unlock the full potential of Microsoft Planner in 'advanced views and reporting'! This video guides you through various views, including grid, calendar, and graphical representations, to effectively track your projects. Learn step-by-step strategies to analyze progress, manage tasks, and even export to Excel for deeper insights. Whether you're an intermediate user or looking to sharpen your planning skills, this tutorial is a must-watch!

résultat(s)
00:00:04
we will review the different views offered by Microsoft Planner
00:00:08
and the reporting options associated with them.
00:00:11
The goal is to show you step by step
00:00:15
how to navigate between these views to easily track the progress
00:00:19
of your projects and tasks.
00:00:23
Before starting,
00:00:24
let's clarify that the board view
00:00:26
that is
00:00:28
the compartment representation
00:00:30
has already been detailed in previous tutorials.
00:00:34
We will not revisit it here.
00:00:36
We begin our exploration with the grid view
00:00:39
organized like a table similar to a spreadsheet
00:00:43
in the search field you can type a keyword.
00:00:47
Only the lines containing this term remain displayed,
00:00:51
allowing you to quickly locate relevant tasks.
00:00:55
As soon as you clear the keyword,
00:00:57
the table returns to its full display.
00:01:00
The column headers allow for ascending or
00:01:04
descending,
00:01:05
sorting
00:01:06
to reorder your data with a click.
00:01:10
To refine the display,
00:01:12
you also have filters that allow you to
00:01:14
hide or show tasks according to the compartment,
00:01:17
priority,
00:01:18
or progress status.
00:01:21
Adding a new task is done by clicking on add a task.
00:01:26
You then just need to fill in the different fields as in an Excel sheet.
00:01:31
Finally,
00:01:31
clicking on a line opens the floating preview panel
00:01:35
from which you can instantly modify the task information
00:01:39
without leaving the grid view.
00:01:43
The planning view displays your tasks in the form of a calendar.
00:01:47
For a task to appear in this view,
00:01:50
it must necessarily have a start date and an end date.
00:01:54
By default,
00:01:55
the calendar is presented in a monthly view.
00:01:59
However,
00:01:59
you can switch to a weekly view at any time.
00:02:04
The option right of the month lets you move from month to month.
00:02:09
Or when in weekly view
00:02:11
from one week to another.
00:02:15
To view the details of a task,
00:02:17
simply click on its block in the calendar.
00:02:20
A floating window then opens and offers you all the editing options.
00:02:27
You can also create a task directly from the calendar,
00:02:31
select the desired day,
00:02:33
click on the plus icon that appears,
00:02:36
and enter the task name before confirming.
00:02:41
The column located to the right of the
00:02:43
calendar constantly presents an overview of your tasks
00:02:47
according to your preferences
00:02:49
you can group the task by compartment,
00:02:52
by progress status,
00:02:53
or by due date.
00:02:56
Finally,
00:02:56
to lighten the display,
00:02:58
you have the option to temporarily hide recurring tasks.
00:03:02
This option does not delete the tasks in question.
00:03:05
They will automatically reappear when their next start date is reached.
00:03:11
The graphical view provides a real-time statistical overview.
00:03:15
It shows the number of tasks not started,
00:03:17
in progress,
00:03:18
and completed,
00:03:20
grouped by compartments or by priority,
00:03:23
accompanied by a clear diagram.
00:03:26
Further down,
00:03:27
a report by members shows you how many tasks are assigned to each person
00:03:31
and how many remain without a responsible party.
00:03:35
Thanks to these indicators,
00:03:37
you can identify bottlenecks and urgencies at a glance,
00:03:40
which facilitates decision making and resource reallocation.
00:03:46
When the integrated reports are no longer sufficient,
00:03:49
Microsoft Planner offers export to Excel.
00:03:53
Click on the small arrow to the right of the plan name,
00:03:56
select export to Excel,
00:03:59
and choose the save
00:04:00
location.
00:04:02
The obtained workbook contains a sheet detailing each task,
00:04:06
identifier,
00:04:07
compartment,
00:04:09
progress,
00:04:10
and other key fields.
00:04:12
From this data
00:04:13
you can create pivot tables and custom charts to further the analysis.
00:04:20
A second sheet summarizes the plan's metadata,
00:04:24
including its name
00:04:25
and global identifier.
00:04:27
However,
00:04:28
keep in mind that the Excel file is not synchronized.
00:04:32
To have up to-date data,
00:04:34
you will need to repeat the export.
00:04:37
You now know the main views of Microsoft Planner
00:04:40
grid board,
00:04:42
schedule
00:04:43
and chart
00:04:44
as well as the method to export your information to Excel.
00:04:48
Each of these views meets a specific need
00:04:51
detailed management,
00:04:53
temporal visualization,
00:04:54
or statistical tracking.
00:04:56
In the next tutorial we will cover how to synchronize planner with Outlook
00:05:01
and explore how this integration can help
00:05:03
you manage tasks and schedules more efficiently.

No elements match your search in this video....
Do another search or back to content !

 

Mandarine AI: WHAT YOU SHOULD KNOW

RELATED COURSES This tutorial is part of the following courses

E-learning Débutant
Vu 406 fois
Video Training Microsoft Planner - Discovery & project management

Transform project management with Microsoft Planner: plan, collaborate and visualize your tasks at a glance on any device.
ALL COURSES

An Error Has Occurred

Unable to save your progress. Please reload the page, log in, and try again. If the problem persists, please contact an administrator.

Close

Reminder

Show

/

Join Live Training Session