Intermediate Excel
Turn unorganised data into useful information and quickly make spreadsheets your friends. The course starts with Excel fundamentals and then moves on to advanced topics like functions, PivotTables, and macros.
Notes:
• All lessons are bite-sized and self-contained, so you can select only what you need.
• Features matching content with Interactive Online Learning and Skills Assessments.
Creating and Working with Charts
- Choosing and selecting the source data
- Choosing the right chart
- Inserting a chart
- Editing, adding and removing chart data
- Changing chart data
- Changing chart layout and style
- Working with chart labels
- Changing the chart gridlines
- Changing the scale
- Emphasizing data
- Using chart templates
- Changing chart type
- Using sparklines
Managing Workbooks
- Using workbook views
- Selecting and switching between worksheets
- Inserting and deleting worksheets
- Renaming, moving and copying worksheets
- Splitting and freezing a window
- Creating headers and footers
- Hiding rows, columns, worksheets and windows
- Setting the print area
- Adjusting page margins and orientation
- Adding print tiles, gridlines and row and column headings
- Adjusting paper size and print scale
- Printing a selection, multiple worksheets and workbooks
- Working with multiple workbook windows
- Creating a template
- Protecting a workbook
- Protecting worksheets and worksheet elements
- Sharing a workbook
More Functions and Formulas
- Formulas with multiple operators
- Inserting and editing a function
- AutoCalculate and manual calculation
- Defining names
- Using and managing defined names
- Displaying and tracking formulas
- Understadnding formula errors
- Using logical functions (IF)
- Using financial functions (PMT)
- Using database functions (DSUM)
- Using lookup functions (VLOOKUP)
- User defined and compatibility functions
- Financial functions
- Date & time functions
- Math & trig functions
- Statistical functions
- Lookup & reference functions
- Database functions
- Text functions
- Logical functions
- Information functions
- Engineering and cube functions
Working with Data Ranges
- Sorting by one column
- Sorting by colours or icons
- Sorting by multiple columns
- Sorting by a custom list
- Filtering data
- Creating a custom autofilter
- Using an advanced filter
Working with Tables
- Creating a table
- Adding and removing data
- Working with the total row
- Sorting a table
- Filtering a table
- Removing duplicate rows of data
- Formatting the table
- Using data validation
- Summarising a table with a pivottable
- Converting to a range
0.00 average based on 0 ratings
Related Courses

Duration: 10 week
£295.00
Duration: 1 day
£295.00
Duration: 2 day
£750.00Advanced Communication Skills for Managers
You tend to find the issue between mangers and their team is a lack of communication, usually staff will feel their managers haven’t communicated with them effectively which can create…
Details
Duration: 1 day
£325.00Project Management Training Course
No matter who you are or what you do, whether at work or in the community, you are more than likely to be involved in managing projects at some stage.
Details
Duration: 2 day
£750.00Leading High Performing Teams
If your role requires you to lead and manage high performing teams to achieve company objectives, targets and goals, we offer a two day leadership programme.
Details
Duration: 2 day
£695.00Leadership and Management Course – 2 Days
This 2 day Essential Leadership Skills For Managers course will give managers, supervisors and team leaders the leadership skills and training they probably never received when first promoted.
Details
Duration: 1 day
£325.00Management and Leadership Training Course – 1 Day
Managing others can be one of toughest challenges we face at work.
Details
Duration: 1 day
£325.00Managing Change Course
For many of us the idea of change frightens us, it takes us from our comfort zones and throws us into something completely new, which is scary.
Details
Duration: 2 day
£695.00Managing Performance Course and Staff Appraisals
Managing other peoples performance and their appraisals can be a very difficult task and requires the correct knowledge on how to monitor, motivate and improve your team.
Details
Duration: 1 day
£325.00Finance for Non-Financial Managers Course
Finance is an inescapable part of business, which is why it is so important for businesses of all shapes and sizes to understand how it works.
Details
Duration: 1 day
£295.00Assertiveness at Work Masterclass
We have designed this 1 day Assertiveness Training Masterclass to provide you with the necessary toolkit of skills that will allow you take charge of your work and personal life,…
Details
Duration: 1 day
£295.00Self Esteem and Assertiveness Course
This participatory Developing Self Esteem, Assertiveness and Personal Effectiveness course will provide each learner with the knowledge and skills to understand themselves and others and to learn more about who…
Details
Duration: 1 day
£295.00The Secrets of Effective Time Management
This one-day Secrets of Effective Time Management course is designed to give you the practical skills to tackle common problems that are associated with poor management of time.
Details
Duration: 1 day
£295.00Confident Presentation Skills Course – 1 Day
Delivering a presentation in any environment or situation can be a nerve-racking experience, particularly if it is your first time presenting to a group.
Details
Duration: 2 day
£750.00Delivering Powerful Presentations
If you already have experience in delivering presentations then this 2 day course is ideal for you and will help you to enhance your existing skills to a more professional…
Details
Duration: 2 day
£650.00Train the Trainer Course
This 2 day Train The Trainer “Flagship” programme will give you a vast range of skills, knowledge, techniques and approaches which will ensure you deliver training to your learners in…
Details
Duration: 1 day
£285.00Effective Minute Taking Course
Ask any Minute Taker in any organisation, large or small about problems they face at work when taking down Minutes for either a formal, informal or action planning meeting and…
Details
Duration: 1 day
£285.00Chairing Effective Meetings
Do you spend half of your life attending meetings and consider them to be a complete waste of valuable time?
Details
Duration: 1 day
£295.00Effective Sales Training
This 1 Day Effective Sales Skills Course aims to allow delegates to focus on enhancing your current Sales and Customer Service skills and knowledge.
Details
Duration: 1 day
£295.00
Duration: 2 day
£750.00Delivering Winning Sales Pitches Course
This 2 day sales pitches training course is aimed to provide delegates with a range of skills, tools and techniques to enable you to plan, structure and conduct a variety…
Details
Duration: 2 day
£695.00Influencing, Persuading and Negotiating Skills
Most people are involved with negotiations at some point in their lives, whether this is in a personal context or in a workplace situation.
Details
Duration: 10 week
£325.00
Duration: 10 week
£325.00
Duration: 10 week
£295.00
Duration: 10 week
£225.00
Duration: 10 week
£225.00
Duration: 10 week
£225.00
Duration: 10 week
£225.00
Duration: 10 week
£225.00
Duration: 1 day
£225.00
Duration: 10 week
£175.00
Duration: 1 day
£295.00