Microsoft Excel Training With Certificate

<iframe src="//player.vimeo.com/video/79914470" width="1000" height="560" frameborder="0" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>
Or log in to access your purchased courses

Microsoft Excel is an essential tool for all success. Learn the art of using Excel to enhance personal, professional and business performance. The skills learned in this class are essential for utilizing Microsoft Excel for all purposes. This is a video based training program with lessons delivered online. Students learn at their own pace by re-visiting classes as needed. Students have access to all course material for up to 1 year from date of purchase. This is a beginner and intermediate level class and requires no prior understanding of Microsoft Excel. Enhance your personal and professional performance with Microsoft Excel.

Lessons

Excel Layout: Home Tab

Length: 25 minutesAuthor: Startup SaturdaysComplexity: Standard

The home tab is a part of the ribbon feature of excel. This video covers the features of the Home Tab. The most commonly used features of excel can be found in the Home Tab.

Excel Layout: Tables Tab

Length: 12 minutesAuthor: Startup SaturdaysComplexity: Standard

This tab allows the creation and formatting of a table for tables that do not have a custom format. It also implements the named range feature to tables.

Excel Layout: Smart Art, Formulas, Data and Review

Length: 25 minutesAuthor: Startup SaturdaysComplexity: Standard

The features of these tabs are combined in a single lesson. Features from this tab are also referred to throughout the course. The Smart Art Tab offers the ability to make flow diagrams, the formula’s tab covers all pre functioned formulas in excel and the review tab allows for implementing features such as notes and spell check.

Functions: Vertical and Horizontal Lookup

Length: 25 minutesAuthor: Startup SaturdaysComplexity: Standard

Vertical Lookup (Vlookup) and Horizontal Lookup (Hlookup) are features of excel that allow users to make a query on a data table. These are very useful functions that help in report making through data querying.

Functions: SumIf and AverageIf

Length: 40 minutesAuthor: Startup SaturdaysComplexity: Standard

The sum if and average if functions allow the application of the sum function and the average function based on a specific criterion. Values within a specific range can be summed based on a specific criterion using the SumIf function. Similarly, averages can be calculated within a specific range with the AverageIf function.

Functions: The IF Statement

Length: 25 minutesAuthor: Startup SaturdaysComplexity: Standard

The IF statement is used to determine validity of a criterion. A cell is declared and the calculation is made to determine if this cell meets the criterion in IF statement. Pre determined outcomes can be implemented based on the statements validity.

Functions: Nested IF Statement

Length: 20 minutesAuthor: Startup SaturdaysComplexity: Standard

The nested IF statement allows for multiple calculations to be made within a single IF statement. In a nested IF statement a secondary IF statement is tested for while within the initially setup IF statement. This video shows the nesting of an IF statement.

Functions: Vlookup nested inside an if statement

Length: 15 minutesAuthor: Startup SaturdaysComplexity: Standard

The video in this chapter teaches how to nest a function within a function. The functions that are utilized can be different types of functions. In this particular example the Vertical lookup function is nested inside an IF statement.