Back to Courses

Microsoft Excel 2013 Training Course Advanced

Training by Computer Tutoring Ltd

Enquire Now

On-Site / Training

Inquire to Request Schedule

GBP 340.00

Enquire Book Now

RESPONSE RATE

Details
Outline
About the Provider

Book Now

Enquire

Details

What are Macros? How do I edit the code? Why should I use them? If these are questions you've asked then this is the course for you. Although this course focuses primarily on Macros there are other aspects to hone your Excel skills.

You will become familiar with some of the more advanced features in Excel.

Outline

Using Macros in Microsoft Excel 2013

Recording a Macro
Editing the Macro Code
Attaching a Macro to a Button on the Ribbon

Conditional Formatting in Excel 2013

Using Formulas with Conditional Formatting
Customising the Icon Sets

Working with Others in Excel 2013

Password Protecting Files
Sharing Workbooks
Tracking Changes
Merging Workbooks
Digital Signatures

Data Validation in Excel 2013

Ensuring Users Enter the correct Text
Using Drop Down Lists
Giving guidance to users by displaying an Input Message
Giving custom error messages

Auditing Worksheets

Trace Formulas
Finding Errors in your Formulas
Evaluate your Formulas
Scenarios
Using the Analysis Toolpak Add on
Sparklines - Mini charts in your Cells

Integrating External Data in Excel 2013

Getting live Data from the Web
Getting Data from Access
Using XML with Excel 2013

Reviews

Be the first to write a review about this course.

Write a Review

For over 13 years Computer Tutoring have trained a wide range of web design, Microsoft and Adobe courses to individuals and businesses across London and East Anglia. Approachable and experienced trainers can help you to boost your confidence and enjoy learning.

To accommodate busy companies, Computer Tutoring can tailor the training so that the maximum benefit is felt in the shortest amount of time. For instance if a company would like help on how to transform their Adobe Photoshop images for use on their website, plus they need to alter an Adobe InDesign file and ensure that it is polished ready to go to print then we can combine the two. If you are not sure then just ask. An experienced Computer Tutoring Trainer can give you a no obligation call to discuss.

Computer Tutoring has trained people from many different companies / organisations. Clients have included: Argos. Walkers. Bokomo Foods. Home-Start UK. Smurfit Kappa. John West Foods. Europa Components. Humberside Airport. The Walt Disney Company. Royal Society of Chemistry. Many testimonials are listed on the Computer Tutoring website.

View Complete Profile

Office Application & Computer System Office Application & Computer System Human Resources