• 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 SERIES 2: Customer Service Recovery:
  • 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 in the Workplace: Analyze and Implement Effective Solutions
  • CUSTOMER SERVICE SERIES 3: 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
  • UPCOMING COURSES

    CONTACT US

    Company Name:

    First Name:

    Last Name:

    Contact Number:

    Email Address:

    Message:

    ₱ 5,900.00

    MS EXCEL MADE SIMPLE: Beginners Guide to Basic Excel


    Why join the workshop?

    This course aims to provide the fundamentals of MS Excel which will allow participants to utilize the software for their daily tasks.  It will cover the essential functions, data management tools, basic charting, and Pivot Tables. This course prepares participants to take on advanced MS Excel features.

    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 essential MS Excel functions and their basic usage

    • Simplify common spreadsheet tasks using MS Excel data management tools

    • Create basic charts using MS Excel

    • Use basic to intermediate features of Pivot Tables in order to analyze data


    Who Should Attend:

     

    The workshop is ideal for supervisors and managers who generate basic reports, forms, or trackers using MS Excel. Clerks and general office personnel whose task includes the use of MS Excel applications will benefit from this training.


    Outline:

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

    A.Essential Excel Functions

    • Basic Arithmetic Formulas: SUM, AVERAGE, etc.

    • Text Functions: LEFT, RIGHT, CONCATENATE, etc.

    • Math Functions: COUNTIF, SUMIF, RANK, etc.

    • Basic Logical Functions: IF

    • Basic Lookup Functions: VLOOKUP

     

    B.  Data Management

    • Text- to- Columns

    • Conditional Formatting

    • Applying Conditional Formatting

    • Data Bars, Color Scales, and Icon Sets

    • Flash Fill

    • Subtotal

    • Consolidate Tool

    • Data Validation

    • Creating Basic Dropdown Lists

    • Other Data Validation Options



    C.  Charting

    • Review of Basic Chart Elements

    • Gridlines

    • Axes

    • Data Tables

    • Data Labels

    • Legends

    • Basic Charts (Pie, Line, and Column Charts)

     

    D.  Introduction to PivotTables

     

    • Creating PivotTables

    • Modifying Value Field Setting

    • Using the Group Feature


    Course Schedule:

    May 23 - 23, 2017


    Apr 13, 2017


    Apr 13, 2017