Our Intermediate Excel Course is designed to improve your confidence and efficiency in using Excel. This is a fundamental skill for many careers; it is vital for finance, accounts, or bookkeeping jobs. However, many Admin, PA, sales staff and other roles now require at least intermediate-level skills in Excel. Many employers will test their new employees on Excel skills and will not hire staff who fail to demonstrate Excel skills.
Intermediate Excel Course
To enable students to gain intermediate-level skills in Excel. Our training centre is a Microsoft Office Academy, ensuring we deliver all training to the highest level. The Excel Training Course is also a CPD-accredited course, so CPD Certification is issued to staff on completion of the training.
Course Format
The course is delivered using an interactive online training programme. It uses a virtual tutor within a live server. This is a state-of-the-art learning system. The virtual tutor will instruct you and correct your exercises. This standard of interactive learning will enable you to gain from interactive learning. This is available to you on a flexible basis. You can start any time and study on a schedule that suits your lifestyle.
Course Content
Increase your efficiency in Excel
- Microsoft Excel Help
- Checking spelling, finding and replace
- Inserting/deleting rows, columns and cells
- Moving cells, copying to non-adjacent cells
- Copying cell format quickly, merging cells, orientation of cell content
- Cell styles
- Sorting data
Multiple worksheets and various views
- Sheet name, tab colour, inserting, deleting sheets#
- Sheet background
- Moving, copying, hiding sheets
- Splitting the window, freezing a column/row, hiding elements of a sheet
- Repeating rows/columns on printed pages
More complex Excel Tables, Formulas and Functions
- Merging and Wrapping text
- Absolute reference in a formula
- Copying values, copying with a link, transposing
- Calculating with functions
- Control date, date formats
- Simple conditions
- Custom formats
- Applying, managing conditional formats
- Naming a range of cells
- Validation rules
- Multiple cell ranges and calculations in functions
Charts in Excel to present data
- Creating and managing a chart
- Selecting, adding and removing items in a chart
- Formatting chart items
- Modifying a chart’s text items
- Printing and page layout of a chart
- Sparklines in Charts
- Managing chart options, data series, labels and axes
Visuals in Excel
- Creating a drawing object
- Selecting and deleting objects
- Copying and moving objects
- Resizing a drawing object
- Modifying a text box
- Modifying a drawing
- Formatting drawing objects
- Inserting a picture
- Managing pictures
- Rotating and aligning objects
- Stacking and grouping objects
Database functionality with an Excel table
- Subtotal rows
- Automatic calculations in a table
- Automatic filtering
- Custom filters
- Blank cells and duplicates
- Advanced filtering with a criteria range
- Criteria ranges
- Copying rows filtered using a criteria range
- Statistics with a criteria range
- Flash Fill
Dates and Duration
The course lasts for six months but can be completed earlier. It can be taken online from anywhere. You can start at any time.
Course Requirements
You must have the complete set of skills covered in the Beginner Excel Course.
Course Benefits
- Training is written by senior Microsoft Trainers from a Microsoft Certified Academy, so the content has been certified to the highest standards.
- Interactive training from a live server with a Virtual Tutor enables learners to receive instruction as if they have a personal tutor.
- CPD Accredited Excel Course with a CPD Certificate of Excel Proficiency issued on successful completion
- The training is efficient, with numerous exercises to ensure you remember these details.
- Professionally accredited qualifications will build your C.V
