-
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