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.
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.
Covers the components of the Standard Tool Bar. This is usually the top most toolbar in the Excel interface.
Learn about the components of the Formatting Toolbar. This is found at the top of the Excel window.
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.
The layout tab is a part of the ribbon feature of excel. Users are able to set sheet layout options from this tab.
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.
The charts tab allows for the representation of data in chart form. Create a variety of chart types using this tab.
Part 2 of Charts Tab. The charts tab allows for the representation of data in chart form. Create a variety of chart types using this tab.
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.
An explanation of some of the key standard formulas available in excel. Functions covered: Sum, Average, Max, Min and Count. These are the most common used functions of excel.
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.
The index function when combined with the Vlookup and Hlookup functions allows for the creation of dynamic reports. Index offers a quick solution for querying a table with vertical and horizontal reference points.
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.
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.
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.
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.
This example showcases the use of Microsoft Excel for Personal Financial Management. No quiz.
In this chapter we start learning about the Home Tab.
This chapter looks at the features available within the paragraph options of the home tab. These features include text alignment, bullet points and indentation features.
In this chapter we look at the extensive features of clip art. We learn how to insert clip art as well ash how to add clipart to our gallery.
This chapter focuses on the Insert portion of the the Home Tab. Users can insert text boxes, word art, headers and footers.
Slide Master is the main slide that determines the layout of your slide show.
We learn how to make a simple powerpoint presentation.