Skip to content

MS Excel 2010 Training Course: Advanced


EduCBA

Summary

Price
£29 inc VAT
Study method
Online
Duration
Self-paced
Qualification
No formal qualification

1 student purchased this course

Add to basket or enquire

Overview

  • This online tutorial aims to help its participants learn the new and improved features of Microsoft Excel 2010 version.
  • It would tell you the differences in the MS Excel 2007 vs. MS Excel 2010 version.
  • This module is ideal for those who want to enhance their knowledge about Excel 2010. The Advanced Excel functions would increase your excel proficiency and help you work more effectively and efficiently.
  • The functions have been explained step-by-step and extensively with the help of short case studies, examples to make it more practical and easy for the participant to understand.

At the end of successful completion of this Excel training 2010-Advanced course the participants should be able to:

  • Use Excel functions such as the Paste Special, Logical functions, Arithmetic functions and functions like COUNT, COUNTIF, COUNTA etc.
  • Learn Data functions like INDEX, VLOOKUP, HLOOKUP
  • Usage of advanced tools like dynamic graphs, conditional formatting, arrays, advanced formatting, Pivot tables, and automation.

MS Excel 2010 – Advanced Training Course Highlights:

  • Key Difference MS Excel 2007 vs 2010

Through this module, we will learn about what are the key differences between MS Excel 2007 and 2010 in terms of different functions like office button, screenshots, equation editor etc.

  • Useful Excel Functions

Through this module, we will learn about different useful excel functions like paste special, logical functions, arithmetic functions, Count function etc

  • Data Functions

Through this function, we will learn about different data functions like choose function, vlookup, offset function, forecast function etc.

  • What If Analysis

This module will teach us different what-if analysis functions like one-dimensional data, solver goal seeks etc.

  • Arrays

Different array functions like transpose, frequency, etc will be taught through this module.

  • Other excel functions

You will learn about different like functions for working with text – Proper, upper etc, pivot tables, names and dynamic ranges, auditing, and troubleshooting formulas

  • Form Controls

This module we will teach us different from controls like group boxes, check boxes, scroll bars and spinners etc

  • Important Excel Tools

There are different important excel tools which one should know should know. This module will teach you different excel functions like text to columns, grouping tabs, hyperlinks, random numbers, custom view etc.

  • Advanced Charts

The charts and graphs are very necessary in order to present the data effectively in a report. This module will teach you different advanced graphs and charts like excel 2010 sparklines, range charts, scenario graphs, invert negatives, scrolling chart etc.

Description

Target Audience for Excel 2010 – Advanced Training Course:

This course is intended for Students/professionals who want to learn Advanced-level Excel 2010 skills.

Pre-requisites for Excel 2010 – Advanced Training Course:

  • Passion to learn
  • Computer with Internet connection

Where do our learners come from?Professionals from around the world have benefited from eduCBA’s Microsoft Excel 2010 – Advanced Training Course courses. Some of the top places that our learners come from include New York, Dubai, San Francisco, Bay Area, New Jersey, Houston, Seattle, Toronto, London, Berlin, UAE, Chicago, UK, Hong Kong, Singapore, Australia, New Zealand, India, Bangalore, New Delhi, Mumbai, Pune, Kolkata, Hyderabad and Gurgaon among many.

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.