Microsoft Excel Fundamental Course
A Practical Workshop for Beginners
Office Productivity,Microsoft,Excel
Lectures -51
Resources -8
Duration -1.5 hours
Lifetime Access

Lifetime Access
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
Get up to the challenge with Microsoft Excel and become one step closer to mastery. Designed for absolute beginners, this course removes the mystery surrounding the program of Microsoft Excel, allowing you to make it enjoyable and accessible for even basic spreadsheets through the complexities of data analysis and making sure you get enough skills under your belt so that you feel comfortable handling and working in Excel.
Begin Excel Basics Uncovered: Intro to An easy-to-read introduction to the Excel environment. How to navigate the easy features and tools necessary for any Excel user.
Step-by-Step Building the First Spreadsheet: Organized data with basic operations creation.
Formatting for Clarity Impact: The secrets of how to make your data clear and visually appealing, and formatted.
Introduction to Formulas and Functions: Master Excel's core formulas and functions. Begin transforming raw data into meaningful information.
Charting and Visualisation Basics: Learn to create simple charts and graphs. Get a picture sense so that you can better absorb and present information.
Pivot Tables and Basic Data Analysis Tools: Learn about Pivot Tables, basic data analysis tools, Goal Seek, and Scenario Manager, amongst other features.
Learn through our course by a series of 'bite-sized lectures' by your instructor, Kevin. Every lecture is carefully prepared to really drive home what you're learning and make it easy to apply. That's how you digest the essentials of Excel in bite-sized format.
Throughout this course, lectures complement hands-on exercises, quizzes, and assignments to drive the reinforcement of your own learning. You will practically apply what you learned through lectures to enable you to buttress your newly acquired abilities. It is in practical application that you will have much more than merely learn a set of techniques on Microsoft Excel; you will even know how to use such techniques appropriately.
Any other topics you would like to hear more about or specific Excel topics of particular interest? Additional lectures will be added to help meet your needs. Your feedback and questions are both welcome and encouraged; they enable me to tailor the course better in order to meet your needs.
Goals
Learn the basics of Microsoft Excel.
Enter and format data.
Functions and Formulas.
Visualise Data using Charts.
Printing and Reporting.
Analyse data with Scenario Manager and Goal Seek.
Learn the Basics of Pivot Tables.
Data Validation.
Macros & Automation.
Prerequisites
Access to a Computer with Microsoft Excel installed. Ideally, Microsoft 365 is required to follow along with the lectures, but any version is acceptable.
A willingness to learn.
No previous experience required.
Curriculum
Check out the detailed breakdown of what’s inside the course
Introduction
7 Lectures
-
Introduction 01:15 01:15
-
What is a Spreadsheet? 02:37 02:37
-
Titlebar & Quick Access Toolbar 01:53 01:53
-
The Ribbon 03:32 03:32
-
Formula Bar 01:39 01:39
-
Workbooks & Worksheets 01:31 01:31
-
Status Bar 02:34 02:34
Building Spreadsheets
22 Lectures
Saving, Printing & Exporting Workbooks
6 Lectures
Creating Charts
4 Lectures
Data Validation
3 Lectures
Data Analysis
7 Lectures
Macros & Automation
2 Lectures
Instructor Details
Kevin Wilson
Kevin Wilson is a computer technology specialist with over twenty years of experience in the IT industry, and a degree in Computer Science. His work spans a wide range of disciplines, including software development, systems architecture, and network infrastructure, alongside creative fields such as web design, digital media, and video production.
He also has extensive experience in building and managing computer systems, developing corporate networks, and delivering technical support, giving him a comprehensive, understanding of modern computing environments.
Kevin is the Senior Writer and Director at Elluminet Press Ltd, where he has authored multiple technology publications used by home users, students, and professionals worldwide. His teaching experience as an instructor further reflects his ability to translate complex technical concepts into structured, accessible learning.
His work is widely used by learners across England, South Africa, Canada, and the United States. In addition to writing, he contributes as a technical reviewer and consultant for a range of computer publications and educational resources.
He is the creator of the Exploring Tech Series, guided by the principle: “If you can't explain something simply, you haven't understood it well enough.” This philosophy underpins his approach to breaking down complex topics into clear, structured steps suitable for learners at all levels.
Alongside his publishing work, Kevin and his team founded Kuleos Labs Ltd, where they develop professional video-based training courses that combine clear technical instruction with high-quality visual production. These courses cover a range of subjects, including computer hardware, Microsoft Office, Python programming, and web development.
Course Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now