Microsoft Office Training: Excel 2007

Fast and easy to both learn and use, Microsoft Office Excel 2007 helps you track and report information with ease. Excel is a simple, logical spreadsheet system for people who wish to tabualte data. Create and edit detailed reports that display sorted, filtered, and grouped information in a way that helps you make sense of the data for informed decision-making.

Product Duration: 12 Months Unlimited Excel Price  Add to Cart   Microsoft Excel 2007 Training: This course is for anyone new to Microsoft Excel, or for individuals looking for an Excel refresher. Microsoft Excel 2007 Advanced Training This series is for anyone interested in learning about advanced data analysis features of Excel 2007. £99.99 £99.99

Microsoft Excel Course Lessons:

Microsoft Excel Advanced Course Lessons:

This online training will teach you entering and editing cell data, selecting cell ranges, and formatting worksheet data. Learners will also be able to print worksheets, add comments, complete basic calculations and formulas, and create charts using Excel 2007 Subject Headings: Excel 2007: Getting Started Identify tasks other than financial calculations for which Excel can be extremely helpful Locate the position of the active cell in a worksheet Make changes to Excel's application settings Identify the sections of the Formula bar Use Excel's Go To feature Add a new worksheet to an Excel 2007 workbook 2.0 hour(s) Excel 2007: Creating a Worksheet This course provides information about entering text, values and formulas into worksheet cells in Microsoft Excel 2007. It also provides information about calculating formulas and using built-in functions, like AutoComplete, AutoFill, Insert Function, and AutoSum. 2.0 hour(s) Excel 2007: Formatting Data This course provides information on creating tables in Excel 2007, including advanced features such as input masks, validation rules, and table relationships. 1.0 hour(s) Excel 2007: Editing and Printing Worksheets This course provides information about using different viewing modes to preview workbooks, distinguishing between relative and absolute cell references, copying formulas from one cell to another, and viewing copied items on the clipboard. It also provides information about deleting, inserting and hiding cells; and using the Page Setup dialog box to insert headers, footers and page breaks. 1.0 hour(s) Excel 2007: Managing Worksheets This course provides information about managing multiple worksheets, naming cells and ranges, and searching for data within your worksheet. It also covers sharing and protecting your workbooks and adding cell-specific information such as Web links and comments. 2.0 hour(s) Excel 2007: Using Charts and Objects This course provides a detailed look at how you can insert and modify charts, shapes, text boxes, pictures, SmartArt, and clip art to visually enhance your worksheets. 1.0 hour(s)

The Excel 2007 Advanced training teaches you how to apply filters, use formulas and analyse data. You will be able to apply your knowledge to create complex business applications and analyses in Microsoft Excel. SubJect Headings: Excel 2007 Advanced: Filtering and Sorting Data This course provides information on how to filter and sort your worksheets in Excel 2007. Remove duplicate records from an Excel worksheet Apply filters to an Excel worksheet Apply one-click, multiple-level, and custom sorts to your data 2.0 hour(s) Excel 2007 Advanced: PivotTables, PivotCharts, and Graphs Create pivot tables Modify pivot tables Use pivot tables to quickly and easily Analyse complex data sets Apply pivot tables for common uses 2.0 hour(s) Excel 2007 Advanced: Working with Functions Calculate results with math functions Use date and time functions Adjust text with functions Work with logic and information functions Use lookup functions to locate data Determine payments with financial functions Use statistical functions to determine relationships 3.0 hour(s) Excel 2007 Advanced: Using Data Analysis Tools Use What-If analysis in Excel 2007 Create analyses with Scenario Manager Analyse data using Goal Seek Install Solver 1.0 hour(s) Excel 2007 Advanced: Automating with VBA Macros Enable the Developer tab on the Ribbon Modify macro security settings Record and run macros Record a macro that uses an advanced filter Customize macros for everyday use Combine elements of written code with recorded code 2.0 hour(s) Excel 2007 Advanced: Adding Connections and Importing Data This course provides detail about connecting worksheets and workbooks for automatic sharing and updating. It also provides detail about importing information from the Web, text files, XML data, Access documents, and other files from external data sources. 3.0 hour(s)

If you just have a question about our Microsoft Excel Training or any other careers or training course just telephone us on 0871 222 8790 or fill in the simple form below and an advisor will contact you shortly.

If you would like some advice on training or the special deals available then complete your details below. Name Email Work Tel Home Tel Mobile Query -select course- Networking Programming CompTIA CISCO Microsoft Hardware ECDL Office Skills Web Design ICDL Dreamweaver Photoshop Word Excel Comments

Telephone: 0871 222 8790 Alternate Number: 01279 814 876 Fax: 01279 816 093 E-Mail: info@e-careers.co.uk Address: 10 Riverside Business Park, Stony Common Road, Stansted Mountfitchet, Essex, CM24 8PL

What do I get?

Interactive simulations
Feel like you are actually using the software you are being trained about in the added security of our learning environment.

Skills Assessments
Test yourself and receive a certificate online. Multiple choice or fill in the blanks style questioning helps you remember and learn

Printable reference guides and exercises
Every chapter has its own hands on exercises for you to carry out to help you gain essential experience. You also have automatic glossary and search features to help you use the course as a 'quick reference' guide

Full telephone and email support with no premium rate charges
Our friendly support team is here on hand 8am-8pm to help you out if you get stuck

Free upgrades for 12 months
For the duration of your 12 months license you will receive any updates we make to your course free of charge. Sign up for our complete package and you will be able to receive all the new courses we add free of charge.

Best price in UK guaranteed
We are so confident that you will not find another online training service of the same quality and price that we will beat any legitimate quote on a like for like basis by 10%.