Short Microsoft Office Virtual Courses90 min Virtual Training Sessions for $190 inc GST per Student
Online and In-Person Classes Courses run on the Last Thursday of every month. Excel Vlookup Functions Navigating Excel Like A Pro Unravel The Mystery Of Formatting In MS Word PowerPoint Advanced Understanding OneNote Getting Started Office 365 More Short courses are available, discuss your needs with our facilitators and we will develop a short Microsoft Office Application course that suites your business needs.
Learn remotely from a location that is suited to you. Our Master Vlookup short online virtual session is a great tool if you compare two sets of data sources. For example if you need to find and Invoice number or Product Code in a different master list and then return the description. Vlookup in Excel is your tool. If you need to make a shorter data set to then use for an Excel Pivot Table then mastering Vlookup is for you. XLookup is the updated version of VLOOKUP and it has some exciting features that overcome barriers of the VLOOKUP function. Like the lookup value not needing to be in the first column. Unravel The Mystery Of Formatting In MS Word will open your eyes to the those small annoying things Word does that you never realized how to fix on your own. Styles plays a big part of that. Got to keep the mystery going. |
Navigating Excel Like A Pro will have you navigating and selecting cells so fast you will have your work completed in half the time. PRE FILLING DATA with ease and amazing SHORTCUT KEYS you will use every day. Copying collapsed subtotal data – there is a trick to it. Understanding how to work with Excel Sheets. To Freeze or not to FREEZE PANE.
PowerPoint Advanced techniques include mastering transitions and ANIMATIONS, creating clever hyperlink techniques and ZOOM SLIDE EFFECTS made easy. Setting defaults such as colour palette and slide layouts using the SLIDE MASTER you have the power to create your own layouts. Getting Started Office 365 have a good understanding of Office 365 and how to manager your ONEDRIVE and its suite of Applications, like PLANNER and TO DO. Understanding OneNote it’s used like a scrapbook, mood board a place for miscellaneous information a place to GET YOUR THOUGHTS TOGETHER. Gather web page links and images. The search capability is great in OneNote, Search by Ideas, discussions author various Notebooks. |