Menu

Mastering Excel 2016 - Intermediate

0( 0 REVIEWS )
163 STUDENTS
Overview Excel refers to a spreadsheet program which is available in the Microsoft Office package. The main features available in …

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.

  • Why consider learning at study 365?
  • Learning outcomes
  • Access duration
  • Who is this course aimed at?
  • Entry requirements
  • Method of assessment
  • Certification and awarding body
  • Tutor info
  • Progression and career path
  • Other benefits

With so many commitments in our lives, we may not have the time to learn new skills. The beauty of studying online is that you get to find this balance between your education and your daily commitments

Study 365 offers hundreds of online courses to students across the world. Gaining new skills has never been this easy as many of our courses are open to students with little or no qualifications or previous experience. All the courses are up-to-date, relevant, affordable, and will build on existing expertise or give you a jump-start to a new career. The courses are meticulously designed and equals what is offered in a classroom setting. With a solid reputation that has established and made us made us one of the most trusted and reliable online course providers we offer the most convenient path to gain recognised skills and training that will give you the opportunity to put into practice your knowledge and expertise in your chosen career. You can learn at your own pace at Study 365 and you will be provided with all the necessary material, tutorials, qualified course instructor, narrated e-learning modules, interactive quizzes and free resources which include Free CV writing pack, free career support and course demo to make your learning experience enriching and more rewarding.

  • 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

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.

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

Learners must be age 16 or over and should have a basic understanding of the English Language, numeracy, literacy, and ICT.

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.

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.

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.

For more information, visit her website, http://eversworks.com/ and her writing blog, https://aneclecticmuse.blogspot.com/.

Christina Tankersley has been involved with software education and project management since 1994. Her career includes working on software development and varying manufacturing projects, helping people understand the power of diverse thinking, and continue to learn tools to share with customers, students, and the population at large.

Her primary focus for instruction includes:

  • Project Management
  • Leadership
  • Microsoft Software
  • Herrmann Brain Dominance Index
  • Customer Relationship Management Tools
  • Business Analysis
  • Information Technology Infrastructure Library

She has a BS in Business from the University of Charleston, an MBA from North Greenville University, and certifications including Project Management Professional (PMP), Comptia A+, Comptia Certified Technical Trainer, and Microsoft Certified Trainer.

When not working or studying, she loves to travel, read, and spend time with friends and family.

With this course in Excel 2016, you will not directly qualify for any specific job position. However, you can use this course to further improve your eligibility for a job position in the administration and finance field. If you already own an employment, you can use this course to demand for job promotions, salary increments and to progress in your career. The job positions you can use this course for, along with the average UK salary per annum according to https://www.payscale.com/career-path-planner, is given below,

  • Administration assistant – £15,928 per annum
  • Accounting manager – £26,843 per annum
  • Financial director – £71,873 per annum
  • Financial accountant – £34,662 per annum
  • 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 TOTUM 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) 

Course Curriculum

1: FUNCTIONS
1.1 Working with Named Ranges 00:00:00
1.2 Using Named Ranges in Formulas 00:00:00
1.3 Using Specialized Functions 00:00:00
1.4 Working with Logical Functions 00:00:00
1.5 Displaying Functions/Formulas 00:00:00
1.6 Nesting Functions 00:00:00
1.7 Date and Time Functions 00:00:00
1.8 Text Functions 00:00:00
2: DATA
2.1 Sorting Data 00:00:00
2.2 Filtering Data 00:00:00
2.3 Using Database Functions 00:00:00
2.4 Using Subtotals 00:00:00
3: TABLES & CONDITIONAL FORMATTING
3.1 Create and Modify Tables 00:00:00
3.2 Manipulating Table Data 00:00:00
3.3 Conditional Formatting Rules 00:00:00
3.4 Using Logical Functions with Conditional Formatting 00:00:00
4: CHARTS
4.1 Creating Charts 00:00:00
4.2 Modifying and Formatting Charts 00:00:00
4.3 Creating a Dual Axis Chart 00:00:00
4.4 Chart Templates 00:00:00
5: SHAPES, TABLES, SLICERS & MORE
5.1 Formatting Shapes and Objects 00:00:00
5.2 Creating a PivotTable 00:00:00
5.3 Analyzing PivotTable Data 00:00:00
5.4 Pivot Charts 00:00:00
5.5 Slicers and Timelines 00:00:00

Students feedback

N.A

Avarage rating ()
5 Star
4 Star
3 Star
2 Star
1 Star

No Reviews found for this course.

Contact Us

Certificate Code

Secure Payment
top
Copyright © 2019 -Study365 - All rights reserved.
WhatsApp chat