Have you ever opened Microsoft Excel and felt completely overwhelmed or unsure where to even begin? You're not alone, and that's exactly why this course was created. Designed for complete beginners, it takes you step by step through everything you need to know to become confident and capable in Excel, even if you’ve never used it before.
You’ll start by getting familiar with the Excel interface, learning what each part of the screen does, how to navigate between sheets, and how to move around your data efficiently. From there, you'll learn how to enter and manage different types of data, understand the difference between text, numbers, and formulas, and set up your spreadsheets in a way that keeps them organised and easy to read. You’ll also master essential formatting skills, such as adjusting column widths, changing fonts and colours, applying borders, and using cell styles to make your spreadsheets look clean and professional. Learning how to format your data properly can make a huge difference, especially when you're preparing information for work, school, or sharing with others. Sorting and filtering tools will help you make sense of large sets of data, letting you find what you need quickly and work more efficiently. Whether you're managing a budget, tracking inventory, creating a schedule, or analysing a list of tasks, Excel gives you the flexibility to do it all in one place.
One of the most powerful aspects of Excel is its ability to perform calculations for you. In this course, you’ll learn to use key formulas and functions such as SUM, AVERAGE, MIN, MAX, COUNT, and IF. We’ll explain what each one does, when to use it, and how to apply it correctly so you can save time and avoid mistakes. As you build confidence, you’ll also learn how to create charts and graphs that bring your data to life. From simple bar charts to line graphs and pie charts, you’ll discover how to present your information visually, so it’s easier to understand and more impactful to share.
This course was reviewed and approved by qualified subject matter expert Emmanuel Oberabor, a Data Analyst. For more information on our subject matter expert, visit https://www.linkedin.com/in/emmanuel-oberabor-a866a2226/.
The authors generated this text in part with GPT-4o, OpenAI’s large-scale language-generation model. Upon generating draft language, the authors and subject matter experts reviewed, edited, and revised the text to ensure it reflected accurate expertise and met high pedagogical standards.
Want a beginner-friendly Microsoft Excel training that starts from scratch? No experience needed, just the drive to master Excel and improve your skills. Enrol now and start your journey to Excel excellence!
All Alison courses are free to enrol study and complete. To successfully complete this course and become an Alison Graduate, you need to achieve 80% or higher in each course assessment. Once you have completed this course, you have the option to acquire an official , which is a great way to share your achievement with the world.
Your Alison is:
- Ideal for sharing with potential employers
- Great for your CV, professional social media profiles and job applications.
- An indication of your commitment to continuously learn, upskill & achieve high results.
- An incentive for you to continue empowering yourself through lifelong learning.
Alison offers 3 types of s for completed courses:
- Digital : a downloadable in PDF format immediately available to you when you complete your purchase.
- : a physical version of your officially branded and security-marked
All s are available to purchase through the Alison Shop. For more information on purchasing Alison , please visit our FAQs. If you decide not to purchase your Alison , you can still demonstrate your achievement by sharing your Learner Record or Learner Achievement Verification, both of which are accessible from your Account Settings.