Microsoft Excel 2019/365 For Absolute Beginners

Start your spreadsheet journey with this Excel 2021 training course for beginners!

What you'll learn

Discover new and improved features in Excel 2019

How to effectively use Excel 2019 on a touchscreen device.

How create, save, and open a workbook.

Learn how to personalize your use of Excel using Excel Options.

How to use and how to customize the Quick Access Toolbar.

Complete data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface.

The basics of entering and editing data in a workbook.

Discover how to format dates and numbers.

Learn practical methods in which you can backup and recover your Excel spreadsheets.

Effectively use autofill and flashfill so you are more productive.

Discover the essentials of using fomulas and functions.

How to rename, insert, move, and reference an Excel 2019 worksheet.

Discover how to create charts and graphs

Learn practical methods to sort and filter your data

How to protect and secure your Excel data

Requirements

Microsoft Excel 2019/365 desktop version for Windows installed and ready to use on your computer.

Description

**This course includes practice exercises and LIFETIME access**Get the basics of Microsoft Excel 2019 down in this detailed, course from Excel experts Simon Sez IT.With this 7-hour Microsoft Excel 2019/365 course, you’ll gain a fantastic grounding in Microsoft Excel. This in-depth course is perfect for those brand new to Excel and who are using Excel 2019 or Excel 365 editions. This course is perfect if you’re brand new to Excel or are upgrading from an older version.What You'll LearnWhat's new in Excel 2019Creating workbooksEntering text, numbers and working with datesNavigating workbooksPage setup and print optionsWorking with rows, columns and cellsCut, Copy and PasteIntroduction to functions and formulasFormatting in Excel, including formatting cells and numbersCreating charts and graphsSorting and FilteringIntroduction to PivotTablesLogical and lookup formulas - the basics***Exercise and demo files included***This course includes:7-hours of video tutorials95 individual video lecturesExercise files to practice what you learnedDemo files used by the trainerCertificate of completionThis course is designed for students that are new to Microsoft Excel or who are upgrading from a previous version and want to keep up to date with Excel 2019 and 365 developments. If you’re brand new to spreadsheets this course is perfect for you as our expert author guides you through the important areas of Excel.Contents and OverviewThrough 95 lectures and over 7-hours of content, this course will teach you to understand spreadsheet basics, including:Creating your first workbook and how to navigate ExcelPage and print setup - just print the bits of Excel you mean to!Moving data around and adding and deletingIntroduction to formulas and functions, what you need to know.How to create amazing looking charts and graphsAnd so much more…Upon completion of this course, you’ll have an intermediate understanding of Microsoft Excel 2019/365 and a certificate to prove it!DescriptionUnlock the power of Microsoft Excel and watch your productivity soar!BUSINESSES RUN ON MICROSOFT EXCEL. Microsoft Excel remains the go-to tool for crunching numbers for millions of office workers.PERFECT FOR BEGINNERS. This course covers basic and intermediate level skills across MS Excel 2019365.MAKING SOFTWARE SIMPLE. Our approach to teaching is all about making complex software simple to use. Our expert tutors don’t rush through content, instead they take the time to explain how things work in simple, plain English.EVERYTHING IS INCLUDED. You don’t get just a how-to video from Simon Sez IT. Modules include downloadable practice exercises so you can put into practice what you learn straight away. If that’s not enough you’ll also get Certificates of Completion - proof that you’ve learnt those valuable Microsoft Excel skills.A GREAT GIFT IDEA. Not shopping for you? No problem, give the gift of learning with Simon Sez IT and help the ones you love succeed.Here’s what our students are saying…★★★★★ "Hi. My name is Crockett and I live in New Orleans, Louisiana. I just want to take the time to thank this instructor for taking the time to give this course. I feel that my monies were well spent.Thanks again and I highly recommend this class for anyone wanting to expand their knowledge in Excel.” - Carlos Crocket★★★★★ “The content is comprehensive and informative. The speaker has a clear voice and at the perfect speed. The training is so engaging I'm looking forward to complete the next lectures.Many thanks!” - Helena M Tome★★★★★ “The instructor explained the content in a logical way and included tips and reminders about different functionality used in the different versions of Excel. ”- Carla SchanstraDid you know?Simon Sez IT teaches all sorts of software, including:- Microsoft Excel- Microsoft PowerPoint- Microsoft Word- Microsoft Project- Microsoft Outlook- QuickBooks- Photoshop Elements- Web Development Languages- And so much more!

Overview

Section 1: Intro to Excel

Lecture 1 Intro to Excel

Lecture 2 WATCH ME: Essential Information for a Successful Training Experience

Lecture 3 Course Exercise Files

Lecture 4 Downloadable course transcripts

Lecture 5 What's New In Excel 2019

Lecture 6 Course Overview

Lecture 7 Overview of the Excel window

Lecture 8 Mouse-Features

Lecture 9 Back Stage View

Section 2: Creating Workbooks

Lecture 10 Entering Text and Numbers

Lecture 11 Creating Basic Formulas

Lecture 12 Relative References

Lecture 13 Order of Operations

Lecture 14 Working with Ranges

Lecture 15 Module 2 - Practice Exercise

Section 3: Saving Workbooks

Lecture 16 Working with the Save and Save As Commands

Lecture 17 File Extensions, Share, Export and Publish Files

Lecture 18 Module 3 - Practice Exercise

Section 4: Navigating Workbooks

Lecture 19 Opening a File

Lecture 20 Working with Larger Files

Lecture 21 Freeze Panes Option

Lecture 22 Split Screen Option

Lecture 23 Module 4 - Practice Exercise

Section 5: Page Setup & Print Options

Lecture 24 Headers and Footers

Lecture 25 Print Titles

Lecture 26 Comments

Lecture 27 Page Setup Options

Lecture 28 Fit to Print on One Page

Lecture 29 Printing Workbooks

Lecture 30 Module 5 - Practice Exercise

Section 6: Working with Rows, Columns and Cells

Lecture 31 Adding and deleting rows columns and cells

Lecture 32 Changing Column and-Row Widths

Lecture 33 Module 6 - Practice Exercise

Section 7: Moving Data

Lecture 34 Cut, Copy and Paste

Lecture 35 Copying Formulas

Lecture 36 Module 7 - Practice Exercise

Section 8: Formulas & Functions

Lecture 37 Overview of Formulas

Lecture 38 Create Formulas Using Functions Part 1

Lecture 39 Create Formulas Using Functions Part 2

Lecture 40 Absolute Values

Lecture 41 Module 8 - Practice Exercise

Section 9: Working with Sheets

Lecture 42 Adding Deleting and Renaming Sheets

Lecture 43 Additional Sheet Tab Options

Lecture 44 3 Dimensional Formulas

Lecture 45 Module 9 - Practice Exercise

Section 10: Formatting Worksheets

Lecture 46 Formatting Cells Part 1

Lecture 47 Formatting Cells Part 2

Lecture 48 Formatting Numbers

Lecture 49 Borders and Shading

Lecture 50 Format as Table

Lecture 51 Using Styles

Lecture 52 Using Format Painter

Lecture 53 Protecting Sheets

Lecture 54 Fill Handle and Custom Lists

Lecture 55 Module 10 - Practice Exercise

Section 11: Charts

Lecture 56 Creating Charts

Lecture 57 Types of Charts

Lecture 58 Editing Charts Part 1

Lecture 59 Editing Charts Part 2

Lecture 60 Using Graphics to Enhance Charts

Lecture 61 Linking Chart Titles

Lecture 62 Module 11 - Practice Exercise

Section 12: Working with Names

Lecture 63 Creating Range Names

Lecture 64 Managing Names

Lecture 65 Using Names in Formulas

Lecture 66 Module 12 - Practice Exercise

Section 13: Sorting and Filtering

Lecture 67 Remove Duplicates

Lecture 68 Sort Data

Lecture 69 Filter Data

Lecture 70 Advanced Filters

Lecture 71 Module 13 - Practice Exercise

Section 14: Outlining and Subtotaling

Lecture 72 Creating an Outline

Lecture 73 Subtotals

Lecture 74 Module 14 - Practice Exercise

Section 15: Working with Views

Lecture 75 Arranging Files

Lecture 76 New Window Option

Lecture 77 Custom Views

Lecture 78 Module 15 - Practice Exercise

Section 16: Linking Files

Lecture 79 Creating Formulas Between File

Lecture 80 Working with Links

Lecture 81 Consolidating Data

Lecture 82 Module 16 - Practice Exercise

Section 17: Advanced Formula Creation

Lecture 83 If Statements

Lecture 84 VLookups

Lecture 85 Data Validation

Lecture 86 Formula Auditing

Lecture 87 Module 17 - Practice Exercise

Section 18: Pivot Tables

Lecture 88 Pivot Tables

Lecture 89 Pivot Charts

Lecture 90 Module 18 - Practice Exercise

Section 19: Additional Excel Features

Lecture 91 Slicers

Lecture 92 Goal Seeker

Lecture 93 Text to Columns

Lecture 94 Watch Window

Lecture 95 Customizing Ribbons and Tab

Lecture 96 Module 19 - Practice Exercise

Section 20: Shortcuts

Lecture 97 Excel Shortcuts Every User Should Know

Section 21: Closing

Lecture 98 Closing Video

Section 22: Extras

Lecture 99 EXTRA LESSON: Designing Better Spreadsheets Webinar Recording

Lecture 100 EXTRA LESSON: Data Cleaning in Excel Webinar Recording

Lecture 101 EXTRA LESSON: Top Ten Excel Functions You HAVE to Know Webinar Recording

Lecture 102 EXTRA RESOURCE: The Most Frequently Used Excel Shortcuts - Infographic

Section 23: Bonuses

Lecture 103 Ten Excel Tips and Tricks - Part 1

Lecture 104 Ten Excel Tips and Tricks - Part 2

Lecture 105 Ten Excel Tips and Tricks - Part 3

Those new to using Microsoft Excel.,No previous knowledge of Excel required. This course is created for absolute beginners.,If you want to refresh your memory and understanding of Excel.,Users of earlier versions of Excel looking to update their skills to 2019/365