We'll cover the following topics in this section:

• 0301 Brief on 2nd Dashboard
• 0302 Importing Data from the Internet
• 0303 Converting Line Item into a Currency Table
• 0304 Calculation of Currency using INDEX & MATCH
• 0305 Creating Slabs using Vlookup True Parameter
• 0306 Creating Qtrs based on Financial or Calendar Selection
• 0307 Preparing the base by removing duplicates for Dashboard
• 0308 AverageIF for calculating Country Wise Salary
• 0309 Substituting ERROR with zero using IFERROR
• 0310 Introduction to Function INDIRECT Part 1 & 2
• 0311 Using Function INDIRECT to Retrieve AverageIF from relevant sheet
• 0312 Using Function CountIF with INDIRECT to calculate No. of Emp
• 0313 Calculating Contribution Country wise No Of Emp
• 0314 Using NameRange to simplify calculation
• 0315 Using NameRange with formula in 2nd Dashboard
• 0316 Introduction to Offset Function
• 0317 Offset Function in Excel
• 0318 Using Offset Function in Dashboard
• 0319 Use of MINIF in Dashboard
• 0320 Use of MAXIF in Dashboard
• 0321 Using Average to get Designation Wise Experience result
• 0322 Using MAXIF with multiple conditions
• 0323 Using MINIF with multiple conditions
• 0324 Dynamic Dropdown List
• 0325 Longitude and latitude with plotting data on dashboard
• 0326 Using REPT Function based on the percentage calculation
• 0327 Activation of Developer Tab and creating Scroll Bar
• 0328 Inserting Trend chart based on data
• 0329 Advance INDEX and MATCH with multiple references
• 0330 Inserting Spark Line
• 0331 Insert World Map into the chart
• 0332 Plotting Data on Map Chart
• 0333 Controlling Map Preview from dropdown
• 0334 Summarising 2nd Dashboard