Learn the Essentials of Microsoft Excel 2019/365
This 7-hour Microsoft Excel 2019 course is perfect for those brand new to Excel and who are using Excel 2019 or Excel 365 editions.
Simon Sez IT – Microsoft Excel 2019 – Beginners Course
In this course, your expert author gives you a solid grounding in the basics of Excel and guides you towards becoming more confident with spreadsheets.
What You’ll Learn
- What’s new in Excel 2019
- Creating workbooks
- Entering text, numbers and working with dates
- Navigating workbooks
- Page setup and print options
- Working with rows, columns and cells
- Cut, Copy and Paste
- Introduction to Functions and Formulas
- Formatting in Excel, including formatting cells and numbers
- Creating charts and graphs
- Sorting and Filtering
- Introduction to PivotTables
- Logical and lookup formulas – the basics
Course Format
- This is a video-led course. You can preview some videos below.
- This course includes practice exercises so you can practice as you learn.
- This course is suitable for Windows users.
- Course suitable for Office 365 Users
Why Trust Us?
Stream Skill is part of the Simon Sez IT family and has been in business 10+ years and taught over 400,000 students in that time. We’ve created over 90 software training courses, 5,000+ video tutorials, and we’ve helped thousands of people across around the world learn how to use Microsoft Excel. We’ve now created 10+ Microsoft Excel courses and continue to help people get to grips with spreadsheets.
Course Curriculum
- Intro to Excel (1:00)
- What’s New In Excel 2019 (7:52)
- Course Overview (1:16)
- Overview of the Excel window (8:25)
- Mouse-Features (3:12)
- Back Stage View (2:37)
- Course Exercise Files
- Entering Text and Numbers (4:31)
- Creating Basic Formulas (6:49)
- Relative References (3:01)
- Order of Operations (4:48)
- Working with Ranges (4:14)
- Module 2 – Practice Exercise (1:35)
- Working with the Save and Save As Commands (4:34)
- File Extensions, Share, Export and Publish Files (3:44)
- Module 3 – Practice Exercise (0:58)
- Opening a File (5:32)
- Working with Larger Files (5:34)
- Freeze Panes Option (3:16)
- Split Screen Option (3:21)
- Module 4 – Practice Exercise (2:49)
- Print Titles (2:52)
- Headers and Footers (7:23)
- Comments (5:23)
- Page Setup Options (7:29)
- Fit to Print on One Page (3:58)
- Printing Workbooks (3:55)
- Module 5 – Practice Exercise (1:53)
- Adding and deleting rows columns and cells (6:12)
- Changing Column and-Row Widths (3:45)
- Module 6 – Practice Exercise (1:11)
- Cut Copy and Paste (7:07)
- Module 7 – Practice Exercise (1:20)
- Copying Formulas (5:09)
- Overview of Formulas (2:47)
- Create Formulas Using Functions Part 1 (10:03)
- Create Formulas Using Functions Part 2 (5:24)
- Absolute Values (5:16)
- Module 8 – Practice Exercise (1:20)
- Adding Deleting and Renaming Sheets (4:09)
- Additional Sheet Tab Options (5:19)
- 3 Dimensional Formulas (5:28)
- Module 9 – Practice Exercise (1:31)
- Formatting Cells part 1 (10:04)
- Formatting Cells Part 2 (3:38)
- Formatting Numbers (9:24)
- Borders and Shading (7:08)
- Format as Table (6:07)
- Using Styles (3:49)
- Using Format Painter (4:29)
- Protecting Sheets (9:00)
- Fill Handle and Custom Lists (7:17)
- Module 10 – Practice Exercise (1:10)
- Creating Charts (9:48)
- Types of Charts (5:58)
- Editing Charts Part 1 (11:00)
- Editing Charts Part 2 (3:12)
- Using Graphics to Enhance Charts (5:05)
- Linking Chart Titles (2:47)
- Module 11 – Practice Exercise (0:53)
- Creating Range Names (7:45)
- Managing Names (3:17)
- Using Names in Formulas (5:58)
- Module 12 – Practice Exercise (1:20)
- Remove Duplicates (7:45)
- Sort Data (10:28)
- Filter Data (7:38)
- Advanced Filters (4:46)
- Module 13 – Practice Exercise (0:57)
- Creating an Outline (6:01)
- Subtotals (8:00)
- Module 14 – Practice Exercise (1:07)
- Arranging Files (3:14)
- New Window Option (2:45)
- Custom Views (5:32)
- Module 15 – Practice Exercise (1:07)
- Creating Formulas Between Files (6:35)
- Working with Links (4:01)
- Consolidating Data (5:16)
- Module 16 – Practice Exercise (1:30)
- If Statements (7:49)
- VLookups (7:39)
- Data Validation (8:13)
- Formula Auditing (5:29)
- Module 17 – Practice Exercise (1:19)
- Pivot Tables (9:36)
- Pivot Charts (3:16)
- Module 18 – Practice Exercise (0:56)
- Goal Seeker (2:56)
- Slicers (4:41)
- Text to Columns (2:49)
- Watch Window (2:32)
- Customizing Ribbons and Tabs (3:25)
- Module 19 – Practice Exercise (1:23)
- Excel Shortcuts Every User Should Know (12:00)
- Closing Video (0:37)
- Course Quiz and Certificate of Completion
Method Purchase & Reveice Course
> All courses are available in our website
> You will receive download link course (Google Drive) to your order email or File Manager in website
> If you can’t find the download link for the course you paid for, please don’t worry about it. We will notify and update you via your email at 7:00 AM – 11:00 PM (UTC +7)
> All courses are digital online versions, so you will download and save to your hard drive.
