Microsoft Excel Fundamentals 2024

A Practical Workshop for Beginners

Created by : Rated :4.1 644 views

Last Updated: 2024-02-12 06:02:01 English Course Type: Self Learning

Learn the basics of Microsoft Excel
Enter and format data
Learn to use Functions and Formulas
Visualise Data using Charts
Printing and Reporting
Analyse data with Scenario Manage and Goal Seek
Learn the Basics of Pivot Tables
Data Validation

Embark on your journey to Excel proficiency with our "Microsoft Excel Fundamentals for Beginners" course. Tailored specifically for beginners, this course demystifies Excel, making it accessible and engaging. From the basics of spreadsheet creation to the intricacies of data analysis, you’ll acquire the skills needed to navigate and utilize Excel with confidence.

What You'll Learn:

Excel Basics Uncovered: Start with an easy-to-follow introduction to the Excel interface. Learn how to navigate through the basic features and tools essential for any Excel user.
Creating Your First Spreadsheet: Step-by-step guidance on building your first spreadsheet. Learn how to organize data effectively and perform basic operations.
Formatting for Clarity and Impact: Discover the secrets of text formatting to make your data clear and visually appealing.
Introduction to Formulas and Functions: Gain a solid understanding of Excel's core formulas and functions. Start transforming raw data into insightful information.
Charting and Visualization Basics: Learn how to create basic charts and graphs. Visualize your data for better understanding and presentation.
Exploring Pivot Tables and Basic Data Analysis Tools: Get started with Pivot Tables, simple data analysis tools, and other features like Goal Seek and Scenario Manager.

Experience a hands-on learning journey with our course, featuring a series of bite-sized lectures and demonstrations led by Kevin, your instructor. Each lecture is meticulously crafted to enhance your understanding and foster practical application. This approach ensures you grasp the essentials of Excel in an easily digestible format.

Complementing these lectures, our course offers hands-on exercises, quizzes and assignments designed to reinforce your learning. You'll get to practice what you've learned in the lectures, allowing you to solidify your newfound skills. This practical approach is key to ensuring that you don't just learn Excel techniques but also become proficient in applying them effectively.

To reinforce your learning, we recommend using the textbook “Using Microsoft Excel – 2023 Edition” along with the course for additional information and practice you can do on your own. Link here.

If there's anything you'd like to know more about or any particular areas of Excel you're interested in exploring, please let me know. This course is designed to be dynamic and responsive to your needs and interests. Your feedback and questions are not only welcome but encouraged, as they help us tailor the course to better suit your needs.

Access to a Computer with Microsoft Excel installed. Ideally Microsoft 365 to follow along with the lectures, but any version is acceptable
A willingness to learn

Beginners
New Office Workers or Students
Anyone that wants to learn how to build spreadsheets and analyse data with Microsoft Excel

Section 1 : Introduction 9 Lectures 00:15:07
Lecture 1 :
Introduction Preview
Lecture 2 :
What is a Spreadsheet?
Lecture 3 :
Home Screen, New and Open
Lecture 4 :
Titlebar & Quick Access Toolbar
Lecture 5 :
The Ribbon
Lecture 6 :
Formula Bar
Lecture 7 :
Status Bar
Lecture 8 :
Summary
Summary Quiz
Lecture 9 :
Workbooks & Worksheets
Section 2 : Building Spreadsheets 24 Lectures 00:37:29
Lecture 1 :
Introduction
Lecture 2 :
Entering Data
Lecture 3 :
Number Formats
Lecture 4 :
Using Functions & Formulas
Lecture 5 :
Assignment 1
Lecture 6 :
Average Function
Lecture 7 :
CountIF Function
Lecture 8 :
Assignment 2
Lecture 9 :
VLookup Function
Lecture 10 :
Assignment 3
Lecture 11 :
Date & Time Functions
Lecture 12 :
Relative, Absolute & Mixed Cell References
Lecture 13 :
Count Function
Lecture 14 :
Adding & Deleting Rows & Columns
Lecture 15 :
Merging Cells
Lecture 16 :
Cut, Copy, Paste & Paste Special
Lecture 17 :
Freeze & Split Panes
Lecture 18 :
Sorting Data
Lecture 19 :
Filtering Data
Lecture 20 :
Introduction to Cell Borders & Shading
Lecture 21 :
Introduction to Conditional Formatting
Lecture 22 :
Introduction to Excel Tables
Lecture 23 :
Table Design Ribbon Tab
Lecture 24 :
Summary
Building Spreadsheets Summary
Section 3 : Saving, Printing & Exporting Workbooks 8 Lectures 00:04:56
Lecture 1 :
Introduction
Lecture 2 :
Saving Workbooks
Lecture 3 :
Opening Workbooks
Lecture 4 :
Preparing a Worksheet for Printing
Lecture 5 :
Page Margins
Lecture 6 :
Print Selection
Lecture 7 :
Exporting Workbooks
Lecture 8 :
Summary
Saving, Printing & Exporting Workbooks
Section 4 : Creating Charts 6 Lectures 00:02:39
Lecture 1 :
Introduction
Lecture 2 :
Types of Chart
Lecture 3 :
Inserting a Chart
Lecture 4 :
Customizing a Chart
Lecture 5 :
Assignment 4
Lecture 6 :
Summary
Creating Charts Summary
Section 5 : Data Validation 5 Lectures 00:03:20
Lecture 1 :
Introduction
Lecture 2 :
Introduction to Data Validation Rules
Lecture 3 :
Adding Validation Rules
Lecture 4 :
Assignment 5
Lecture 5 :
Summary
Data Validation Summary
Section 6 : Data Analysis 9 Lectures 00:08:39
Lecture 1 :
Introduction
Lecture 2 :
Introduction to Basic Data Analysis
Lecture 3 :
Goal Seek
Lecture 4 :
Assignment 6
Lecture 5 :
Scenario Manager
Lecture 6 :
Assignment 7
Lecture 7 :
Introduction to Pivot Tables
Lecture 8 :
Assignment 8
Lecture 9 :
Summary
Data Analysis Summary
Section 7 : Sharing & Collaboration 2 Lectures 00:03:02
Lecture 1 :
Introduction
Lecture 2 :
Sharing a Workbook
Section 8 : Macros & Automation 3 Lectures 00:03:17
Lecture 1 :
Introduction
Lecture 2 :
Recording a Macro
Lecture 3 :
Executing a Recorded Macro
Section 9 : Summary & Next Steps 2 Lectures 00:02:54
Lecture 1 :
Wrap up & Summary
Lecture 2 :
Bonus

How do i access the course after purchase?
It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time.
Are these video based online self-learning courses?
Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic.
Can i play & pause the course as per my convenience?
Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on.
How do i contact the instructor for any doubts or questions?
Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want.
Do i need a pc to access the course or can i do it on mobile & tablet as well?
Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly.
Do i get any certificate for the courses?
Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion.
For how long can i access my course on the platform?
You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions.
Is there any free trial?
Currently, we do not offer any free trial.
Can i cancel anytime?
Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?

Kevin Wilson,

644 Course Views

1 Courses

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.