CONTINUING PROFESSIONAL DEVELOPMENT FOR CPAS

INQUIRER CORE COURSES

OTHER COURSES

  • Essentials of Social Media Management: Amplify your Brand and Engage your Customers
  • Planning and Leading Productive Meetings: Optimizing your Time to Attain Results
  • Developing an Attitude of Professionalism: Values and Attitudes for Success
  • Effective Workload Management: Everyday Techniques to Get Things Done
  • Multi-Generation Workforce Management: Bridging Work Styles across a Diverse Workforce
  • Project Management Skills for Everyday Tasks: Adopting the Mindset from Planning to Execution
  • Handling Conflicts in the Workplace: Building Trust and Sensitivity
  • Customer Service Recovery: Win Back Customers and Keep Them for Good!
  • Effective Video Production: How to Produce Interesting, Compelling, and Viral Videos
  • Critical Thinking and Decision Making in the Workplace: Analyze and Implement Effective Solutions
  • The R.O.I. on a Customer Service Mindset: Reaping the Benefits of a Customer Service Culture
  • Professional Image and Presence: Civility and Etiquette in the Modern Business Setting
  • Managing People Development: A Toolbox Session on Initiating and Managing Programs for Employees Satisfaction and Productivity
  • Supervisory Essentials: From Task to People Management
  • Interactive & Engaging Presentation Skills: Applicable Tools & Techniques for your presentation
  • Sales Proficiency Training (SPRING): Methods and Techniques in Sales & Negotiation
  • Digital Marketing Toolbox: Using the Paid, Owned, and Earned Model
  • PHONETOGRAPHY: Explore, Create, & Inspire using your Smartphone
  • Supervisory Essentials Training: Leader as an Effective Communicator
  • MS Excel Made Simple: Beginners Guide to Basic Excel
  • CODING FOR KIDS (PART 1): Enhancing Creativity & Critical Thinking
  • Mastering MS Excel: An Advanced MS Excel Course to Optimize Its Functions and Tools for Data-driven Tasks
  • CREATE A STRESS - FREE SPACE: Managing Stress for a Happier and Healthier you
  • Building and Condo Management: Property & Facility Management, Leasing and Preventive Maintenance
  • Marketing 101: How Marketing is at the core of every growth strategy
  • Practical Enterprise Architecture
  • DIGITAL MARKETING MANAGEMENT: Native Advertising: Aligning Creative Thought Process and Storytelling with your Business Strategies
  • Back to Basics: Business Etiquette - Professional Guide to Projecting the Best Image of your Company
  • Basic Quality Toolkit: Apply the 8 tools used to improve Productivity, Efficiency and Effectiveness
  • Creating and Enhancing Relationships with Customers: How to Achieve Customer Engagement and Loyalty
  • Exploring MS Powerpoint and Beyond: Interactive and Engaging Presentation Tools
  • Coaching for Results and Impact: Developing a Coaching Culture in the Organization
  • Effective Selling: Elevating your Sales Game with Tools and Techniques to Close a Sale
  • Strategies in Digital Writing: How to Write Lean, Fast, and Viral
  • Comprehensive Maintenance and Facilities Management
  • Effective CSR Programs: Planning and Executing Relevant Programs with Social Impact
  • Basic Macros and Visual Basic Application: Simplify and Execute Spreadsheet Tasks in just One Click
  • Property Management of Subdivision Projects
  • Fundamentals of Developing People: Ensure your Employees' Growth and Productivity
  • Process Management: Documentation, Mapping, and Analysis - Improving Business Processes for Effective Execution and Output
  • Effective Negotiation Skills: Applying the Different Styles of Negotiation for Everyday Application at Work
  • Productivity Plus: Purpose + Passion = High Performance
  • Lean Thinking and Management: Eliminating Waste and Adding Value
  • Conflict Management: A Win-Win Approach
  • DIGITAL TRANSFORMATION: Maximizing technology to enhance Customer Experience, improve Operational Efficiency, and expand Business Models
  • Finance for Decision Making: A Course for Non-accountants to Understand the Accounting Cycle and Financial Reports
  • Tourism Marketing: Creating a Marketing Plan for your Tourism and Hospitality Business
  • Mindfulness in the Workplace: Improving your focus, creativity, and decision making
  • Full Stack Web Development: Acquire In-Demand Skills to Create an E-Commerce Website
  • Events Management: Techniques and Strategies on Planning and Launching Events
  • Crucial Conversations: How to deal with Power, Position and Authority
  • Handling Customer Complaints
  • Review Class for CISI Exam: International Introduction to Securities and Investment
  • Review Class for CISI Exam: International Introduction to Securities and Investment
  • Social Media Analytics: Drive results to your business through a data-driven approach
  • Getting Things Done: The Power of Execution
  • Leadership Excellence in Challenging Times: Future-proofing your Organization
  • Building and Condo Management: Property & Facility Management, Leasing and Preventive Maintenance (CEBU)
  • Strategic Key Account Management: Planning and Implementing Dynamic Account Strategies
  • Innovation Through Design Thinking: Techniques and Processes to Create User-focused Solutions in the Workplace
  • Simplified Tax Compliance for SMEs: Applying Best Practices and Approaches
  • Coding for Beginners: Explore a New Career in Programming
  • Present! - A Mindfulness Workshop for kids to improve focus and creativity
  • Chill Out: A Mindfulness Workshop for Teens to pay attention to current state of emotions
  • Effective Visual Communication: Create Compelling Content
  • Handling Conflicts in the Workplace: Building Trust and Sensitivity
  • Project Management Toolbox: Adopting the Mindset from Planning to Execution (CEBU)
  • Speaking with Confidence: Overcoming Anxiety in Public Speaking
  • Graphic Design Basics: Creating Artwork for Multiple Channels
  • Project Management Toolbox: Adopting the Mindset from Planning to Execution
  • Selling to Managing: Making the Leap from Individual Performer to Sales Leader
  • Create an Impactful Online Brand Image: Ensure a Connection with your Target Audience
  • Practical Labor Relations: Useful Advice and Tips on Employee Discipline
  • Highest and Best Use of Properties: Determining the Best Use and Highest Value for Maximum Profit
  • Critical Thinking and Decision Making in the Workplace: Analyze and Implement Effective Solutions (CEBU)
  • Practical Labor Relations: Useful Advice and Tips on Employee Discipline
  • Effective CSR Programs: Planning and Executing Relevant Programs with Social Impact (CEBU)
  • MACE: Developing Content & Building Connections with Media - Ensure your Brand Image Internally and Externally
  • Basic Selling: From Tactical to Strategic Selling
  • Essentials of Business Communication: Written and Oral Communication for Everyday Use
  • eLearning Instructional Design & Development Certification Workshop
  • Design Thinking for Innovation: Techniques and Processes to Create User-focused Solutions in the Workplace
  • Leading Digital and Culture Transformation: Unifying Technology and Culture for Impactful Change
  • Speaking with Confidence: Overcoming Anxiety in Public Speaking (CEBU)
  • Emotional Intelligence in Leadership: Knowing Yourself and Leading Your Team Effectively
  • Copywriting Essentials: Create Clever and Compelling Copy
  • Effective Business Writing (CEBU)
  • MACE: The Essentials of Social Media Management - Amplify Your Brand and Engage Your Customer
  • Create an Impactful Online Brand Image: Ensure a Connection with your Target Audience (CEBU)
  • Delighting Customers: Knowing, Serving, and Keeping Them
  • Authentic Conversation: Getting Comfortable with Important and Meaningful Conversations
  • MS Excel Made Simple: A Professional's Guide to Excel
  • Create an Impactful Online Brand Image: Ensure a Connection with Your Target Audience
  • Effective Business Writing and Email Etiquette
  • Impactful Visual Communication: Maximizing the Design Process to Create Value
  • Creativity and Innovation Through Design Thinking: Techniques and Processes to Create a User-focused Solutions in the Workplace
  • Effective Negotiation Skills: Applying the Different Styles of Negotiation for Everyday Application at Work
  • Essentials of Business Communication: Written and Oral Communication for Everyday Use
  • Advanced MS Excel: Optimize Its Function to Ease and Simplify Data-driven Tasks
  • Advanced MS Excel: Optimize Its Function to Ease and Simplify Data-driven Tasks
  • Critical Thinking and Decision Making in the Workplace: Analyze and Implement Effective Solutions
  • Effective Virtual Meetings: Embracing New Mindsets and Behavior for Productive Discussions
  • Effective Management Skills: Building New Leaders in the New Normal
    • UPCOMING COURSES

    CONTACT US

    Company Name:

    First Name:

    Last Name:

    Contact Number:

    Email Address:

    Message:

    ₱ 5,040.00

    Advanced MS Excel: Optimize Its Function to Ease and Simplify Data-driven Tasks

    Why join the workshop?

    This is an online course.

    This course aims to demonstrate the application of advanced MS Excel functions and tools on more data-driven tasks.  Aside from reviewing the essential functions, this course will introduce less common functions which may be used to further ease and simplify spreadsheet tasks.

    The course will also cover data management tools and their advanced usage, how to create special charts, a thorough discussion on Pivot Tables, and an introduction to macros.

    This course is applicable to MS Excel 2007, 2010, 2013, 2016, and 2019. 

    Objectives:

    • Create general macro recordings to automate basic repetitive tasks in MS Excel

    • Introduce essential codes in VBA

    • Create decision and loop structures in VBA—which ultimately automates most tasks in MS Excel

    • Create user forms that can be used by the spreadsheet to interact with the users

    • Create user-defined functions that can be deployed in the workplace

    Who Should Attend:

    The workshop is ideal for supervisors and managers who generate reports, forms, or trackers using MS Excel. Also for employers working with large amounts of data using the application, and those who want to learn more of its functions and tools.

    Outline:

    A. MS Excel Functions

    • Text Functions
      - Combining Texts
      - Changing Case
      - Other Accessory Text Functions
    • Logical Functions
      - Basic IF Statements
      - Nested and Series IF Statements
    • Math Functions
      - Basic Math Functions
      - Named Ranges
      - Conditional Math Functions
    • Date Functions
    • Lookup Functions
      - VLOOKUP
      - Advanced Lookup Functions

     

    B. Data Management Tools

    • Text-to-Columns
    • Delimited
    • Fixed Width
    • Conditional Formatting
      - Basic Conditional Formatting
      - Formula-Based Format
    • Data Validation
      - Basic Dropdown Menus and Cell Validations
      - Dependent Dropdown Menus
    • Subtotal
    • Consolidate Tool
    • Flash Fill

     

    C. Charts

    • Basic Charts
    • Combination Charts
    • Complex Charts
    • Sparklines

     

    D. PivotTables

    • Basic PivotTable Features
    • Tables
    • Advanced PivotTable Features

     

    E. Introduction to Macros

    • Understanding Macro Security
    • Macro Recording
    • Assigning Macros to Images and Buttons

     

    Program Schedule:

    Day 1

    9:00am - 12:00nn 

    2:00pm - 5:00pm

     

    Day 2

    9:00am - 12:00nn 

    2:00pm - 5:00pm

      

    Introductory Rate:

    Php 5,040 (Php 4,500 plus 12% VAT)

    Course Schedule:

    Aug 27 - 27, 2020

    View Speaker