Excel 2016 Intermediate - Excel Courses

Excel 2016 Intermediate
Outline:	🔗Outline
Reading Material:	📝Material
Exercise File:	🔗XL602.xlsx
Exercise File:	🔗XL602-Solution.xlsx

Day	Modules	Sharing
1	Viewing, Renaming, and Color-coding Worksheets Editing a Group Manipulating Worksheets Creating Linked Formulas Inter Worksheet References Advanced worksheet manipulation techniques Advanced Comment Using Absolute Cell References Creating and Using Absolute Named Ranges Creating a Relative Named Range Using Custom Zoom Using Functions Using Financial Functions Using Date Functions Working with Auditing and Error Checking Tools What is Name? The advantages of using Names Name for single cell Name for literal value Name for expression Name for multi-cells range Name Scoping, ambiguity and conflict resolution Modify Name Delete Name Creating a Table Delete Table Change Table Name Using AutoComplete Sorting a Table Filtering a Table Creating a Slicer Working with the Total Row Creating a Calculated Column Formatting a Table Referring to different parts of table	📝Intro.pptx 🔗Day1.xlsx 📝XL1001 – Advance Data Management and Analysis using Excel (Ver 1.1) (Material).pdf 🔗Day1.txt
2	Applying Conditional Formatting Using Data Validation Entry Guide Custom Error Message Creating and Using Custom Formats Using the Quick Analysis Tool Using Table for Validation Something to know about validation Creating Charts Changing the Chart Location and Size Changing the Chart Type Modifying Chart Elements Formatting Chart Elements Adding and Removing Data Series Applying a Chart Filter Printing Charts Creating and Using a Chart Template Creating a Sparkline Protecting Workbooks and Worksheets Protecting a Workbook Protecting a Worksheet Allowing Users to Edit Ranges Working with Cell Styles Merging Styles Using Templates Creating Custom Templates New Chart Types Insert, Hierarchy Chart, Treemap Forecast Sheet Business Intelligence (BI) features Power Map	🔗Day2.xlsx 🔗Day2.txt

Recommanded Books
	Title	Teach Yourself VISUALLY Excel 2016
	ISBN	978-1-119-07473-1
	Author	Paul McFedries
	Year	2016
	Publisher	Visual
	Title	Exploring Microsoft Excel 2016:Comprehensive
	ISBN	978-0-134-47944-6
	Author	Davidson, Jason; Mulbery, Keith; Poatsy, Mary Anne
	Year	2017
	Publisher	Pearson
	Title	Microsoft Office 365 & Excel 2016
	ISBN	978-1-305-88040-5
	Author	Parsons J.J.
	Year	2017
	Publisher	Course Technology