Course Details

  • Teacher
    Emmanuel Osabutey
  • Category
    Special Courses
  • Course Price
    399

Ultimate Microsoft Office 2019; Excel, Word & PowerPoint

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

 

 

Course Information

  • Class Start: 2021-11-01
  • Course Duration: 2 Months
  • Student Capacity: Max 45 Students
  • Class Schedule: Fridays 5:00pm - 8:00pm, Saturday 10:00am - 12:00pm

Course Teacher

Emmanuel Osabutey
nuellexis@gmail.com
Address
Madina - Accra, House Number MD 415