• 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
  • 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 Customer Complaints: Communicate and Connect with your Customers
  • 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
  • MS EXCEL ADVANCED: 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
  • DIGITAL MARKETING MANAGEMENT: Native Advertising: Aligning Creative Thought Process and Storytelling with your Business Strategies
  • Business Etiquette 101: 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
  • Fundamentals of Coaching: Developing a Coaching Culture in your 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
  • Facilities Management and Comprehensive Maintenance Program
  • 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 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 Line Managers: Analyzing Financial Reports for Business Decision Making
  • 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
  • Design Thinking for Innovation: 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
  • Photoshop for Beginners: Creating Artwork For Online and Print Materials
  • 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)
  • Developing Content & Building Connections with Media
  • Basic Selling: From Tactical to Strategic Selling
  • Essentials of Business Communication: Written and Oral Communication for Everyday Use
  • eLearning Instructional Design & Development Certification Workshop
  • 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

     

    *Program fee is PHP 5,900 + VAT


    Course Schedule:

    Jul 18 - 18, 2012


    Apr 13, 2017


    Apr 13, 2017


    Sep 17, 2017


    Sep 17, 2017


    Feb 17, 2018


    Feb 17, 2018


    May 07, 2018


    May 07, 2018


    Oct 06, 2018


    Oct 06, 2018


    Nov 18, 2018


    Nov 18, 2018


    Jun 02, 2019


    Jun 02, 2019


    Aug 01, 2019


    Aug 01, 2019