Invalid quantity. Please enter a quantity of 1 or more.
The quantity you chose exceeds the quantity available.
Please enter your name.
Please enter an email address.
Please enter a valid email address.
Please enter your message or comments.
Please enter the code as shown on the image.
Please select the date you would like to attend.
Please enter an email address.
Please enter a valid email address in the To: field.
Please enter a subject for your message.
Please enter a message.
You can only send this invitations to 10 email addresses at a time.
$$$$ is not a properly formatted colour. Please use the format #RRGGBB for all colours.
Please limit your message to $$$$ characters. There are currently ££££.
$$$$ is not a valid email address.
Please enter a promotional code.
N/A
Sold Out
Unavailable
Please enter a password with at least 8 characters.
You have exceeded the time limit and your reservation has been released.
The purpose of this time limit is to ensure that registration is available to as many people as possible. We apologise for the inconvenience.
This option is not available anymore. Please choose a different option.
Please read and accept the waiver.
All fields marked with * are required.
Please double check your email address. The email address format does not appear valid.
Please double-check your email address. Your emails do not match.
$$$$ requires a number between ££££ and §§§§
US Zipcodes need to be 5 digits.
Post code may contain no more than 9 letter or number characters.
Please double check your website URL.
All fields marked with * are required.
Your card expiration date is in the past.
Your card CSC needs to be 4 digits.
Please confirm your order: $$$$ You have selected to Pay by Cheque.
Click OK to confirm your order.
Please confirm your order: $$$$ You have selected to Pay at the Door.
Click OK to confirm your order.
Please confirm your order: $$$$ You have selected to Pay upon Receiving an Invoice.
Click OK to confirm your order.
Your card CSC needs to be 3 digits.
Sofort is only available in Germany and Austria.
Boleto Bancario is only available in Brazil.
PagoFacil is only available in Argentina.
Rapipago is only available in Argentina.
Please enter a valid IBAN number.
You need to accept to charge your bank account.
Your billing zip code needs to be 5 digits.
Please double check your CEP info. The CEP format should be something like 12345-678.
Please double check your tax identifier.
There was a problem saving your address.
There was a problem saving your card info.
There was a problem saving your personal information.
Please select the date you would like to attend.
McAfee Secure sites help keep you safe from identity theft, card fraud, spyware, spam, viruses and online scams.
Copying Prohibited by Law - McAfee Secure is a Trademark of McAfee, Inc.
Unknown card type.
No card number provided.
card number is in invalid format.
Wrong card type or card number is invalid.
card number has an inappropriate number of digits.
Please enter numbers here.
Please enter an integer value.
Numbers must be less or equal to $$$$
All the required fields have not been filled out. Click OK to proceed without all the required information, or click Cancel to finish entering the missing data.
Job titles must be less than 50 characters.
Please enter a donation amount.
Please select an attendee for donation.
There is currently an issue with card submission on Safari with iOS7. Please try again with a different browser or device.
Sorry, invalid event registration form.
Sorry, invalid event or database error.
Sorry, quantity must be a positive integer.
Sorry, you did not select a valid ticket.
Sorry, invalid event organiser email address.
Your order was cancelled.
Thank You. Your order has been successfully completed. Your name and email address have been added to the list of event attendees.
Sorry, that option is sold out.
Sorry, that option is no longer available.
Sorry, you entered an invalid quantity. Please enter a quantity of 1 or more next to the type or types of tickets you would like to purchase.
Sorry, you did not select any tickets to purchase. Please enter a quantity of 1 or more next to the type or types of tickets you would like to purchase.
Sorry, there are no tickets left for this event.
The tickets, ticket quantity or date and time you've requested are no longer available, due to previous sales. Please choose a different date, time or number of tickets and place your order again.
Sorry, one or more of the tickets you requested are no longer available for purchase.
Sorry, you need to select the date you want to attend.
Sorry, the promotional code you entered is not valid yet.
Sorry, the promotional code you entered has expired.
Sorry, the promotional code you entered is not valid.
Your session has expired. Try ordering again.
Sorry, your requested ticket quantity exceeds the number provided by your promotional code.
Perfect for users that have become reasonably proficient with the basic functions of excel, this Excel 2013 intermediate provides you with further knowledge of the application and enables you to use advanced tools.
Our Microsoft Excel 2013 Intermediate course is suitable for those with a basic working knowledge of Excel. Recent attendees have included; Finance Manager, Strategist - Client Development, Business Manager, Credit Manager...
Turn long lists and reports into easy to read tables
Formulas & formatting to show you cells that pass or fail your business rules
Save time by converting your frequently used workbooks into templates
Connect spreadsheets so that one updates another
Get information at a glance with conditional formatting
Reduce human error with conditional formulas
Course Syllabus
Working with Large Worksheets
Viewing options - Adjusting zoom - Using Freeze Panes - Using Split Window Hiding and displaying data - Hiding rows and columns - Creating an outline Printing large worksheets - Page Break preview - Working with page breaks - Printing multiple sheets
Working with Multiple Worksheets and Workbooks
Using multiple worksheets - Navigating between sheets - Moving and copying sheets Linking worksheets - Creating 3-D formulas - Consolidating data Linking workbooks - Creating a formula to link workbooks - Using the Paste Link option - Maintaining links
Working with dates
Entering date functions - TODAY function - NOW function Date and time formats Using dates in formulas
Conditional formulas and formatting
The IF function Conditional formatting - Based on a cell value - Based on a formula - Identifying cells with conditional formatting - Copying conditional formats
List Management
Working with lists - Structure of a list Sorting and filtering lists - Simple sorting - Sorting by multiple columns - Using AutoFilter Advanced filtering - Using custom filter - Using Advanced Filter Adding subtotals to a list
Documenting and Auditing
Comments - Viewing, adding, editing and deleting comments Auditing features - Tracing formula errors Protection - Protecting a worksheet - Protecting cell ranges
Using Templates
Built-in templates - Accessing and using Excel's templates Creating and managing templates - Creating, using and modifying a custom template file
What you get
Training is held in our modern, comfortable, air-conditioned suites
Modern-spec IT, fully networked with internet access
"What do I get on the day?"
Learning tools
Breaks and timing
Courses start at 9:30am. Please aim to be with us for 9:15am. Joining information (how to get to our venues)
In-course handbook
Contains unit objectives, exercises and space to write notes
Refreshments
Available throughout the day:
Hot beverages
Clean, filtered water
Biscuits
Reference material
Available online. 100+ pages with step-by-step instructions
Lunch
Lunch is provided at a local restaurant or pub. Browse the sample menus:
We are a provider of professional business training courses; designed for companies who want to train their staff as well as individuals who are seeking their own personal development. We offer essential courses in time management, negotiation skills, leadership, stress management, effective communication, marketing and much more!
Browse over 100 courses and qualifications whether it be Personal Development, Management, Sales or Finance training you are after, we have course to suit.
Our Services
Visit our Website for full details, Taylor Mason Training provides both open public courses in a wide range of disciplines and internal, tailored courses to match your company’s specific technical requirements. Our current portfolio includes technical (upstream) and software courses. You will learn from our training team who are themselves industry-recognised experts and who combine practical skills, commitment, and enthusiasm to answer a range of challenges faced every day.
Furthermore, Taylor Mason Training is proud to say that several of our instructors are trainers , an independent endorsement to confirm that our training is of the highest professional standard.
If you’d like to register your interest in any course, in any location around the world, then please get in touch with your suggestion.
lor Mason Training delivers professional and accredited training & development solutions to a wide range of organisations across the spectrum, encompassing FTSE 100 companies, Public sector organisations through to SMEs.
Loading your connections...
Breaks and timing
In-course handbook
Refreshments
Reference material
Lunch
24 months access to Microsoft trainers
Share Excel Intermediate 2013 Training
Share Tweet