✅ Download and complete your free course exercise file here
➡️[ Ссылка ]
In this Excel 2021 Beginner Course, you will build a solid foundation in Excel that you can use in a job or school. We'll go over the difference between Excel 2021 and Excel 365 and then start exploring the Excel interface. We will also discuss Excel 2021 new features, basic formulas and functions, formatting options, applying themes, and more! Once finished, you will have a solid foundation for using Excel 2021/365, as part of the Office 2021 suite of applications.
We've even included downloadable exercise and instructor files from our paid-for course which means you can complete the exercises in this Microsoft Excel 2021 Tutorial and put what you are learning into practice. This will help you master the various Excel tips and tricks taught.
We've even included a free downloadable exercise file so you can follow along in this QuickBooks 2022 Tutorial
✅[ Ссылка ]
📝Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!
0:00:00 - Introduction
0:00:22 - Course Intro
0:02:42 - Excel 2021 vs Excel 365
0:08:21 - Launching Excel
0:12:00 - The Start Screen
0:22:12 - Exploring the Interface
0:33:51 - Ribbons, Tabs and Menus
0:42:20 - Backstage Area
0:47:00 - Quick Access Toolbar
0:56:45 - Useful Keyboard Shortcuts
1:06:27 - Getting Help
1:13:04 - Exercise 01
1:15:27 - Working with Templates
1:24:30 - Workbooks and Worksheets
1:32:04 - Saving Workbooks
1:40:50 - Entering and Editing Data
1:50:43 - Navigating and Selecting Cells, Rows, and Columns
1:58:02 - Exercise 02
2:03:22 - Formulas and Functions Explained
2:15:06 - SUM Function
2:22:44 - COUNT Function
2:30:10 - AVERAGE Function
2:34:27 - MIN and MAX Function
2:36:52 - Handling Errors in Calculations
2:45:34 - Absolute vs Relative Referencing
2:52:29 - Autosum and Autofill Options
3:02:12 - Flash Fill
3:07:15 - Exercise 03
3:12:26 - What are Named Ranges
3:21:33 - Managing Named Ranges
3:25:22 - Using Named Ranges
3:30:42 - Exercise 04
3:35:00 - Applying Number Formats
3:45:03 - Applying Date and Time Formats
3:50:41 - Formatting Cells, Rows and Columns
3:59:20 - Format Painter
4:04:00 - Exercise 05
4:08:11 - Working with Rows and Columns
4:16:36 - Deleting and Clearing Cells
4:23:02 - Aligning Text and Numbers
4:34:15 - Applying Themes and Styles
🌍 Get unlimited training with Simon Sez IT’s 150+ courses ⏩ [ Ссылка ]
🚀 Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ [ Ссылка ]
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 300+ hour training course playlist here ➡️
[ Ссылка ]
✅ Check out our free video playlist for Excel beginners 👉[ Ссылка ]
✅ Excel 2021 Tutorials for Intermediate Users here 👉[ Ссылка ]
✅ Microsoft Excel Tips and Tricks 👉[ Ссылка ]
✅ Microsoft Office 2021 and Office 365 Training here 👉[ Ссылка ]
💬Stay in touch!
SimonSezIT.com: [ Ссылка ]
LinkedIn: [ Ссылка ]
FaceBook: [ Ссылка ]
🔔 Subscribe to our channel:
[ Ссылка ]
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
Ещё видео!