Course Details

What you will learn:

Microsoft Word 2019

• Master the most common uses of Microsoft Word
• Learn Word tools including using columns, indents, footers, borders and watermarks.
• How to create a mail merge in Microsoft Word
• Learn how to correctly Print envelopes and labels in Word
• Learn to protect your Word document from changes
• Insert professional pictures and graphics in your Word document
• Make your Word documents look amazing by inserting and editing tables

Microsoft PowerPoint 2019

• Discover new features in PowerPoint 2019 including Icons and 3D Models
• Learn how to insert shapes, graphics and pictures to add some "zing" to your PowerPoint
• Add charts, graphs and tables to your PowerPoint presentation information in a non-text format
• Wow your audience by adding animations, audio and video to PowerPoint
• Discover practical tips to present your PowerPoint presentation to your audience

• Learn time saving techniques including how to copy slides, and exporting your presentation

Microsoft Excel 2019

• Learn the essential and advanced Microsoft Office Skills in Excel, Word, PowerPoint, Outlook, Teams and Access.

• Learn practical methods to backup, recover your Excel spreadsheets, and never lose data.

• Discover the essentials of using formulas and functions in Excel.
• Discover how to create stunning charts and graphs in Excel.

• Learn practical methods to sort and filter your data in Excel.

What is covered in each course?

Microsoft Word 2019

• How to get started with Word 2019
• Word 2019 basics including navigation, editing and saving
• Character formatting in Word including Format Painter and AutoCorrect
• How to properly work with bullets and numbering in Microsoft Word
• All about formatting paragraphs and managing lists
• Working with Tables in Word including formatting, converting data and formulas
• Page appearance including page-breaks, watermarks and styles
• All about Sectioning a document
• Inserting graphics, pictures, shapes, icons and 3d models (new for 2019)
• How to work with envelopes and labels
• All about mail-merge and operating Word at scale
• How to create an Index or Contents page
• Reviewing and Printing in Word and Page Setup
• Protecting a Word document and basic macros in Word

Microsoft PowerPoint 2019

• How to navigate around PowerPoint
• Presentation dos and don'ts
• Text and bullet edition options
• How to use graphics, images, objects and shapes
• Using SmartArt
• Working with Charts and Graphs
• How to utilize Master Slides and just how much time this could save you
• How to add audio and video to a presentation
• All about transitions between slides
• Animation, the animation pane and motion paths
• Setting your slideshow options
• Presentation preparation and delivery
• The backstage area of PowerPoint including printing a presentation

Microsoft Excel 2019

• What's new in Excel 2019
• Creating workbooks
• Entering text, numbers and working with dates
• Navigating workbooks
• Page setup and print options
• Working with rows, columns, and cells
• Cut, Copy and Paste
• Introduction to Functions and Formulas
• Formatting in Excel, including formatting cells and numbers
• Creating charts and graphs
• Sorting and Filtering
• Introduction to PivotTables
• Logical and lookup formulas - the basics

Advanced Microsoft Excel 2019

• What's new/different in Excel 2019
• Advanced charting and graphing in Excel
• How to use detailed formatting tools
• Lookup and advanced lookup functions
• Financial functions including calculating interest and depreciation
• Statistical functions
• Connecting to other workbooks and datasets outside of Excel e.g. MS Access and the web.
• How to create awesome visualizations using spark lines and data bars
• Mastery of PivotTables and Pivot Charts
• Scenario Manager, Goal Seek and Solver
• Advanced charts such as Surface, Radar, Bubble and Stock Charts