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
  • (2nd Batch) Effective Business Writing and Email Etiquette
  • (2nd) Impactful Visual Communication: Maximizing the Design Process to Create Value
  • (2nd Batch) Impactful Visual Communication: Maximizing the Design Process to Create Value
  • Copywriting Essentials: Create Clever and Compelling Copy
  • QuaranTEEN: A Virtual Mindfulness Workshop for Teenagers to be Self-Aware, Confident, Empathic & Resilient
  • QuaranTEEN: A Virtual Mindfulness Workshop for Teenagers to be Self-Aware, Confident, Empathic & Resilient
  • QuaranTEEN: A Virtual Mindfulness Workshop for Teenagers to be Self-Aware, Confident, Empathic & Resilient
  • QuaranTEEN: A Virtual Mindfulness Workshop for Teenagers to be Self-Aware, Confident and Empathic
  • Finance for Decision Making: A Course for Professionals to Understand the Accounting Cycle and Financial Reports
  • Speak Your Mind: Expressing Freely with Respect & Realness
  • Coaching Skills for High Productivity: Developing a Coaching Culture in your Organization
  • Effective CSR Programs: Planning and Executing Programs with Social Impact in the New Normal
  • (3rd Batch) Effective Business Writing and Email Etiquette
  • (BATCH 3) Impactful Visual Communication: Maximizing the Design Process to Create Value
  • Getting Things Done During The New Normal: Ensuring Execution in Spite of Adversity
  • Video Production Essentials: Create Videos to Communicate, Promote and Inspire
  • 7th Effective Business Writing and Email Etiquette
  • Win-win Strategies on Labor Relations Law: Use Advice to Survive and Thrive in the New Normal
  • Emotional Intelligence in the Workplace: Integrity, Adaptability and Resilience in the Workplace
  • Creative and Innovative Thinking: Creating User-focused Solutions to Address Changing Needs
  • Critical Thinking and Problem Solving: Analyze and Implement Effective Solutions
  • Essentials of Business Communication: Written and Oral Communication for Everyday Use
  • Project Management Skills for Everyday Tasks: Adopting the Mindset from Planning to Execution
  • Effective Workload and Time Management: Work Smarter and Achieve Results in the New Normal
  • Better Writing for College: A Senior HS and College Student's Guide to Write with Clarity and Confidence
  • Effective Business Writing and Email Etiquette
  • Creative Writing for Teens: A Practical Workshop to Express Yourself through Writing
  • The Essentials of Social Media Management: Amplify your Brand and Engage your Customers
  • Creating Content & Building Connections: Ensure your Brand Image Internally and Externally
  • Authentic and Practical Selling: Maximizing Opportunities in the New Selling Environment
  • Handling Conflicts in the New Normal: Building Trust and Sensitivity
  • Process Management: Documentation, Mapping & Analysis - Improving Business Processes for Effective Execution and Output
  • Effective Management Skills: Building New Leaders in the New Normal
  • 2nd Copywriting Essentials: Create Clever and Compelling Copy
  • Coaching Skills for High Productivity: Developing a Coaching Culture in your Organization
  • Ensure Your Target Market Finds You: The Online Customer Journey
  • Video Production Essentials: Create Videos to Communicate, Promote and Inspire
  • MS Excel Made Simple: A Professional’s Guide to Excel
  • Crisis and Recovery Marketing: Crafting New Marketing Strategies in a Disruptive Business Environment
  • 2nd Advanced MS Excel: Optimize its Function to Ease and Simplify Data-driven Tasks
  • Basic Macros and Visual Basic Application: Simplify and Execute Spreadsheet Tasks in just One Click
  • Critical Thinking for Teens: Achieving Smarter Solutions for Better Decision Making
  • Designing & Delivering Online Courses: Managing Digital Learning Programs for the Workplace
  • Purpose-driven Selling: Paradigm Shift for Customer-Centricity in The New Normal
  • Executive Presence in the New Normal: Confidence and Composure in Physical and Virtual Settings
  • Critical Thinking and Problem Solving: Analyze and Implement Effective Solutions
  • (6th Batch) Effective Business Writing and Email Etiquette
  • Powerful Personal Online Branding: Investing in Yourself so that Others may Invest in You
  • Managing Change: It Matters More Than Ever
  • Giving and Receiving Effective Feedback: Facilitating Crucial Conversations that Promote Productivity and Growth
  • QuaranTEEN: A Virtual Mindfulness Workshop for Teenagers to be Self-Aware, Confident, Empathic and Resilient
  • QuaranTEEN: A Virtual Mindfulness Workshop for Teenagers to be Self-Aware, Confident, Empathic and Resilient
  • QuaranTEEN: A Virtual Mindfulness Workshop for Teenagers to be Self-Aware, Confident, Empathic and Resilient
  • Professional Image and Presence: Civility and Etiquette in the Modern Business Setting
  • Designing & Delivering Online Courses: A Hands-on Virtual Workshop in Creating Courses for the Workplace
  • Crisis Communication in the New Normal: Best Practices on How to Prepare, Handle and Recover from a Social Media Crisis
  • Mindfulness at Work: Improving your Focus, Creativity and Decision Making
  • Lessons in Crisis Leadership: Lead and restore your Team’s Confidence
  • Agility for Business Recovery: Delivering Results through Agile Tools and Principles
  • Handling Customer Complaints: Understanding and Responding to Different Customer Behavior
  • Grit and Resilience in the Future: A Virtual Leadership Course for Teens to Be Adaptable Today and Persistent Tomorrow
  • Grammar Review for Business Writing: Correcting Common Mistakes for Better Communication
  • IT Service Management: Creating Value with Customers and Stakeholders
  • Advanced MS Excel: Optimize Its Function to Ease and Simplify Data-driven Tasks
  • Data Storytelling: Ensuring Your Audience is Informed, Interested and Inspired
  • Hire to Win: The HR Professional's Guide to Selecting Talents in the New Normal

    • SALES AND MARKETING

    • 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 (June 7)

    1:00pm-5:00pm

    Day 2 (June 9)

    1:00pm-5:00pm

     

    Introductory Rate:

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

    Course Schedule:

    Jun 9 - 9, 2021

    View Speaker

    Charles Fonville Charles Fonville Sep 16, 2022

    Very satisfactory