This beginner-friendly guide will teach you the basics of Microsoft Excel, the powerful spreadsheet application. Learn A-Z in Excel. For beginners in Excel 2013, 2016, 2019, 2021, 2023, Office 365 Excel.
This course is designed for absolute beginners, those who want to start working with Microsoft Excel but have no previous experience. After completing this course, you will be a confident Excel user who will be prepared for situations that occur in real life.
In this course we will cover the following topics:
- Where to get Microsoft Excel?
- Launching Excel
- Main Screen
- Interface
- Backstage Area
- Quick Access Toolbar
- Keyboard Shortcuts
- Templates
- Workbooks and Worksheets
- Saving Workbooks
- Entering and Editing Data
- Navigation and Selection
- Formulas and Functions
- Sum Function
- Count Function
- Average Function
- Min and Max Functions
- Errors
- Absolute and Relative Referencing
- AutoSum and AutoFill
- Flash Fill
- Named Ranges
- Managing Named Ranges
- Using Named Ranges
- Applying Number Formats
- Applying Date and Time Formats
- Formatting Cells, Rows and Columns
- Format Painter
- Working with Rows and Columns
- Working with the Cells
- Alignment
- Theme
Each of these sections will be discussed with examples that allow you to better understand the topic we are discussing. This will give you a solid foundation for understanding Microsoft Excel and learning it further.
What you'll learn:
#excel