Introduction to Microsoft Excel
COURSE
Topic Area
Course Length
6 hoursCourse Level
Course Preview
Audience
Students and graduates
Entry-level professionals
Administrative staff
Anyone new to Excel
Introduction to Excel
Navigate the interface, create workbooks and save files.
Basic Data Entry and Formatting
Enter data, format cells and speed up entry with Autofill and Flash Fill.
Working with Rows, Columns, and Sheets
Add, delete, resize and rearrange rows, columns and worksheets.
Basic Formulas and Functions
Build basic calculations and use SUM, AVERAGE and cell referencing.
Basic Charts and Graphs
Create and format bar, column and pie charts to visualise data.
Course Outline
Learning Outcomes
- Navigate the Microsoft Excel interface, including ribbons, worksheets, and cells
- Create new workbooks and save files in different formats
- Enter and edit text and numerical data efficiently
- Format cells using fonts, alignment, borders, and shading
- Use Autofill and Flash Fill to speed up repetitive data entry
- Add, delete, resize and rearrange rows, columns and worksheets
- Build basic formulas using the four core operations and SUM and AVERAGE functions
- Apply relative and absolute cell referencing
- Create and format basic charts including bar, column and pie charts
Enquire About This Course
Tell us a little about your requirements and we’ll tailor the right solution for you.
Speak to a Training Advisor
Speak directly with a training advisor for quick guidance and recommendations.
Trusted by organisations across the UK and Beyond
Capital Training is an LPI Gold Standard Accredited Learning Provider, recognised for delivering high-quality, impactful training. With over 30 years’ experience, we support organisations across the UK and beyond with trusted, professional development solutions.
Share This Course
Know someone who would benefit from this course? Share it with your network or colleagues.
Access the full course outline
Just a few details and you’ll get instant access to the full course outline — completely free.
Download the full course outline for detailed information on objectives, session content, and learning outcomes.
Enhancing Decision Making Skills in the Workplace
Make faster, clearer, better-judged calls at work. You will leave with practical frameworks to cut through bias, weigh options confidently and justify every decision you make.
Driving Successful Changes
Gain the mindset, confidence and practical tools to lead your team through change — engaging people, overcoming resistance, and embedding new ways of working that last.
Developing a Coaching Approach
Shift from directing to enabling. Learn core coaching skills and models that empower your people to take ownership, solve problems and grow in confidence.
Critical Thinking and Creative Problem Solving
Sharpen how you think — combine structured analysis with creative techniques to tackle complex problems, make confident decisions and generate practical solutions you can apply straight away.
Creative Problem Solving
Master a structured six-step approach to creative problem solving and decision making, giving you the tools and confidence to crack problems quickly and choose the best solution.
Creating Psychologically Safe Working Environments
Learn how to build trust, encourage open communication and create a team culture where people feel safe to speak up, challenge and grow.
Delegation Techniques
Gain the confidence and practical tools to delegate effectively, freeing your time, developing your people and driving stronger team performance and organisational growth.
Stakeholder Management: Influence, Engagement and Control
Develop advanced stakeholder management skills to navigate complex environments, influence without authority, and sustain effective engagement across the full project or change lifecycle.
Stakeholder Management Essentials
Build the skills to identify, analyse, and engage stakeholders effectively, driving better outcomes across projects, change initiatives, and operational delivery.
How to be Assertive
Develop the confidence to communicate clearly, set boundaries, and handle challenging interactions professionally while maintaining empathy and positive relationships.
