If you want to be a successful manager then you must master the art of Excel advance tool. By mastering this powerful tool, you can make any data analysis by visual display and also making it easy for users to understand. This will help your organizations to reach its goals in becoming more productive, efficient and effective.
Day 1
• Formulas and Functions
• Understanding Formula Basics
• Function Arguments
• Insertion of Functions into Formulas
• Chapter 10: Using Formulas to Perform
• Mathematical Operations
• Calculation of Percentages
• Calculation of Percent of Goal
• Calculation of Percent Variance
• Calculation of Percent Distribution • Calculation of Running Total
• Handling Division by Zero Errors
• Rounding of Numbers
• Using the Conversion Functions
• Working with Text
• Setting a Text to Sentence Case
• Finding a Character’s Second Instance
• Counting a Cell’s Specific Characters
• Cleaning of Unknown Characters from any Text Field
• Using Formulas with Times and Dates
• Conversion of Decimal Seconds, Minutes, or Hours to Time Using Formulas
• Addition of Seconds, Minutes, or Hours
Day 2
• Making Use of Formulas for Conditional Analysis
• Comprehending Conditional Analysis
• Checking for Multiple Conditions
• Performing Conditional Calculations
• Formulas Leveraging the Lookup Functions of Excel 19 Finding the Best Match from some Banded Values Finding the Best Match with the MATCH
• and INDEX Functions
• Making use of Default Values for Match
Day 3
• Advanced Usability of the Function Library
• Manually Entering a Function
• IF Function
• AND Function
• OR Function
• Advanced Grip on Nested Functions
• Nesting IF Functions
• Using Combined Logical Functions
• Chapter Four: Filtering and Cleaning Through Data
• Introducing Various Functions that Clean and Sort Data Brief Explanations of the Above Functions and Features Validating and Limiting Your Data Mastering PivotTables
• Readying Data to Make a PivotTable
• Creating a PivotTable
• Putting Fields in the PivotTable Accessing the Classic PivotTable Layout
• Understanding the Different Areas of the PivotTable
• Rearranging the Data in a PivotTable
• Concealing and Displaying Field Data
• The PivotTable Tools Ribbon
• Modifying Calculations and Data Area Display
• Formatting a PivotTable
• Ways to Refresh a PivotTable
• Manipulating PivotTables Using Slicers
