Microsoft Office Excel - Intermediate
Classroom based course including manual and Certificate of Attendance
Taylor Mason
Summary
We accept payments by cheque, PayPal or Bank Transfer. Payment must be made in advance of the...
- Certificate of completion - Free
Overview
This course is for individuals with a good basic understanding of Microsoft Excel already who wish to make more of the advanced functionality offered but the software.
Description
This course is for individuals with a good basic understanding of Microsoft Excel already who wish to make more of the advanced functionality offered but the software.
The workshop will cover the following:
MODULE 1: Advanced File Tasks Learning outcomes: A look at some important administrative features which are useful for managing and controlling Excel files.Topics covered:
- Saving and File Management
- Converting and Encrypting Files
- File Properties and Digital Signatures
- File Accessibility and Compatibility
MODULE 2: Working with Functions and Formulas Learning outcomes: Some key formulas and functions essential to Excel users along with features to help manage formulas, functions and ranges.Topics covered:
- Formulas with Absolute References
- Autosum Functions (SUM & AVERAGE)
- IF and Nested Functions
- Working with Named Ranges
- Array Functions (SUMIF & AVERAGEIF)
- Formula Auditing
- Text Functions
MODULE 3: Managing Tables in Microsoft Excel Learning outcomes: Managing spreadsheet data in table format, an excellent feature to administrate large sets of data.Topics covered:
- Creating Excel Tables
- Working with Records and Filters
- Advanced Filters
MODULE 4: Data Tools in Excel Learning outcomes: Features to help with managing spreadsheet data making it a less daunting and repetitive task to manage the data.Topics covered:
- Text to Columns
- Flash Fill
- Remove Duplicates
- Data Validation
- Consolidate
MODULE 5: Doing More with Charts in Excel Learning outcomes: Developing your ability to effectively create charts and format them specific to the reader Topics covered:
- Trendlines
- Error Bars
- Working with Axis Options
- Advanced Chart Formatting
MODULE 6: Sparklines Learning outcomes: Use Sparklines to help analyse data by creating small customisable charts within cells. Edit and format the Sparklines and data points to help your data standout Topics covered:
- Creating Sparklines
- Editing Sparklines
We have public courses run across the country, please request further details regarding dates and availablity in your area.
PLEASE NOTE WE ALSO OFFER THIS CLASS IN HOUSE FOR UP TO TWELVE DELEGATES AT A COST OF £949.00 PLUS TRAVEL. PLEASE ENQUIRE FOR FURTHER DETAILS
Who is this course for?
Those with a basic knowledge of Excel wishing to progress to a higher level.
Questions and answers
Certificates
Certificate of completion
Digital certificate - Included
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.