• Essentials of Social Media Management: Amplify your Brand and Engage your Customers
  • Leading Effective Meetings: Optimizing your Time and Resources
  • Developing an Attitude of Professionalism: Values and Attitudes for Success
  • Effective Workload Management: Everyday Techniques to Get Things Done
  • LeaderShift Module 1: The Leader as a PEOPLE MANAGER: From Task to People Management
  • Multi-Generation Workforce Management: Bridging Work Styles across a Diverse Workforce
  • Project Management Skills for Everyday Tasks: Adopting the Mindset from Planning to Execution
  • LeaderShift Module 2: The Leader as a COMMUNICATOR: From Talking and Writing to Communicating
  • LeaderShift Module 3: The Leader as a PERFORMANCE COACH: From Performance Monitoring to Leading and Coaching
  • Handling Customer Complaints: Communicate and Connect with your Customers
  • Customer Service Recovery: Win Back Customers and Keep Them for Good!
  • DIGITAL MEDIA MANAGEMENT SERIES 4: Principles of Creative Video Production:
  • LeaderShift Module 4: The Leader as an INNOVATOR: From Typical to Critical Thinking
  • 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 Employee Development: Creating Programs for Career Growth and Retention
  • Supervisory Essentials Training: 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
  • ADVANCED MS EXCEL: Optimize its Functions to Ease and Simplify 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
  • UPCOMING COURSES

    CONTACT US

    Company Name:

    First Name:

    Last Name:

    Contact Number:

    Email Address:

    Message:

    ₱ 11,800.00

    ADVANCED MS EXCEL: Optimize its Functions to Ease and Simplify Data-Driven Tasks


    Why join the workshop?

    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, and 2016.


    Objectives:

    At the end of the workshop, the participants will be able to:

     

    • Identify advanced MS Excel functions and their usage

    • Combine Basic MS Excel functions with advanced functions in order to address more complex scenarios

    • Simplify common spreadsheet tasks using MS Excel data management tools

    • Create basic and special charts using MS Excel

    • Use advanced features of Pivot Tables in order to analyze data

    • Create macro recordings to automate tasks in MS Excel


    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:

    The workshop follows a specific course outline. The topics are as follows:

    1. 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


    Course Schedule:

    Jul 24 - 25, 2017


    May 11, 2017


    May 11, 2017