Microsoft Excel Fundamentals

Focused View

Kevin Wilson

1:44:12

18 View

1. Introduction

1. Introduction.mp4

01:15

2. What is a Spreadsheet.mp4

02:37

3. Home Screen, New and Open.mp4

02:35

4. Titlebar & Quick Access Toolbar.mp4

01:53

5. The Ribbon.mp4

03:32

6. Formula Bar.mp4

01:39

7. Workbooks & Worksheets.mp4

01:31

8. Status Bar.mp4

02:34

9. Summary.html

2. Building Spreadsheets

1. Introduction.mp4

00:27

2. Entering Data.mp4

02:46

3. Number Formats.mp4

02:35

4. Using Functions & Formulas.mp4

03:20

5.1 assignment 01.pdf

5. Assignment 1.mp4

00:34

6. Average Function.mp4

01:38

7. CountIF Function.mp4

01:39

8. Count Function.mp4

01:21

9.1 assignment 02.pdf

9. Assignment 2.mp4

00:34

10. VLookup Function.mp4

02:28

11.1 assignment 03.pdf

11. Assignment 3.mp4

00:34

12. Date & Time Functions.mp4

03:41

13. Relative, Absolute & Mixed Cell References.mp4

02:23

14. Adding & Deleting Rows & Columns.mp4

01:16

15. Merging Cells.mp4

01:41

16. Cut, Copy, Paste & Paste Special.mp4

03:23

17. Freeze & Split Panes.mp4

03:14

18. Sorting Data.mp4

02:35

19. Filtering Data.mp4

01:18

20. Introduction to Cell Borders & Shading.mp4

02:45

21. Introduction to Conditional Formatting.mp4

01:49

22. Introduction to Excel Tables.mp4

02:00

23. Table Design Ribbon Tab.mp4

01:34

24. Summary.html

3. Saving, Printing & Exporting Workbooks

1. Introduction.mp4

00:14

2. Saving Workbooks.mp4

02:09

3. Opening Workbooks.mp4

00:53

4. Preparing a Worksheet for Printing.mp4

02:54

5. Page Margins.mp4

00:51

6. Print Selection.mp4

00:48

7. Exporting Workbooks.mp4

00:52

8. Summary.html

4. Creating Charts

1. Introduction.mp4

00:17

2. Types of Chart.mp4

00:46

3. Inserting a Chart.mp4

01:00

4. Customizing a Chart.mp4

04:03

5.1 Assignment 04.pdf

5. Assignment 4.mp4

00:34

6. Summary.html

5. Data Validation

1. Introduction.mp4

00:17

2. Introduction to Data Validation Rules.mp4

01:14

3. Adding Validation Rules.mp4

02:26

4.1 Assignment 05.pdf

4. Assignment 5.mp4

00:34

5. Summary.html

6. Data Analysis

1. Introduction.mp4

00:18

2. Introduction to Basic Data Analysis.mp4

01:32

3. Goal Seek.mp4

02:21

4.1 Assignment 06.pdf

4. Assignment 6.mp4

00:34

5. Scenario Manager.mp4

03:13

6.1 Assignment 07.pdf

6. Assignment 7.mp4

00:34

7. Introduction to Pivot Tables.mp4

02:57

8.1 Assignment 08.pdf

8. Assignment 8.mp4

00:34

9. Summary.html

7. Sharing & Collaboration

1. Introduction.mp4

01:06

2. Sharing a Workbook.mp4

01:53

3. Summary.html

8. Macros & Automation

1. Introduction.mp4

00:40

2. Recording a Macro.mp4

01:53

3. Executing a Recorded Macro.mp4

00:41

4. Summary.html

9. Summary & Next Steps

1. Wrap up & Summary.mp4

02:10

2.1 Additional Excel Tips.html

2.2 Using Excel Textbook.html

2. Bonus Lecture.mp4

00:43

Description

A Practical Workshop for Beginners

What You'll Learn?

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
Macros & Automation

Who is this for?

Beginners

New Office Workers or Students

Anyone that wants to learn how to build spreadsheets and analyse data with Microsoft Excel

What You Need to Know?

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

No previous experience required

More details

Description
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.
If there's anything you'd like to know more about or any particular areas of Excel you're interested in exploring, please send me a message to let me know. I will add additional lectures to meet your learning needs. Your feedback and questions are not only welcome but encouraged, as they help me tailor the course to better suit your needs.
Who this course is for:
Beginners
New Office Workers or Students
Anyone that wants to learn how to build spreadsheets and analyse data with Microsoft Excel

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Kevin Wilson

Instructor's 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.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.