Excel 2010 - Level 3 (Formatting Cells and Worksheets)

£12.00

Price is per online user of this course, excluding 20% VAT. You pay £19.80 per user.

Excel is an electronic spreadsheet capable of organising, analysing and presenting data. The basic concept is the same as using a paper spreadsheet with a built-in calculator. The advanced features of Excel allow you to manipulate the data easily and then to graphically present it in a number of attractive formats.

This course gives you an introduction to Microsoft Excel 2010 and takes you through tasks associated with basic spreadsheet tasks. It’s compatible with 2010 operating systems. Together with our other Excel 2010 courses, this course also supports the background learning for the Microsoft Office Specialist Exam 77-882

See below for further information.

Sold By: Core Learning Services (009)

Description

When you have completed this course, you will be able to:

  • Create cell content using AutoFill
  • Use paste options and perform operations with Paste Special and copy formatting with Paste Special
  • Modify existing worksheets, hiding and unhiding rows and columns, hiding and displaying entire worksheets, inserting multiple rows and columns, and moving columns to a different location
  • Apply styles to both cells and tables and also learn how to create your own styles
  • Add backgrounds, mimic the use of watermarks used in programs such as Word, format rows and columns, and transpose data
  • Use proofing tools such as its Spelling Checker, Error Checker, AutoComplete, and AutoCorrect features that can assist you in checking, detecting and avoiding errors
  • Create macros to automate repetitive tasks and perform special calculations

Modules:

  • Adding Cell Content
  • Modifying Worksheets
  • Cell and Table Styles
  • Formatting Worksheets
  • Proofing Tools
  • Using Macros

The online course takes approximately 3 hours to complete and is available for six months from the date first accessed.

Additional information

mobile-compatible

level

resource-type

guided-learning-hours

Subject

online-access-duration

Reviews

There are no reviews yet.

Be the first to review “Excel 2010 - Level 3 (Formatting Cells and Worksheets)”

Your email address will not be published. Required fields are marked *

Keep up to date with what’s happening in the world of education, training and skills. Receive details of offers and newly launched courses, and tips on effective online and blended learning practise by signing up to our monthly newsletter. We guarantee not to sell or pass on your details and you can unsubscribe at any time.

Marketing permissions

eLearning Marketplace Ltd only use the information you provide on this form to send you a monthly e-newsletter.

You can change your mind at any time by clicking the unsubscribe link in the footer of any email you receive from us, or by contacting us at [email protected] We will treat your information with respect. For more information about our privacy practices please see our Privacy Policy. By clicking below, you agree that we may process your information in accordance with these terms.

We use MailChimp as our marketing automation platform. By clicking below to submit this form, you acknowledge that the information you provide will be transferred to MailChimp for processing in accordance with their Privacy Policy and Terms.