Excel Basics to Advanced: Design Robust Spreadsheet Applications Powered with Formatting

1.MS Excel Fundamentals
	Introducing MS Excel
		Importance of MS Excel
		MS Excel Terminology
	Installation
		Installation of Office 365
	Understanding the ribbon
		Ribbon Tabs
	Understanding the Workbook
	Creating your first Workbook
		Auto fill
		Flash fill
		Copy data from one sheet to another
		Saving the Excel Workbook
		Freeze Pane
		Sorting
		Filtering the data
		Task bar
	Printing in Excel
		Printing Options
2.Formatting in Excel
	Cell Formatting in MS Excel
		Format Cells
	Conditional Formatting
		Custom Conditional Formatting
3.Introduction to Formulas
	Overview of Formulas
	Cell Reference
		Relative Cell reference
		Absolute Cell reference
		Mixed Cell reference
		3-D reference
		R1C1 reference
	Copy values of a Formula
4.Logical Functions
	Overview of Logical Functions
	The IF function
	The AND function
	The OR function
	The NOT function
	The IFERROR function
5.Text Functions
	Overview of Text Functions
	The LEFT, RIGHT, and MID function
		The LEFT function
		The RIGHT function
		The MID function
	The LEN function
	The CONCAT function
6.DateTime Functions
	Overview of Dates
	Add or subtract days from dates
	The EDATE function
	The DATE, YEAR, MONTH, and DAY functions
		The DATE function
		The YEAR function
		The MONTH function
		The DAY function
	Calculating Quarters
	TODAY, NOW, and TIME functions
		TODAY and NOW functions
		The TIME function
7.Mathematical Functions
	The COUNT functions
		COUNT function
		COUNTA function
		COUNTIF function
	The SUM functions
		SUM function
		SUMIF function
		SUMIFS function
8.Lookup and Reference
	The VLOOKUP function
		How it works
		VLOOKUP features
		Look up value in the same sheet
		Look up value in different sheets
		Look up value in different workbooks
	The LOOKUP function
	The INDEX function
	The MATCH function
		Combining INDEX and MATCH function
9.Pivot tables and Charts
	Understanding Pivot Tables
		Pivot Table Interface
		Creating Pivot table
	Charts in Excel
		Standard Charts
		Pivot Charts
	Updating PivotTable Data
		Updating the PivotTable with New Data Rows
		Automatically Updating the PivotTable on open
10.Excel Table
	Overview of Excel Tables
	Creating an Excel table
	SubTotal function
		SUBTOTAL vs. SUM
11.Introduction to Excel Macros
	Overview of Macros
		Enabling the Developer tab
		Recording a Macro
	Visual basic code for Macros