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

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