Mastering Excel 2016 – Intermediate

Overview

Excel refers to a spreadsheet program which is available in the Microsoft Office package. The main features available in Excel are graphing tools, calculation and pivot tables. Excel has become the most widely used program by organizations among the other spreadsheet programs. Excel spreadsheets are mainly used by organizations to record expenses and income, organize lists, plan budgets, create multi-layered and interactive reports and many more. Excel can benefit individuals as well in planning and organizing their groceries, recording their income and expenditure and to calculate ROI value.

Microsoft Excel is considered to be an essential and practical program for most modern businesses. Most businesses expect their employees and potential candidates to be well acquainted with Excel in order to effectively perform the administration and financial activities of the organization. This course will be ideal if you already know the basics of Excel or have a certificate in mastering Excel 2016 (basics). This course will teach you how to manage data, charts, and tables, and how to use powerful tools such as PivotTables, Pivot Charts, Slicers, Timelines, and more.

Course Curriculum

1: Functions

2: Data

3: Tables & Conditional Formatting

4: Charts

5: Shapes, Tables, Slicers & More

Learning outcomes

• Working with Named Ranges and Tables
• Using Logical, Text, Date, and other Functions
• Sorting, Filtering, and Summarizing Data
• Creating PivotTables and Pivot Charts
• Using Conditional Formatting
• Adding Slicers and Timelines to Analyze Information

Access duration

The course will be directly delivered to you, and you have 12 months access to the online learning platform from the date you joined the course.  The course is self-paced and you can complete it in stages, revisiting the lectures at any time.

Who is this course aimed at?

• Students
• Job seekers
• Employees and employers
• Anyone interested in mastering Microsoft Excel 2016 (intermediate)

Method of assessment

At the end of the course, you will have one assignment to be submitted (you need a mark of 65% to pass) and you can submit the assignment at any time. You will only need to pay £19 for assessment and certification when you submit the assignment. You will receive the results within 72 hours of submittal, and will be sent a certificate in 7-14 days if you have successfully passed.

Certification and awarding body

Those who successfully complete the course will be awarded the Mastering Excel 2016 – Intermediate certificate by CPD & iAP. The qualification will make you valuable to employers, and your motivation at gaining new skills will be recognised.

Tutor info

It doesn’t take long for people who meet Barbara Evers to recognize her talents in written and verbal communication. Tapping into this strength, Barbara has found success in many facets of her life. Her mission is to help others do the same professionally and personally.

Barbara received a Bachelor of Arts degree in Zoology and a Master of Arts in Professional Communication from Clemson University. She is an active member of the Association for Type International, and her certifications include:

• Myers Briggs Type Indicator
• Coaching Using Multiple Models
• Global Corporate College (GCC)
• Development Dimensions International (DDI)
• Zig Ziglar
• Achieve Global

Barbara  has over twenty-five years’ experience in training and public speaking with an emphasis in Career Development. With a broad list of clients in the corporate, non-profit, and government arenas, she excels in teaching participants the skills and techniques that will advance their careers. Her educational and career pursuits have provided a diverse background for her to use in instructional design and in the classroom.  She draws from this experience to customize her materials and provide a valuable, interactive experience for each participant. Her areas of expertise include Communication, Customer Service, Management, and Leadership as well as software training.

Barbara lives in Greer, SC and is a published writer and the recipient of several writing awards, including a Pushcart Prize nomination. She writes for several blogs including two of her own and is an active member of South Carolina Writers Association and HubCity Writers.

Other benefits

• Written and designed by the industry’s finest expert instructors with over 15 years of experience
• Repeat and rewind all your lectures and enjoy a personalised learning experience
• Gain access to quality video tutorials
• Unlimited 12 months access from anywhere, anytime
• Save time and money on travel
• Learn at your convenience and leisure
• Eligible for a NUS discount card
• Free Career Support Service
• 25% Discount on personal Statement and covering letter writing service
• Free Access to Over 150 courses for 2 days (48 hours)
• Free access to course before you purchase (For selected courses only)