Learn MS Excel from Scratch

• Learn how to adjust font and color in MS Excel

• Learn how to align data either horizontally or vertically

• Students are introduced to number formatting options

• Automatically highlight rows or columns based on a certain criteria or condition (Conditional Formatting). The emphasis in on automated processing that does not require manual intervention once the conditional formatting is set (everything is highlighted automatically)

• Learn how to use MS Excel function including

- SUM, AVERAGE, MIN (Minimum), MAX (Maximum), and COUNT

• Save time by copying formulas and data quickly and efficiently

• Copy your data and formulas right (Fill Right) or down (Fill Down)

• Number thousands of columns and rows in just a few seconds using the Fill Series Option

• Project investment returns quickly and efficiently using Fill Series Growth function

• Sort data in a spreadsheet using various criteria

• Filter data in a table using various criteria (only filtered data is visible)

• Create a summary of your data using a Pivot table

• Summarize your data using different criteria

• Make adjustments to your Pivot table (summarize data using a different criterion)

• Use the same Pivot table (no need to create a new Pivot table)

• Filter summarized data within a Pivot Table

• Convert client names to a proper format using PROPER Function

• PROPER capitalizes first and last name regardless of the initial entry

• Join two cells of text into one cell

• Find the position of text within another cell

• For example, what is the position of a space in a client's name? This information is required for one of the future lessons (separating a name into first and last name)

• Extract a certain number of characters from a client's name using LEFT function

• Extract a certain number of characters from a client's name using RIGHT function

• Check the number of characters in a text string

• Separate a client's name into First and Last using LEN, SEARCH, LEFT, and RIGHT

• Capitalize a text string/ or make it lowercase

• Delete unnecessary spaces in a text string

• In this lesson students are introduced to MS Excel Charts

• Learn how to create different charts using MS Excel, as well as change chart options including color, style, and others

• Check if a certain condition is true or false using IF function

• Provide different output based on the logical outcome: True or False

• Evaluate whether a date or a text is TRUE or FALSE (i.e. meets your condition)

• Provide and output based on whether the logical argument is TRUE or FALSE

• Evaluate multiple logical statements within IF using AND

• Check if both statements are TRUE at the same time using AND, and provide an appropriate output

• Evaluate multiple logical statements within IF using OR

• Check if at least one logical statement is TRUE using OR, and provide an appropriate output