Microsoft Powerpoint and Excel Training with Certificate

Or log in to access your purchased courses

This is a combined certificate training of Microsoft Excel and Microsoft Powerpoint. This training encompasses all the training from "Microsoft Excel Training With Certificate" and "Microsoft Powerpoint Training with Certificate". This is an online video training class. The best way to benefit from this class is to view all the lectures in full screen and sit through all the lectures at least once. All lectures are video lectures.

Lessons

Microsoft Excel Training With Certificate – PPT and XLS

Length: 8 minutesAuthor: Startup Saturdays

Microsoft excel is a software that allows its users the ability to find a simple solution to daily data related problems. Excel can be utilized to access most problems in a mathematical spreadsheet format. For example: Let’s say you want to manage your finances. Excel offers a solution by which a user can make a list of expenses and maintain an ongoing log of incurred expenses.

Excel Layout: Smart Art, Formulas, Data and Review – PPT and XLS

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: SumIf and AverageIf – PPT and XLS

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 – PPT and XLS

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 – PPT and XLS

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.