Tutorialspoint

MEGA SKILL MARATHON | FLAT 10% OFF | Use: MEGA10

Microsoft Excel Fundamental Course

person icon Kevin Wilson

4.3

Microsoft Excel Fundamental Course

A Practical Workshop for Beginners

updated on icon Updated on Jan, 2026

language icon Language - English

person icon Kevin Wilson

category icon Office Productivity,Microsoft,Excel

Lectures -51

Resources -8

Duration -1.5 hours

Lifetime Access

4.3

price-loader

Lifetime Access

30-days Money-Back Guarantee

Training 5 or more people ?

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.

Microsoft Excel Fundamental Course

Curriculum

Check out the detailed breakdown of what’s inside the course

Introduction

7 Lectures
  • play icon Introduction 01:15 01:15
  • play icon What is a Spreadsheet? 02:37 02:37
  • play icon Titlebar & Quick Access Toolbar 01:53 01:53
  • play icon The Ribbon 03:32 03:32
  • play icon Formula Bar 01:39 01:39
  • play icon Workbooks & Worksheets 01:31 01:31
  • play icon Status Bar 02:34 02:34

Building Spreadsheets

22 Lectures
Tutorialspoint

Saving, Printing & Exporting Workbooks

6 Lectures
Tutorialspoint

Creating Charts

4 Lectures
Tutorialspoint

Data Validation

3 Lectures
Tutorialspoint

Data Analysis

7 Lectures
Tutorialspoint

Macros & Automation

2 Lectures
Tutorialspoint

Instructor Details

Kevin Wilson

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.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515