Microsoft Office Classes Ottawa

This 1-day Excel course is crafted to introduce beginners to the fundamentals of Excel in order to enable them to feel comfortable working with spreadsheets. This course covers the basics of spreadsheets, the layout of Excel, entering data, using common formulas and functions, and a variety of other helpful tips and tricks.

This 1-day Excel course is designed for individuals familiar with Excel but who are looking to bolster their knowledge of building professional looking charts. This course covers a lot of broad chart-related content, including creating and working with charts, incorporating various styles and themes, using print options, and best practices around using excel data in other office applications, like Word or PowerPoint.

This 1-day Excel course is designed for individuals familiar with Excel but who are looking to bolster their knowledge of the various database and PivotTables features. This course covers a variety of PivotTable essentials, such as using lists, table features, working with data, making and enhancing PivotTables, and much more.

This 2-day Excel course is designed for individuals with a strong background using Excel but want to refresh their skills and learn some of the newest features to enhance your Excel mastery. This course moves at a fast pace and covers many of the most widely used and popular Excel techniques that will make students faster, more dynamic, and less error prone when working with spreadsheets. Some of the topics include short-cuts, formatting charts and graphs, database features, PivotTables, Formulas, Macros, and more.

This 1-day Excel course was designed to teach beginners the basics of working with spreadsheets. The course covers a range of beginner Excel concepts and tools, including an introduction to the Excel environment, formatting a spreadsheet and the data it contains, basic functions and formulas, and how to save and print Excel documents.

This 2-day Excel course was designed to teach beginners more than just basics of working with spreadsheets. The course covers a range of beginner and intermediate Excel concepts and tools, including how to customize Excel, functions and formulas, sorting and filtering, how to protect files and spreadsheets, creating charts, working with external data sources, validating data, conditional formatting, and more.

This 2-day advanced Excel course was designed to teach regular spreadsheet users some of the more advanced functions available within Excel. The course covers a range of advanced Excel concepts, including what if analysis, how to consolidate data, advanced functions, a variety of advanced Excel tricks, an introduction to macros, and best practices for working with pivot tables.

This 2-day advanced Excel course was designed to teach regular spreadsheet users some of the more advanced formulas and functions available in Excel. The course covers a range of advanced Excel formulas and functions, including a review of formula basics, using logical, reference, and statistical functions, as well as various math, finance, and error checking functions.

This 1-day Excel course was designed to teach spreadsheet users how to work with one of the most helpful and powerful tools in Excel, the PivotTable. The course covers a range of PivotTable concepts, including how to create a pivot table, arranging fields, using filters, handling blank cells, sorting, creating custom formats, adding formulas to a pivot table, replication, counting, using pivot charts, and more.

This 1-day PowerPoint course was designed to teach individuals new to PowerPoint how best to use Microsoft’s powerful presentation software. The course covers a range of PowerPoint tools and concepts, including an introduction to PowerPoint, how to create a presentation from scratch, working with slides, adding images and content to slides, incorporating diagrams and charts onto slides, adding video and audio to presentations, preparing and delivering the final presentation product, and reusing and sharing presentation decks.