Microsoft Excel 2016 Advanced Training Course
Training by
Computer Tutoring Ltd
Enquire Now
On-Site
/ Training
Details
If you are comfortable using Excel and already familiar with creating formulas, using functions; creating table, using basic charts and creating and working with PivotTables then this is the course for you.
Take your already excellent Excel skills to the next level, let Microsoft Excel to the hard work for you. The more you learn about how to get Excel to do the hard work for you, the more you''ll be able to focus on getting the answers you need from the vast amounts of data your organization generates.
During this course you will:
- Work with multiple worksheets and workbooks
- Use Lookup functions and formula auditing
- Share and protect workbooks
- Automate workbook functionality
- Create sparklines and map data
- Forecast data
Outline
Working with Multiple Worksheets and Workbooks in Excel 2016
- Use Links and External References
- Use 3-D References
- Consolidate Data
- Use Lookup Functions
- Trace Cells
- Watch and Evaluate Formulas
- Collaborate on a Workbook
- Protect Worksheets and Workbooks
- Apply Data Validation
- Search for Invalid Data and Formulas with Errors
- Work with Macros
- Create Sparklines
- Map Data
- Determine Potential Outcomes Using Data Tables
- Determine Potential Outcomes Using Scenarios
- Use the Goal Seek Feature
- Forecasting Data Trends
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.
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.