Microsoft Excel 2010 – Interactive Training Programme (German)

£80.00

Using a mixture of expert instruction, hands-on exercises and interactive quizzes the Microsoft Excel 2010 Online Training course is delivered online via the learning platform. This self-study approach allows students to work at their own pace, as and when suits them – all they need is an Internet-connected computer.

Report Abuse

Description

Grow yourself and your career by completing this comprehensive course in using Excel 2010. This step-by-step course takes novice Excel users and teaches them how to build professional quality spreadsheets with which to capture, manipulate and report on data.

In just three modules learners will move from understanding the basic principles of Excel 2010, to mastering the most advanced concepts.

The Microsoft Excel Online Training package is best suited to:

  • Professionals who need to learn how to create and manage spreadsheets using Microsoft Excel 2010 to track and report data.
  • Employees who want to expand their knowledge of the Microsoft Office suite of applications.
  • Individuals who would like to learn and apply some of the more advanced Excel techniques to help them be more productive.
  • Individuals who would like to build their own spreadsheets for use at home or at work.

This self-study approach allows students to work at their own pace, as and when suits them – all they need is an Internet-connected computer.

Students can also use the social networking platform to share tips and advice with other learners, or to ask for help should they encounter problems whilst completing exercises.

key learning points

The Microsoft Excel 2010 Online Training course is split into three sections – Basic, Intermediate and Advanced. Starting gently with the basics of understanding the Excel interface, training quickly moves on to cover:

  • Entering and editing data.
  • Creating formulae to perform automated calculations.
  • Preparing and printing spreadsheets.
  • Inserting pivot tables to provide additional analytical potential.
  • Copying and pasting data, and inserting other data types (such as images) into a sheet.

Moving on, the Intermediate modules cover several topics including:

  • Creating a sparkline.
  • Editing and auditing formulae to ensure they are delivering accurate calculation results.
  • Sorting and filtering data to display pertinent information more quickly.
  • Creating and managing charts.
  • Using multiple workbooks to manage separate, but related data.
  • Freezing panes and autosizing columns to improve data display.

Finally students will learn a number of advanced Excel 2010 topics including:

  • Using the VLOOKUP function to find precise data more quickly.
  • Using “Paste Special” to transpose data and save time re-editing information.
  • Deleting duplicate records to maintain data integrity.
  • Grouping data for analysis.
  • Applying conditional formatting to highlight certain datasets based on user actions.
  • Protecting data using passwords or the Final and Read Only designations.

The course modules cover all these topics and more, ensuring students will demonstrate complete mastery of Excel 2010 by the end of their studies.

advantages of this course

This three-phase course helps students move quickly from understanding the basics of Excel to mastering advanced techniques of using spreadsheets that they can immediately apply to their own projects.

Other benefits of the Microsoft Excel 2010 Online Training package include:

  • The skills and experience required to create useful spreadsheets that can be used to analyse and report on key business data and inform strategic business decisions.
  • A boost in confidence when building new spreadsheets from scratch.
  • An in-demand skill that will help secure new opportunities at work.
  • A good understanding of Excel 2010 that can also be used to train other employees.

Upon completion of the Microsoft Excel 2010 Online Training course, students will have an advanced working knowledge of building spreadsheets and the basic skills to take their learning further towards earning the globally-recognised Microsoft Office Specialist qualification.

Basic
  • Introduction
  • Create a New Blank Spreadsheet
  • Opening an Existing Workbook
  • Entering Data into Cells
  • Changing Cells
  • Centre the Selected Data
  • Create a Formula
  • Selecting Cells
  • Summing Cells
  • Change the Page Orientation
  • View in Print Preview
  • Print the Spreadsheet
  • Insert a Pivot Table
  • Copy and Paste
  • Insert an Image
Intermediate
  • Create a Sparkline
  • Filtering data
  • Naming a Range
  • Autosize a Column
  • Editing Formulae
  • Formula Auditing
  • Calculate the Average
  • Sorting
  • Freeze Panes
  • Creating a Chart
  • Scenarios
  • Changing Chart Type
  • Merge and Centre
  • Switch to another workbook
  • Moving and Copying Cells
Advanced
  • VLOOKUP function
  • Paste Special (Transpose Values)
  • Working with XML Data
  • Mark the Workbook as Final and Read Only
  • Import Text
  • Deleting Duplicate Records
  • Grouping Data
  • Conditional Formatting
  • Password Protect a Workbook.

Additional information

Exams Included

No

Course Type

Online Course

Expiry Date After Purchase

1 year

Associated Examination

Microsoft Office Specialist Exam (Excel)

Device Processor

1 gigahertz (GHz)

RAM Required

1 GB

Operating System

Windows 10, Windows 7, Windows 8

Browsers

Google Chrome, Internet Explorer 8 or above, Mozilla Firefox, Safari 6 or above

Compatibility

Mac, Windows

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

Vendor Information

We want you to be satisfied, so all eligible courses purchased on Vogate can be refunded within 14 days. For whatever reason, if you are unhappy with a course, you can request a refund, provided the request meets the guidelines in our refund policy.

Certain restrictions may apply and some purchases may only be eligible for credit refunds. For more information regarding our refund policy, please see below.

How to submit a refund request

If you’re looking for instructions on how to submit a refund request, please visit our support and help section

Our 14-day policy

While our 14-day refund policy is to allow customers to learn risk free, we must also protect our vendors from fraud and provide them a reasonable payment schedule. Payments are sent to vendor after 30 days, so we will not process refund requests received after 14 days of purchase.

Additional reasons for denied refunds

We reserve the right, in our sole discretion, to limit or deny refund requests in cases where we believe there is refund abuse, including but not limited to the following:

  • A significant portion of the course has been consumed or downloaded by a customer before the refund was requested.
  • Multiple refunds have been requested by a customer for the same course or other courses
  • Excessive refunds have been requested by a customer.
  • Users who have their account reported, banned or course access disabled due to a violation of our Terms or Trust & Safety Guidelines. 
  • We do not grant refunds for any subscription services.

These refund restrictions will be enforced to the extent permitted by applicable law. 

Credit only refunds

In cases where a transaction is not eligible for a cash refund, the refund will be granted using Vogate creditsprovided it otherwise meets our 14-day refund policy. 

If your course purchase is only eligible for a credit refund, this will be indicated on the refund page.

Types of purchases that are only eligible for credit refunds

iOS (Apple): iOS payments are processed through Apple and not Vogate, and so we are unable to offer cash refunds for in-app purchases made in the Apple App Store. You can read more about Apple’s refund policy here.

Bank & cash transfers: certain bank and cash transfer methods are only eligible for credit refunds.

Boleto Bancário: courses purchased through Boleto Bancário are only eligible for credit refunds.

Udemy credits: for more information regarding Vogate credits and refunds involving them, contact us.

Refunds for bundles purchased through a third party

Since the payment for the bundle was processed by the third-party vendor, we do not have the transaction on file and cannot initiate a refund for you. Please contact the third-party vendor directly to request a refund.

Product Enquiry