• Post category:StudyBullet-16
  • Reading time:8 mins read


A Practical Workshop for Beginners

What you will 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

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.


Get Instant Notification of New Courses on our Telegram channel.


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

English
language

Content

Introduction

Introduction
What is a Spreadsheet?
Home Screen, New and Open
Titlebar & Quick Access Toolbar
The Ribbon
Formula Bar
Workbooks & Worksheets
Status Bar
Summary

Building Spreadsheets

Introduction
Entering Data
Number Formats
Using Functions & Formulas
Assignment 1
Average Function
CountIF Function
Count Function
Assignment 2
VLookup Function
Assignment 3
Date & Time Functions
Relative, Absolute & Mixed Cell References
Adding & Deleting Rows & Columns
Merging Cells
Cut, Copy, Paste & Paste Special
Freeze & Split Panes
Sorting Data
Filtering Data
Introduction to Cell Borders & Shading
Introduction to Conditional Formatting
Introduction to Excel Tables
Table Design Ribbon Tab
Summary

Saving, Printing & Exporting Workbooks

Introduction
Saving Workbooks
Opening Workbooks
Preparing a Worksheet for Printing
Page Margins
Print Selection
Exporting Workbooks
Summary

Creating Charts

Introduction
Types of Chart
Inserting a Chart
Customizing a Chart
Assignment 4
Summary

Data Validation

Introduction
Introduction to Data Validation Rules
Adding Validation Rules
Assignment 5
Summary

Data Analysis

Introduction
Introduction to Basic Data Analysis
Goal Seek
Assignment 6
Scenario Manager
Assignment 7
Introduction to Pivot Tables
Assignment 8
Summary

Sharing & Collaboration

Introduction
Sharing a Workbook
Summary

Macros & Automation

Introduction
Recording a Macro
Executing a Recorded Macro
Summary

Summary & Next Steps

Wrap up & Summary
Bonus Lecture