Skip to content
  • 🎉  CoursePico - Get Your SPECIAL OFFER CODE 30% OFF Today: PICO30  🎉

Coursepico – Digital Download – GroupBuy CourseCoursepico – Digital Download – GroupBuy Course
  • Home
  • Courses
  • COURSES LIST
    • Real Estate Courses
    • Internet Marketing
    • Business & Marketing
    • Personal Development
    • Forex & Trading
    • NLP & Hypnotherapy
    • Sports & Fitness
    • Martial Arts & Fighting
    • Medical Health
    • Love & Dating
    • Body Language
    • Other
      • Design Website
      • SEO Courses
      • Film & Photograph
      • Apps & Software
      • Writing
      • Uncategorized
      • Music
      • Everything Else
  • Login
  • Cart
    • No products in the cart.

  • Cart

    No products in the cart.

-74%
Add to wishlist
Home / Everything Else

Microsoft Excel 2019 – Beginners Course – Simon Sez IT

100.00$ 26.00$

Digital Course Download Instantly

Add to wishlist
Category: Everything Else Tags: Microsoft Excel 2019 - Beginners Course, Simon Sez IT, Simon Sez IT - Microsoft Excel 2019 - Beginners Course
List categories
  • Apps & Software
  • Body Language
  • Business & Marketing
  • Design Website
  • Everything Else
  • Film & Photograph
  • Forex & Trading
  • Internet Marketing
  • Love & Dating
  • Martial Arts & Fighting
  • Medical Health
  • Music
  • NLP & Hypnotherapy
  • Other
  • Personal Development
  • Real Estate Courses
  • SEO Courses
  • Sports & Fitness
  • Uncategorized
  • Writing
  • Description

Microsoft Excel 2019 – Beginners Course – Simon Sez IT


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

 


Files will be delivered through Google Drive Download Link
Lifetime Stored Courses
100% Safe & Secure By SSL Encryption Payments


 

Related products

-66%
Add to wishlist

Everything Else

Essential VBA Training for Excel – Automate Repetitive Tasks – Simon Sez IT

50.00$ 17.00$
Add to cart
-82%
Add to wishlist

Everything Else

Rallylydnad, nybörjare – Pernilla Pöykiöniemi

119.00$ 21.00$
Add to cart
-53%
Mickey’s Very Merry Christmas Party - LJ Johnson
Add to wishlist

Everything Else

Mickey’s Very Merry Christmas Party – LJ Johnson

19.00$ 9.00$
Add to cart
-69%
Add to wishlist

Everything Else

The Ultimate TypeScript Course – Mosh Hamedani

29.00$ 9.00$
Add to cart
-76%
Add to wishlist

Everything Else

Advanced PivotTables in Excel – Simon Sez IT

75.00$ 18.00$
Add to cart
-74%
Add to wishlist

Everything Else

Microsoft Excel 2019 – Advanced Course – Simon Sez IT

100.00$ 26.00$
Add to cart
-76%
Add to wishlist

Everything Else

Spanish Uncovered (Beginner) – Olly Richards

297.00$ 72.00$
Add to cart
-66%
Add to wishlist

Everything Else

Basics Video Series – LJ Johnson

47.00$ 16.00$
Add to cart
-53%
Add to wishlist

Everything Else

All About Animal Kingdom – LJ Johnson

19.00$ 9.00$
Add to cart
-65%
Add to wishlist

Everything Else

Macros and VBA for Beginners – Simon Sez IT

49.00$ 17.00$
Add to cart
-74%
Add to wishlist

Everything Else

Microsoft Excel 2021 Intermediate Training Course – Simon Sez IT

99.00$ 26.00$
Add to cart
-53%
Add to wishlist

Everything Else

Totally Transportation – LJ Johnson

19.00$ 9.00$
Add to cart

About CoursePico

We at CoursePico are a responsible and reputable team, providing quality and affordable courses, you can trust us.

Shop

    ➤ Real Estate Course

    ➤ Business Course

    ➤ Trading Course

    ➤ Other

SUPPORT

    ➤ CONTACT US

    ➤ FAQS

    ➤ Shop

    ➤ My Order

PAYMENT ACCEPT
Copyright © 2025 - Product By CoursePico
  • Home
  • Courses
  • Login

Login

Lost your password?

Register

Your personal data will be used to support your experience throughout this website, to manage access to your account, and for other purposes described in our privacy policy.