Microsoft Excel 2010 Advanced

Product type
Level

Microsoft Excel 2010 Advanced

1TRAINING
Logo 1TRAINING

Need more information? Get more details on the site of the provider.

Description

Overview:

The Microsoft Excel 2010 Advanced course will take learners one step ahead from previous versions covering advanced Excel topics. The course will teach learners new tools and techniques that save time and energy to analyse data, export charts and graphs and share it in the best presentation method. The Microsoft Excel 2010 Advanced qualification will give individuals the skill and knowledge on how to use different file formats and save an Excel spreadsheet file, and freeze rows and columns in a spreadsheet.

The Microsoft Excel 2010 Advanced course will cover key topics including how to create eye-catching charts and graphs, showcasing basic and complex trends, and learning the di…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Overview:

The Microsoft Excel 2010 Advanced course will take learners one step ahead from previous versions covering advanced Excel topics. The course will teach learners new tools and techniques that save time and energy to analyse data, export charts and graphs and share it in the best presentation method. The Microsoft Excel 2010 Advanced qualification will give individuals the skill and knowledge on how to use different file formats and save an Excel spreadsheet file, and freeze rows and columns in a spreadsheet.

The Microsoft Excel 2010 Advanced course will cover key topics including how to create eye-catching charts and graphs, showcasing basic and complex trends, and learning the difference between data, relationships and charts.

The Microsoft Excel 2010 Advanced course will give insight into Excel tools whether it is about setting up live charts, learning how to use Pivot Charts and Tables and how to use numbers and columns so that the rows related easily. The course is internationally recognised and accredited to a training organisation and you will be issued an internationally recognised qualification following full completion of Microsoft Excel 2010 Advanced course.

Why consider 1Training?

As improvements and advancements are made in technology, online courses are no longer just conventional means of studying at affordable costs. In many aspects online training offers superiority to traditional learning. There is an effectiveness and convenience that traditional learning cannot provide. The overall convenience and flexibility makes it a superior learning method.

1Training offers the most convenient path to gain an internationally recognised qualification that will give you the opportunity to put into practice your skill and expertise in an enterprise or corporate environment. You can study at your own pace at 1Training and you will be provided with all the necessary material, tutorials, qualified course instructor and multiple free resources which include Free CV writing pack, Nus Discounted Card, Free career support and course demo to make your learning experience enriching and more rewarding.

Learning Outcomes

  • Learn how create charts and graphs
  • Learn how to deal with complex trends in charts and graphs
  • Learn how to use pivot charts and pivot tables
  • Learn how to insert graphics into the spreadsheet
  • Learn how to format charts and graphs like the experts

Course Curriculum

  • Module 01: Logical and Statistical Functions
  • Module 02: Financial and Date Functions
  • Module 03: Lookups and Data Tables
  • Module 04: Advanced Data Management
  • Module 05: Exporting and Importing
  • Module 06: Analytical Tools
  • Module 07: Macros and Custom Functions

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 anytime.

Who is this Course aimed at?

  • The course is aimed at learners who want to acquire skills in advanced Excel 2010.
  • Students wishing to acquire knowledge in Microsoft Office Excel from an earlier version.
  • The course is suitable for people working in an office environment.
  • Anyone interested in expanding their skills in Microsoft Office Excel 2010.

Method of Assessment

At the end of the Microsoft Excel 2010 Advanced course you will be required to take a multiple choice question assessment test. The multiple choice question assessment will be automatically marked with learners receiving an instant grade.

Certification

Those who successfully complete the exam will be awarded the certificate in Microsoft Excel 2010 Advanced.

Entry Requirements

  • You must be over the age of 16 and have a basic understanding of Maths, English and ICT
  • Job seekers / graduates / school leavers

Awarding Body

The certificate will be awarded by CPD and iAP. This internationally recognised qualification will make your CV standout and encourage employers to see your motivation at expanding your skills and knowledge in the IT enterprise.

Progression and Career Path

Once you successfully complete Microsoft Excel 2010 Advanced you will be qualified to work in the following positions. The Microsoft Excel 2010 Advanced qualification will also put you in line to demand a higher salary or job promotion. The average UK salary per annum according to https://www.payscale.com is given below.

  • Office Administrator – £17,158 per anuum
  • Office Manager – £24,073 per anuum
  • Receptionist – £15,961 per anuum
  • Personal Assistant – £25,003 per anuum
  • Project Assistant – £20,785 per anuum
  • Business Executive – £23,667 per anuum
  • Secretary – £19,460 per anuum
  • Business Analyst – £35,543 per anuum
  • Technical Support Analyst – £22,753 per anuum

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
  • Excellent Tutor Support Service (Monday to Friday)
  • Save time and money on travel
  • Learn at your convenience and leisure
  • Quizzes, tests mock exams, practice exams to ensure you are 100% ready
  • 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)
There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate £1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.