Productivity Essentials with Office 365 - dbrownconsulting
Productivity Essentials with Office 365

Productivity Essentials with Office 365

Productivity Essentials with Office 365

CPD 24 units | 24 PL credits
Online Prework + 3 Days Classroom or 6 Virtual Sessions or Online Self-Paced




dbrownconsulting focuses on helping organizations and individuals achieve more with their data. We partner with CFA Society Nigeria to deliver world-class learning and professional development solutions to its members and candidates in Nigeria. We are also an accredited training provider of the Financial Modeling Institute based in Canada, Microsoft partners, a member of CPD UK.


Earn 24 CPD Credits for this course

Online Prework + 3 Days Classroom or 6 Virtual Sessions or Online Self-PacedEnroll NOW

Microsoft Outlook

Email Etiquette

  • Reply/Reply all syndrome, how to use To/Cc/BCc properly
  • Scheduling email (Delay Delivery)
  • Grammar & Spelling
  • The Best of Use of “Subject”

Managing Appointments & To Dos

  • Email Recall
  • Managing and delegating task
  • Adding holiday calendar to Outlook Calendar

Automating tasks with Rules and Folder

  • Creating Folders
  • Creating Simple Automation Rules
  • Creating Advanced Automation Rules
  • Dates and Charts in Word

Top 5 Outlook Tip

  • Getting organized with Groups
  • Listening to mails
  • Running Polls from Outlook
  • Most Productive Outlook Shortcuts
  • Highlight of the most productive new feature in Outlook

Microsoft PowerPoint

Maximize Efficiency with the Slide Master

  • Creating presentation from scratch using Outline View
  • Controlling the look and feel of your presentation with slides master,
  • Adding headers and footers,
  • Creating and Changing slides layout, filters
  • Creating Sections, Changing Themes

Harnessing Artificial Intelligence & other tools to build your Presentation

  • Maximize the use of Design Ideas 
  • Telling Stories with Smart art and shapes (cropping, merging, formatting) 
  • Working with text animations photos videos audio and multimedia

Storytelling tips using PowerPoint

  • Introducing the Pecha Kucha Presentation Style
  • How to deliver an engaging presentation in less than 7 minutes
  • Using Slide Master to build custom Layouts

Top 5 tips in PowerPoint

  • Professional picture editing techniques
  • Build your slides by uploading a Microsoft Word document
  • How to rehearse a presentation with speaker notes
  • Highlight of the most productive new feature in PowerPoint

Microsoft Excel

Secrets of How Excel Works

  • A short history lesson of Excel
  • Introducing Excel Interface and Navigation
  • Customizing Excel to work for you using Excel Option & Quick access Tool bar 
  • Introducing the New Calculation Engine and Dynamic Arrays 
  • Understanding how Functions work in Excel

Report Automation in Excel

  • Report Automation in Excel 
  • Why you only need 3 Sheets to automate all your reports 
  • The 7 Golden Rules of Data 
  • The 4 ways to build reports in Excel
  • How to control the way users use your reports 
  • Tips for automating data updates
  • Building a Quick Dashboard with Pivot Tables & Charts

Top 5 Excel Productivity Tips

  • Creating Folders
  • Creating Simple Automation Rules
  • Creating Advanced Automation Rules
  • Dates and Charts in Word

Top 5 Outlook Tip

  • Getting organized with Groups
  • Listening to mails
  • Running Polls from Outlook
  • Most Productive Outlook Shortcuts
  • Highlight of the most productive new feature in Outlook

Collaboration with Microsoft Teams

Setting Up Teams

  • Setup Teams for the first time
  • Overview of the Teams interface
  • Set your status messages
  • Change themes

Working with Teams

  • Creating teams and adding Team members
  • Joining an existing Team
  • Best practice for managing Channels
  • Adding connectors to Teams

Messaging and Files

  • Chats and sharing of files
  • Emails via Teams
  • Messages on Teams
  • Bookmark messages

Collaborations

  • Create a new document from scratch with Microsoft Teams
  • Phone calls and Video calls 
  • Sharing with Team Members
  • Editing of files with Team Members

Top 5 Teams Productivity Tips

  • Top 5 Teams Productivity Tips
  • Tag People in Teams 
  • Creating Memes 
  • Most Productive Teams Shortcuts 
  • Highlight of the most productive new feature in Teams