Microsoft
Office 365
Excel
Learn MS office 365 Excel. This course will open you the endless opportunities to explore the powerful spreadsheet application
Data
37
Creating a List
Understanding the need of a list with drop down menu
Data Validation Menu
Creating a list from a given values in a sheet
Error handling
Data
38
Sorting a data
How to sort data with alphabetical order
Adding multiple sorting criteria
How to exclude a header when sorting
Data
39
Custom Sorting
Need of custom sort
Sort Months days etc with custom sorting
Custom List preparation
Data
40
Filter
Advantage of using Filter
Filter with any values in a sheet
How do we know whether filter is applied?
How to clear a filter?
Data
41
Remove Duplicates
Need of using this tool
How to remove duplicates in a sheet
Selecting the columns which needs to be checked or not checked while finding duplicates
Data
42
Import and Export
How to export data to different format
Exporting as csv, text etc
How to import data to Excel
Data
43
Subtotal
How to find subtotal of different items from a large data
Summary of Total, subtotal
Data
44
Grouping
Grouping Large data to show the desired columns or rows in display
Ungrouping larger data
Data
45
Consolidate
Consolidate the output by a single click
This is useful instead of using 3D formulas
Consolidate sum, count, Average etc
Linking to source data for the detailed view
Home-Table
46
Format as Table
Converting a list to a table
Advantages of using a table
Automatic Calculations
Filtering and courtingNaming a table
Name Manager
Define Name
Formulas
47
Name Manager
Defining a name for cells
Calling function with Table name
Advantage and Disadvantage of naming a cell or multiple cells
Editing and deleting a name
Formulas
48
If Function-1
Usage of if function
Syntax: =IF(G2>=J1,"Passed","Failed")
Making a value as absolute reference by F4
Conditional formatting to apply color styles