Essential Skills offers a wide range of Microsoft Office short courses that target your learning needs. Applications covered include Outlook, Word, Excel and PowerPoint. See the listing below.
Office Essentials – Pick up the key skills that will make your transition to Word, Excel 2007/2013 and Outlook an easier one.
Course Length: 2 hours
MS Outlook – There’s much more to Outlook than sending and receiving emails.
Course Length: 2 hours
Excel Basic Skills – Have to update a worksheet, and want to know more about how it actually works? Learn how to set up a worksheet. Then master navigation, selection and printing shortcuts that will save time and paper. See how easy it is to use basic formulae and functions.
Course Length: 2 hours
Excel Charts – There’s no question a picture is worth a thousand words when it comes to numbers in a worksheet! Creating an Excel chart is as easy as selecting your data and pushing a key on the keyboard. This course takes you the extra step of learning how to create the different types of chart, format them, and then either print them or add them to your Word documents and PowerPoint presentations.
Course Length: 1.5 hours
Excel Formulae & Functions – Once you’ve got the basics under your belt, it’s time to master the use of functions in your worksheet. This course introduces you to a variety of different built-in functions, including Sumif, Countif, Today, If, and Vlookup along with the correct method of setting up your formulae in a worksheet.
Course Length: 2 hours
Excel Pivot Tables – Master the art of analyzing the data in your Excel tables using this powerful built-in tool. Want to know the percentage of each type of widgets sold in your region, broken down by store? If you have the raw data a PivotTable will give you the answer quickly and easily.
Course Length: 1.5 hours
Excel Data Management – Discover the powerful tools Excel provides on its Data ribbon for working with your data, and you don’t need to know anything about formulae in order to use them! You will learn how to sort and filter information, remove duplicates and split information contained in a single cell into multiple cells using Text-to-Columns.
Course Length: 2 hours
Excel – Custom Formatting and Tables – Format numbers and dates in your worksheets to look exactly the way you want. Learn how to display leading zeros, spacing, colour and icons to assist in interpreting your data. Use Excel Tables to quickly name a range of data and apply features such as filters and totals to it. See how using a table can make updating your PivotTables easier.
Course Length: 1.5 hours
Word – Essentials – It’s the little things that make document creation quick and easy, such as placing key commands on the Quick Access toolbar, setting tabs on the ruler and changing indents. And it’s also the keyboard shortcuts for selecting, moving and copying text. Pick up these and other handy tips on using Word more effectively.
Course Length: 1.5 hours
Word – Styles & Formatting – Ever wanted to select text scattered through a document and reformat it with a single mouse click? Do you wish bullet points and numbering would behave the way you want rather than having a life of their own? Would you like to create tables of contents and have them update easily when you make changes to headings? Learn all that and more in this 2 hour session.
Course Length: 2 hours
Word – Document Layout – Creating Headers and footers, page numbering, switching between one and two or more columns on the same page, or switching between portrait and landscape in a document – take the frustration out of these tasks.
Course Length: 1.5 hours
Word – Using Tables in Word Documents – Everything you need to know about working with tables and Tables Tools ribbons.
Course Length: 1.5 hours
Word – Working with Graphics and other Objects in Word 2007/2010 – Master the use of the Insert ribbon. Make objects look and behave the way you want them to by using the object’s Format ribbon.
Course Length: 1.5 hours
Word – Reviewing Documents with Track Changes – It’s easy to track changes in Word documents using the Review menu. Learn the best techniques for reviewing and marking suggested changes in documents you’ve been asked to proof. If you’ve received a document with marked changes and comments, discover how easy it is to move through them and make changes, accept the suggested changes or revert to the previous text.
Course Length: 1.5 hours
Word – Using References in Your Documents – Learn how to create quick and easy Tables of Contents. Master the use of footnotes and endnotes and learn how to insert cross references and captions into your documents.
Course Length: 2 hours
Word – QuickParts, Fields and AutoCorrect – Learn how easy it is to use the QuickParts options to add document properties, blocks of text and field codes to your Word documents and to emails. Automatically correct commonly misspelled words or words with special characters in them. Save blocks of text or tables for use in other documents.
Course Length: 1.5 hours
MS PowerPoint – Learn create an interesting presentation while avoiding the pitfalls of Death by PowerPoint. Master the formatting of text, adding of graphics and the use of animations and transitions.
Course Length: 2 hours