What Will You Learn?

• How to use Inbuilt functions
• How to use Absolute referencing formulae
• How to use Nested-if functions
• VLOOK AND HLOOKUP
• Logical IF functions
• Concatenation formulae
• Create a workbook
• Add a worksheet to an existing workbook
• Copy and move a worksheet
• Search for data within a workbook
• Navigate to a named cell, range, or workbook element
• Insert and remove hyperlinks
• Change worksheet tab color
• Rename a worksheet
• Change worksheet order
• Insert and delete columns or rows
• Change workbook themes
• Adjust row height and column width
• Insert headers and footers
• Hide or unhide worksheets
• Hide or unhide columns and rows
• Customize the Quick Access toolbar
• Modify document properties
• Display formulas
• Create custom number formats
• Configure data validation
• Create custom conditional formatting rules
• Create conditional formatting rules that use formulas
• Manage conditional formatting rules
• Apply styles to tables
• Configure table style options
• Insert total rows
• Filter records
• Sort data by multiple columns
• Change sort order
• Remove duplicate records
• Insert references
• Perform calculations by using the SUM function
• Perform calculations by using MIN and MAX functions
• Perform calculations by using the COUNT function
• Perform calculations by using the AVERAGE function
• Perform logical operations by using the IF function
• Perform logical operations by using the SUMIF function
• Perform logical operations by using the AVERAGEIF function
• Perform statistical operations by using the COUNTIF funnction
• Concatenation function
• How to rename multiple file names in a folder using excel and DOS