Why learn the Comprehensive Excel?

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.

NEW TRAINING ALERT! 💡💻📋📌
Program Outline:
- See Below
The program will run live via Zoom.

Facilitator: Ar. Ralph Ruiz, uap
Investment Fee: 800 php only
*Discounted rates apply minimum of 3 pax.
You may also schedule an exclusive session for your team or organization.
Message us now to inquire and register.
Email: info@pressstartph.com
Limited slots only! 📌1200

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

Register Here
Scroll to Top