Back to Subjects

Excel

See below as an example of what we offer in bespoke Microsoft Excel training. If you're a complete beginner just one day can teach you all you need to know to create a basic spreadsheet from scratch; if you feel more confident, or are a more advanced user, just mix and match those topics you would like to learn. Choose a level or mix and match to select exactly what you wish to learn.

Many people receive Excel spreadsheets with their sales figures and often don't know how it has been put together. Learn what a day's Excel training can do - how to present your work in the best way, centre headings, write formulae, create running totals, insert rows and columns, merge cells, insert charts and graphs, and use its data processing features. Or alternatively, increase your knowledge of how to write formulae, functions, pivot tables and more.

Tell me what you need, what level, or mix and match levels - I will prepare a day's training just for you.

Beginners

• Introduction to Excel 2000, 2003, 2007, 2010
• Crossover to Microsoft Excel 2010
• Creating, editing and saving an Excel spreadsheet
• Page layout - margins, landscape, portrait, fit to size, gridlines
• Autofill and Autolists
• Column and Row inserting, deleting, moving
• Print features
• Header/footer
• Basic Formula writing - relative and absolute
• Sum, count, max, min functions
• Linking worksheets
• AutoSum and other functions
• Date and Currency formats
• Useful shortcut codes for quick navigation of your text and for editing purposes
• Create charts and graphs
• Autofilter and sorting
• Conditional Formatting

Intermediate

• Excel Spreadsheet Layout enhancements and customisation - formatting cells, spacing, alignment, borders
• Advanced chart and graph presentation - manipulating data, formatting text, enhancing layout
• Custom Number formats
• Using comments
• The MDAS rule
• Use of Function Wizard - writing formulas
• If and lookup functions
• Customised filters and autofilters
• Managing large Excel spreadsheets effectively - linking, naming cells, using names in formulas
• Paste Special
• Freeze panes
• More Printing options
• Validation, lists and input messages
• Custom lists

Advanced

• Creating, editing and running Macros
• Tracking and auditing
• Forms
• Error messages in formulas
• Conditional formatting
• Nested functions
• Match, FV, PMT functions
• Nested if statements
• V and hlookups
• Input Data Tables
• Pivot tables
• Subtotals
• Advanced filters
• Importing external data
• Exporting data
• Inserting pictures and hyperlinks
• Default customisation of Excel spreadsheet layout
• Using styles

Click here to see the training rates. Please ask for a detailed Excel Spreadsheets Course Content Sheet to select what you would like to learn.

If you are unsure of your requirements please contact me

Top of Page

Other Subjects:

MS Office Crossover Windows Web Design Dreamweaver Access
Excel
Outlook
Project
Publisher
PowerPoint
Word
English
Elocution
Proofreading

Tweets by @pabtrainingIT

Home  Subjects  Web Design  Dates  Prices  Testimonials  Contact Us 

This page was last modified: 17 May, 2013