Microsoft Excel Course for Beginners

Embark on a comprehensive 4-hour Excel tutorial designed for beginners. Learn the fundamentals of Microsoft Excel, from basic concepts to practical applications. Discover how to navigate the interface, work with cells, worksheets, and workbooks, and utilize the Ribbon toolbar effectively. Master essential skills such as data entry, formatting, and cell manipulation. Explore formula creation, understand relative and absolute addressing, and delve into functions like MOD. Practice your newfound knowledge with hands-on exercises, including creating a Times Table Square and introducing the Battleships game. By the end of this tutorial, gain the confidence to develop diverse Excel solutions and apply your skills to real-world scenarios.

Welcome
What is Microsoft Excel?
How do I get Microsoft Excel?
How do I open Microsoft Excel?
Cell, Worksheets and Workbooks
The Ribbon Toolbar
Selecting Cells and The Name Box
Altering Rows and Columns
Borders
Revision: Times Table Square
Exploring Data Types
Formatting Data
Creating a Series
Creating Formulae
Formulae and Autofill Relative Addressing
Resolving Relative Addressing Issues Absolute Addressing
Formatting Cells
Times Table Square
Protecting Worksheets
Restricting Data in Cells
Creating Lists
Adding and Deleting Rows and Columns
Conditional Formatting
Introducing Functions - MOD
Revision: Times Table Square
Introducing Battleships