Category:

Course Description:

MS Office is a collection of applications that allow you to improve your efficiency and therefore productivity. To help you get started with learning how to use the applications in the MS Office suite, we created the beginner-level courses on four MS Office applications: Excel, Word, PowerPoint, and Outlook. Now, to help you further develop your skills, we have created another series of four courses for intermediate-level users. This is the first in our series of four courses, and it teaches you more advanced functions in MS Excel, such as conditional formatting and formulas. Learning these functions will allow you to further organize and analyze your data. Learning objectives: – Learn how to use the Format Painter – Learn how to use Conditional Formatting – Learn how to display data using the various options such as color scales, highlights and data bars – Learn how to change the data type (text, number, currency, etc.) of a particular set of data – Learn how to clear conditional formatting rules – Learn how to create various formulas (sum, average, etc.) in a cell – Learn how to use the existing formulas in Excel (Autosum, financial formulas, etc.) – Learn how to use Autofill – Learn how to sort data – Learn how to filter data – Learn how to use Freeze Panes – Learn how to link different sheets in your workbook – Learn how to add charts – Learn how to remove the gridlines in your sheet – Learn how to add data from another workbook – Learn how to edit links

Thousands of courses

DisclaimerMany of the curated courses have been manually added into our Learning Management System, then enhanced with structure, descriptive, activities and consolidation,  referencing who the content creators are (where required). If you like the curated content from any creator and like their materials, please feel free to connect with them directly to explore their full libraries of paid programs. 

We will continue to add more curated quality content as well as increasing partnerships with creators to provide you with an all-in-one skills development platform. 

Book a demo now!

Tell us a bit about you. After review, you will receive an invite calendar where you can select your demo time.