Tutorialspoint

Celebrating 11 Years of Learning Excellence! Use: TP11

Microsoft Excel Fundamental Course

person icon Kevin Wilson

4.2

Microsoft Excel Fundamental Course

A Practical Workshop for Beginners

updated on icon Updated on Jun, 2025

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.2

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

With an impressive tenure exceeding two decades in the computer industry, Kevin Wilson is a proven authority on computers and technology highlighted by extensive experience, and a master's degree in computer science software engineering. 

His expertise seamlessly extends across a vast array of IT sectors from the artistic arenas of graphic and web design, digital film and photography to the intricate spheres of computer programming and software engineering. His skills also extend to the strategic domains of corporate network development, as well as building computer systems, and IT support.

In his capacity as the Senior Writer and Director at Elluminet Press Ltd, Kevin has penned multiple tech-related books that have found favor among home computer users, students and professionals around the world. His contributions in the classroom as a computer science lecturer and IT trainer further demonstrate his knowledge and continue to help people understand computer technology.

Kevin's work is well respected among students in England, South Africa, Canada, and the United States. Beyond writing, he lends his technical expertise as a reviewer and consultant to many other computer publications and textbooks.

His philosophy, "If you can't explain something simply, then you haven't understood it well enough," is the driving force behind his acclaimed Exploring Tech Series, in which complex technical topics are broken into smaller, comprehensive steps that are easy to understand for both students, professionals, and the average computer user.

In addition to this, along with his team, Kevin has written and produced numerous video training courses using visual effects, computer graphics and clear presentation covering a variety of subjects including computer hardware, Microsoft Office, and Python Computer Programming. 

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