✅Download the free demo file and follow along here ➡https://www.simonsezit.com/excel365...
Welcome to our comprehensive Excel 365 tutorial! In this video, we'll guide you through a detailed exploration of essential Excel features to boost your spreadsheet skills. We'll start with navigating the Excel 365 Online Portal, ensuring you can access your work from anywhere. Learn the basics of launching Excel and efficiently exploring the interface, including contextual menus and ribbons.
Discover the power of the Quick Access Toolbar and essential keyboard shortcuts for a seamless workflow. Dive into Excel templates to kickstart your projects, and efficiently work with workbooks and worksheets. We'll show you how to save your work to OneDrive, ensuring collaboration is a breeze.
From entering text, numbers, and dates to understanding custom lists and the order of operations, we've got you covered. Explore the fundamentals of formulas, including the 'Big 6' functions, and grasp the concepts of absolute vs. relative referencing. Streamline your calculations with quick tools like Autosum, Autofill, and Flash Fill.
Uncover the benefits of named ranges, from creation to application in formulas. Enhance your data presentation with various number formats and formatting techniques for cells, rows, and columns. Learn the ins and outs of tables, including formatting as a table and referencing within formulas. Efficiently work with columns and rows while mastering text and number alignment.
We'll demystify merging cells vs. centering across selections and explore the application of themes and styles for a polished spreadsheet appearance. Subscribe, like, and share if you're ready to excel in Excel! Stay tuned for more tutorials to elevate your skills. Happy learning!
Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead! Timestamps:
00:00:00 Intro Simon Sez IT
00:00:20 Course Introduction
00:03:59 Excel 365 Online Portal
00:11:07 Exercise 01
00:12:07 Launch Excel
00:15:59 Explore the Interface
00:25:51 Contextual Menus and Ribbons
00:30:31 The Quick Access Toolbar
00:37:42 Keyboard Shortcuts
00:45:40 Exercise 02
00:49:41 Excel Templates
00:56:20 Work with Workbooks and Worksheets
01:03:01 Save Workbooks to OneDrive
01:07:49 Enter Text, Numbers, and Dates
01:14:57 Custom Lists
01:21:27 Exercise 03
01:25:29 Order of Operations
01:32:26 A Simple Formula
01:38:59 The 'Big 6' Functions
01:45:28 Absolute vs Relative Referencing
01:52:55 Quick Calculations with Autosum
01:58:32 Autofill and Flash Fill
02:09:12 Exercise 04
02:14:00 What are Names Ranges?
02:17:25 Create Named Ranges
02:21:42 Use Named Ranges in Formulas
02:25:10 Exercise 05
02:27:40 Apply Number Formats
02:39:59 Format Cells, Rows and Columns
02:53:10 AutoFormat
02:56:49 Find and Replace Formatting
03:03:23 Format Painter
03:07:59 Clear Cells
03:13:18 Exercise 06
03:17:19 Tables Explained
03:25:10 Format as Table
03:37:38 Table Reference in Formulas
03:42:30 Exercise 07
03:45:13 Work with Columns and Rows
03:54:33 Align Text and Numbers
04:03:30 Merge Cells vs Center Across Selection
04:10:27 Apply Themes and Styles
04:18:48 Exercise 08
✅Download the free demo file and follow along here ➡https://www.simonsezit.com/excel365...
Get unlimited training with Simon Sez IT’s 170+ courses ⏩ https://www.simonsezit.com/courses/
Level up your skills with a free 30day trial to our complete training library of 9,200+ videos ⏩ https://www.simonsezit.com/ssitfirst...
Watch more free popular training tutorials from Simon Sez IT:
Check out our FREE 300+ hour training course playlist here ➡
• Simon Sez IT Long Training Courses
✅ Check out our free video playlist for Data Analysis using Microsoft Tools • Data Analysis using Microsoft Tools
✅Microsoft Access Training video playlist • How to Use Microsoft Access Training ...
✅ Microsoft Excel Beginner's Training here • Microsoft Excel Beginner's Training T...
✅ Introduction to Databases Training here • Introduction to Databases Training Tu...
Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
LinkedIn: / simonsezit
FaceBook: / simonsezit
Subscribe to our channel:
https://www.youtube.com/simonsezittra...
If you enjoyed the video, please give a thumbs up ;)