Microsoft Excel 2010

Learn Microsoft Excel in London from Ms Office specialists

This course will take place in 3-4 Kirby Street, London, EC1N 8TS. Find on map
15 %
Discount

when you buy 3 or more courses

The discount will be automatically
applied at the checkout
Looking for a
2-12 months
training?
Choose Executive PA & Secretary
Career Programme

Looking for a 2-12 months training?

Choose

Executive PA & Secretary career programme

Upcoming dates

There are no open public schedule dates for Microsoft Excel 2010 course. We can offer you a private training or arrange a public course for you. Contact us here and we can make arrangements for your course.

Course Outline

Microsoft Excel 2010 course overview

This Microsoft Excel 2010 course explains how to use Microsoft Excel. Delegates will learn Microsoft Excel by working on many practical exercises with help of an experienced MOS qualified instructor. This course covers a range of topics such as creating documents, formatting contents, page layout, including graphics, proofreading documents, applying hyperlinks and mail merge and lots more.

This Microsoft Excel course is hands-on, instructor-led and classroom based. This training can be taken as a part-time evening course or even on the weekends. A list of all upcoming public Microsoft Excel training course is given on training dragon website. Each course is restricted to a maximum of ten delegates to ensure an excellent training experience.

Certification:

This course prepares you for Microsoft Office Specialist (MOS) certification in Microsoft Office Word 2010, Exam 77-882: Excel 2010


Who is Microsoft Excel 2010 training for?

The Core-level Microsoft Office Excel 2010 User should be able to navigate Microsoft Office Excel 2010 software at the feature and functionality level. They should be familiar with and know how to use at least 80% of the features and capabilities of Microsoft Office Excel 2010. The core-level user should be able to use Microsoft Office Excel 2010 to create and edit professional-looking spreadsheets for a variety of purposes and situations. Users would include people from a wide variety of job roles from almost all areas of professional, student, and personal life. Some of the roles users might take on include, but are not limited to:

  • Accountants
  • Clerical, Office professionals
  • Consultants
  • Executives/Managers
  • Help desk personnel
  • Instructors/Trainers
  • Program/Project Managers
  • Sales
  • Students
  • Other members of the general population


Prerequisites for Microsoft Excel 2010 course

  • Basic knowledge of Microsoft Windows.
  • Experience of web browser.


What will I get?

  • Training from professional Microsoft Office specialists (MOS) qualified instructor:

    Training Dragon consultants have been implementing professional Microsoft Excel solutions for many years. Those consultants write and teach our Microsoft Excel training courses, so their experience directly informs course content.

  • Real-time Practice and Projects:

    Our Microsoft Excel courses are designed to get you started in Microsoft Excel. We work on industry related projects and tasks in this Microsoft Excel course.

  • Course Material:

    Microsoft Excel electronic notes are included in this course.

  • Course Completion Certificate:

    After completing this training your will receive Microsoft Excel course completion certificate.

  • Support and Careers Advice:

    After the course if you have any problems or questions regarding Microsoft Excel do not hesitate to contact us. Training Dragon’s trainers are expert in their fields and if you need any help with you career choice, please speak to one of our trainers.


Microsoft Excel 2010 Course Contents

Managing the Worksheet Environment

Navigate through a worksheet

  • Hot keys, name box

Print a worksheet or workbook

  • Printing only selected worksheets, printing an entire workbook, constructing headers and footers, and applying printing options (scale, print titles, page setup, print area, gridlines)

Personalise environment by using Backstage

  • Manipulate the Quick Access Toolbar, manipulate the ribbon tabs and groups, manipulate Excel default settings, import data to Excel, import data from Excel, demonstrate how to manipulate workbook properties, manipulate workbook files and folders, apply different name and file formats for different uses by using save and save as features

Creating Cell Data

Construct cell data

  • Using paste special (formats, formulas, values, preview icons, transpose rows and columns, operations, comments, validation, paste as a link), and cutting, moving, and select cell data

Apply AutoFill

  • Copy data using AutoFill, fill series using AutoFill, copy or preserve cell format with AutoFill, select from drop-down list

Apply and manipulate hyperlinks

  • Create a hyperlink in a cell, modify hyperlinks, modify hyperlinked-cell attributes, and remove a hyperlink

Formatting Cells and Worksheets

Apply and modify cell formats

  • Aligning cell content, applying a number format, wrapping text in a cell, and using Format Painter

Merge or split cells

  • Using Merge & Center, Merge Across, Merge cells, and Unmerge Cells

Create row and column titles

  • Print row and column headings, print rows to repeat with titles, print columns to repeat with titles, configure titles to print only on odd or even pages, configure titles to skip the first worksheet page

Hide and unhide rows and columns

  • Hide a column, unhide a column, hide a series of columns, hide a row, unhide a row, hide a series of rows

Manipulate Page Setup options for worksheets

  • Configure page orientation, manage page scaling, configure page margins,change header and footer size

Create and apply cell styles

  • Apply cell styles, construct new cell styles

Managing Worksheets and Workbooks

Create and format worksheets

  • Insert worksheets, delete worksheets, copy, reposition, copy and move, rename, grouping, apply colouring to worksheet tabs, hiding worksheet tabs, unhiding worksheet tabs

Manipulate window views

  • Splitting window views, arranging window views, and opening a new window with contents from the current worksheet

Manipulate workbook views

  • Using Normal, Page Layout, and Page Break workbook views, and creating custom views

Applying Formulas and Functions

Create formulas

  • Use basic operators, revise formulas

Enforce precedence

  • Order of evaluation, precedence using parentheses, precedence of operators for percent vs. exponentiation

Apply cell references in formulas

  • Relative, absolute

Apply conditional logic in a formula

  • Create a formula with values that match your conditions, edit defined conditions in a formula, use a series of conditional logic values in a formula

Apply named ranges in formulas

  • Define, edit and rename a named range

Apply cell ranges in formulas

  • Enter a cell range definition in the formula bar, define a cell range using the mouse, define a cell range using a keyboard shortcut

Presentibg Data Visually

Create charts based on worksheet data

Apply and manipulate illustrations

  • Clip Art, SmartArt, shapes, screenshots

Create and modify images by using the Image Editor

  • Making corrections to an image (sharpen or soften an image, changing brightness and contrast), using picture colour tools, and changing artistic effects on an image

Apply Sparklines

  • Using Line, Column, and Win/Loss chart types, creating a Sparkline chart, customising a Sparkline, formatting a Sparkline, and showing or hiding data markers

Sharing worksheet data with other users

Share spreadsheets by using Backstage

  • Sending a worksheet via E-mail or Skydrive, changing the file type to a different version of Excel, and saving as PDF or XPS

Manage comments

  • Inserting, viewing, editing, and deleting comments

Analysing and Organising Data

Filter data

  • Define, apply, remove, search, filter lists using AutoFilter

Sort data

  • Using sort options (values, font color, cell color)

Apply conditional formatting

  • Apply conditional formatting to cells, use the Rule Manager to Apply Conditional Formats, use the IF Function and Apply Conditional Formatting, icon sets, data bars, clear rules

View Complete Course outline

Daily schedule

The scheme below shows what a typical day at Training Dragon looks like.

10:00 11:30 11:45 13:00 14:00 15:30 15:45
Classroom Activity
This course explains how to create web pages from scratch using different techniques, such as
Tea
Break
Classroom Activity
This course explains how to create web pages from scratch using different techniques, such as
Lunch
Break
Classroom Activity
This course explains how to create web pages from scratch using different techniques, such as
Tea
Break
Classroom Activity
This course explains how to create web pages from scratch using different techniques, such as
Video Placeholder

Looking for a
2-12 months
training?

Choose

Executive PA & Secretary career programme

Our Trainers

Emiliano
Emiliano
Leads our teaching team with many years of experience in teaching web development.
Ross
Ross
Brings many years of Python and Java software development experience to classrooms.
Olu
Olu
Microsoft and Oracle certified developer with years teaching experience in Android, .NET and databases.

Latest Reviews

Frequently Asked Questions

Have a question?
We are here to answer them