Advanced Excel

Advanced Excel Functions refers to the features and functions of Microsoft Excel, which helps the user to perform complex calculations, perform data analysis, and much more. In this article, you will learn some of the most commonly used advanced functions in Excel.

This advanced Excel training course starts with a blank spreadsheet and quickly dives into using combinations of functions and formulas to perform dynamic analysis. The main formulas & functions covered in this training course include: INDEX and MATCH.

Syllabus:

• 1. EXCEL 2007 & 2010, 2013, 2016 QUICK OVERVIEW
• Lesson 1. Difference between Excel 2003, 2007 and 2010,2013,2016.
• Lesson 2. Use of Excel, its boundaries & features.
• 2. BASIC FORMULA
• Lesson 1. Formulae that Add / Subtract / Multiply / Divide.
• Lesson 2. BODMAS / Formula Error Checking.
• Lesson 3. The Sum Function.
• 3. ABSOLUTE REFERENCING
• Lesson 1. Problems with Absolute / Relative Cell Referencing.
• Lesson 2. Creating Absolute / Mixed References.
• 4. LOOKUP FUNCTION
• Lesson 1. The VLOOKUP/ HLOOKUP Functions.
• 5. PIVOTTABLES
• Lesson 1. Creating, Formatting Simple PivotTables.
• Lesson 2. Page Field in a PivotTable.
• Lesson 3. Formatting a PivotTable.
• Lesson 4. Creating / Modifying a PivotChart.
• 6. LOGICAL FUNCTIONS
• Lesson 1. IFs and Nested IF functions.
• Lesson 2. Using AND / OR / NOT Functions.
• And more.