More

MS Excel 2010: Complete

PRICE
£39.00 (inc VAT)
£32.50 (ex VAT)
Credit cards
Quantity
Details

Buying for business and need more details? Find out how eCourses can help.

DISCOUNTS ARE AVAILABLE FOR THIS COURSE
Buy 5 or more copies of this course to qualify for a bulk discount. Simply select the number of people who require training, and your discount will be applied when you check out.

Overview

This course collection gives you a comprehensive understanding of Microsoft Excel 2010 and takes you, step-by-step, through the tasks associated with creating cell data, formatting cells and worksheets. You'll also learn how to apply formulas and functions, and present data visually using the many useful features of Excel 2010. Bookmarking allows you to dip in and out, so you can learn whenever suits you, plus you can jump directly to specific topics of interest quickly and easily.

MS Excel 2010: Complete

Details

Using interactive exercises and software simulations, you’ll quickly become familiarised with the Excel 2010 environment and its documents, functions and features. The course modules are:

MS Excel 2010 Introduction - Learn how to create tables in the Microsoft Excel program, to enter data in them, to format the data and edit the table format. You will provide calculations through simple functions and formulas and will familiarize yourself with the basics of chart creation and formatting.

MS Excel 2010: Intermediate - Learn advanced techniques for data processing in Excel (formatting, locking, using templates, advanced copying etc.). You will be creating complex formulas and using functions belonging to the date & time and text categories, as well as the logical, financial and database functions. You will also learn how to filter lists on a sheet, create pivot tables and practice advanced chart editing.

MS Excel 2010: Advanced - Learn to work with the advanced Microsoft Excel functions for data manipulation and analysis. You will familiarize yourself with macro creation, with the XML format and its use in MS Excel, with protecting and managing permissions for accessing workbooks.

Modules

MS Excel 2010: Introduction

  • Introduction to Excel
  • Data entry and editing; Worksheet navigation and basic settings; Cell range selection; Manipulation with cell ranges; Cell inserting and deleting; Text and cell formatting
  • Number, Date and Time format; Formatting via style gallery; Working with files and windows; Printing smaller tables
  • The AutoSum button and formula copying; Custom formula creation; Work with functions; Chart creation; Chart formatting; Proofing
  • Basic Excel settings; Getting help


MS Excel 2010: Intermediate
  • Lock; Advanced cell formatting; Conditional and custom formatting; Templates
  • Workbook properties and work with sheets; Sharing workbooks and tracking changes; Comments and workbooks comparing
  • Copying options, orders and lists; Formula creation and absolute links; Errors and formulas dependencies; Connected sheets
  • The IF, MIN, and COUNT functions; Functions and formulas used for Date and Time data; Functions for working with text; Rounding off; Financial functions
  • Techniques of work with relation tables; Data validation and sorting; Go To, Find and Replace orders; Printing larger tables; AutoFilter;Criteria table and advanced filter
  • Database functions; Outlines and totals; Splitting text into columns; Pivot table; Editing pivot tables and charts; Advanced chart editing


MS Excel 2010: Advanced
  • Work with range names; Form creation in a sheet; Protection options within workbooks; Conditional calculations; Conditional calculations using SUMIF and COUNTIF: Working with an array; Calculation criteria in database functions
  • Using functions for searching in tables; Data import; Work with Microsoft Query; Complicated queries in Microsoft Query
  • Data merging; Sheet scenarios; Resolver; Resolver; What-if analysis and goal seek; Statistical methods and functions
  • Macros recording and usage; The VBA code view and editing; Webpages, links and e-mail sending
  • File security; Permission control; Introduction to XML; Working with data in the XML format.

Certificate

A learndirect certificate will be emailed to you when you have successfully completed the course

Quantity
Details

Buying for business and need more details? Find out how eCourses can help.

DISCOUNTS ARE AVAILABLE FOR THIS COURSE
Buy 5 or more copies of this course to qualify for a bulk discount. Simply select the number of people who require training, and your discount will be applied when you check out.

×