Embark on a comprehensive 4-hour tutorial designed to elevate your Excel 365 skills from beginner to proficient. Navigate the Excel 365 Online Portal, master the interface, and learn essential features like the Quick Access Toolbar and keyboard shortcuts. Explore workbook and worksheet management, data entry techniques, and custom lists. Dive into formula creation, understanding the 'Big 6' functions, and grasping absolute vs. relative referencing. Discover time-saving tools such as Autosum, Autofill, and Flash Fill. Learn to create and utilize named ranges, apply various formatting techniques, and work efficiently with tables. Master column and row manipulation, text alignment, and apply professional themes and styles. With hands-on exercises throughout, gain practical experience to boost your spreadsheet proficiency and streamline your workflow in Excel 365.
Overview
Syllabus
- Intro Simon Sez IT
- Course Introduction
- Excel 365 Online Portal
- Exercise 01
- Launch Excel
- Explore the Interface
- Contextual Menus and Ribbons
- The Quick Access Toolbar
- Keyboard Shortcuts
- Exercise 02
- Excel Templates
- Work with Workbooks and Worksheets
- Save Workbooks to OneDrive
- Enter Text, Numbers, and Dates
- Custom Lists
- Exercise 03
- Order of Operations
- A Simple Formula
- The 'Big 6' Functions
- Absolute vs Relative Referencing
- Quick Calculations with Autosum
- Autofill and Flash Fill
- Exercise 04
- What are Names Ranges?
- Create Named Ranges
- Use Named Ranges in Formulas
- Exercise 05
- Apply Number Formats
- Format Cells, Rows and Columns
- AutoFormat
- Find and Replace Formatting
- Format Painter
- Clear Cells
- Exercise 06
- Tables Explained
- Format as Table
- Table Reference in Formulas
- Exercise 07
- Work with Columns and Rows
- Align Text and Numbers
- Merge Cells vs Center Across Selection
- Apply Themes and Styles
- Exercise 08
Taught by
Simon Sez IT
