Microsoft
Office 365
Excel
Learn MS office 365 Excel. This course will open you the endless opportunities to explore the powerful spreadsheet application
Home
12
Styles
Add look and feel to your excel sheets by applying cell styles
Modify the built in cell styles
Create your won styles and save it for later use in your documents
Format painter to copy the styles
Basic Operations
13
Sum Function
Referring a cell
Entering a Formula
Different method of addition
Calling a function in Excel
Sum function
Saving a file
Basic Operations
14
Relative Reference
Understand Relative reference
Copying a cell that contains formula
F2 = To edit or view a cell content
Basic Operations
15
Absolute Reference
Find Percentage
Absolute Reference
F4 = To make absolute reference
Basic Operations
16
Mixed Reference
Find Percentage using mixed reference
Mixed reference
Use of Mixed reference
Basic Operations
17
Order of Operation
Addition, Subtraction
Menu-Formulas
Evaluate Formula
How to read the formulas in a cell by Evaluate Formula
F7 = Spellcheck
Order of Operation
Brackets
Exponents
Multiplication
Division
Addition
Subtraction
Basic Operations
18
Overview of Functions
Locations to choose the functions
How to get help on every function
Auto Sum
Select Multiple cells to find sum
Basic Operations
19
Hide Unhide, Insert Delete
Hide a column or row
Unhide a column or row
Insert a column or row
Delete a column or row
Insert or delete multiple columns and rows
Ctrl+Shift+ + = Add a column or row
Ctrl+- = Delete a columns or row
Adjusting the width and height of row and column
Basic Operations
20
AutoFill
How to AutoFill sequencial contents in Exce (Sunday, Monday etc.)
Use of AutoFill handle to spread the data in Excel
Creating Custom List to AutoFill
Using Fill Menu in Home Bar
Basic Operations
21
Sheets
Adding more sheets to a workbook
Rename a sheet
Adding color to a sheet
Rearranging the position of a sheet
Copy sheet data
Move sheet data to a different workbook
Referring another sheet in a formula
Functions
22
MIN & MAX
Find the Minimum value in a range of cell
Find the Maximum value in a range of cell
MIN
=MIN(A1:A5)
=MIN(B4:B8, D4:D8)
MAX
=MAX(A1:A5)
=MAX(B4:B8, D4:D8)
Functions
23
Average
Use of Average Function
Average, which is the arithmetic mean, and is calculated by adding a group of numbers and then dividing by the count of those numbers.
Returns the average (arithmetic mean) of the arguments
=AVERAGE(A1:A20)
Use of Format painter
Formatting a Cell to adjust the Decimal Place