Original price was: $100.00.Current price is: $30.00.

Instant Download: You will receive a download link via your order email immediately
Save up to 85% compared to Salepage prices. In addition, earn additional points. Save more on your next order.

Please contact email: [email protected] if you have any questions about this course.

Purchase this course you will earn 30 Points worth of $3.00

Category: Everything Else Tags: Simon Sez IT, Simon Sez IT - Microsoft Excel 2019 - Beginners Course, Tags: Microsoft Excel 2019 - Beginners Course

Description

Simon Sez IT – Microsoft Excel 2019 – Beginners Course

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. 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.

Your Instructor

Simon Sez IT

Simon Sez IT makes business and technical software simple to learn.

Our most important goal is to help learners build and strengthen your software skills. We focus on simplicity but explain things in the detail they deserve. Simon Sez IT subject matter experts bring passion, knowledge and practical insights to video-based courses and practice exercises – all designed to help learners immediately apply your new knowledge and master your learning goals.

This is why more than a million learners have relied on Simon Sez IT since 2008.

Course Curriculum

Chapter 1: Into to Excel

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

Chapter 2: Creating Workbooks

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)

Chapter 3: Saving Workbooks

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)

Chapter 4: Navigating Workbooks

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)

Chapter 5: Page Setup & Print Options

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)

Chapter 6: Working with Rows, Columns and Cells

Adding and deleting rows columns and cells (6:12)
Changing Column and-Row Widths (3:45)
Module 6 – Practice Exercise (1:11)

Chapter 7: Moving Data

Cut Copy and Paste (7:07)
Module 7 – Practice Exercise (1:20)
Copying Formulas (5:09)

Chapter 8: Formulas & Functions

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)

Chapter 9: Working with Sheets

Adding Deleting and Renaming Sheets (4:09)
Additional Sheet Tab Options (5:19)
3 Dimensional Formulas (5:28)
Module 9 – Practice Exercise (1:31)

Chapter 10: Formatting Worksheets

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)

Chapter 11: Charts

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)

Chapter 12: Working with Names

Creating Range Names (7:45)
Managing Names (3:17)
Using Names in Formulas (5:58)
Module 12 – Practice Exercise (1:20)

Chapter 13: Sorting & Filtering

Remove Duplicates (7:45)
Sort Data (10:28)
Filter Data (7:38)
Advanced Filters (4:46)
Module 13 – Practice Exercise (0:57)

Chapter 14: Outlining & Subtotaling

Creating an Outline (6:01)
Subtotals (8:00)
Module 14 – Practice Exercise (1:07)

Chapter 15: Working with Views

Arranging Files (3:14)
New Window Option (2:45)
Custom Views (5:32)
Module 15 – Practice Exercise (1:07)

Chapter 16: Linking Files

Creating Formulas Between Files (6:35)
Working with Links (4:01)
Consolidating Data (5:16)
Module 16 – Practice Exercise (1:30)

Chapter 17: Advanced Formula Creation

If Statements (7:49)
VLookups (7:39)
Data Validation (8:13)
Formula Auditing (5:29)
Module 17 – Practice Exercise (1:19)

Chapter 18: Pivot Tables

Pivot Tables (9:36)
Pivot Charts (3:16)
Module 18 – Practice Exercise (0:56)

Chapter 19: Additional Excel Features

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)

Chapter 20: Shortcuts

Excel Shortcuts Every User Should Know (12:00)

Chapter 21: Closing

Closing Video (0:37)
Course Quiz and Certificate of Completion

Proof Content

Simon Sez IT – Microsoft Excel 2019 – Beginners Course2

Sale Page: https://streamskill.com/p/excel19-beginners
Archive: https://archive.ph/wip/9WOsF

Delivery Method

– After your purchase, you’ll see a View your orders link which goes to the Downloads page. Here, you can download all the files associated with your order.

– Downloads are available once your payment is confirmed, we’ll also send you a download notification email separate from any transaction notification emails you receive from esy[GB].

– Since it is a digital copy, our suggestion is to download and save it to your hard drive. In case the link is broken for any reason, please contact us and we will resend the new download link.

– If you cannot find the download link, please don’t worry about that. We will update and notify you as soon as possible from 8:00 AM – 8:00 PM (UTC+8).

Thank You For Shopping With Us!