Last updated 12/2022
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz
Language: English | Size: 6.45 GB | Duration: 12h 41m
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
Homepage
https://www.udemy.com/course/learn-excel-2019-beginners/
Download From 1DL
DOWNLOAD FROM 1DL.NET
DOWNLOAD FROM 1DL.NET
DOWNLOAD FROM 1DL.NET
DOWNLOAD FROM 1DL.NET
DOWNLOAD FROM 1DL.NET
DOWNLOAD FROM 1DL.NET
DOWNLOAD FROM 1DL.NET
DOWNLOAD FROM RAPIDGATOR.NET
DOWNLOAD FROM RAPIDGATOR.NET
DOWNLOAD FROM RAPIDGATOR.NET
DOWNLOAD FROM RAPIDGATOR.NET
DOWNLOAD FROM RAPIDGATOR.NET
DOWNLOAD FROM RAPIDGATOR.NET
DOWNLOAD FROM RAPIDGATOR.NET
DOWNLOAD FROM UPLOADGIG.COM
DOWNLOAD FROM UPLOADGIG.COM
DOWNLOAD FROM UPLOADGIG.COM
DOWNLOAD FROM UPLOADGIG.COM
DOWNLOAD FROM UPLOADGIG.COM
DOWNLOAD FROM UPLOADGIG.COM
DOWNLOAD FROM UPLOADGIG.COM
DOWNLOAD FROM NITROFLARE.COM
DOWNLOAD FROM NITROFLARE.COM
DOWNLOAD FROM NITROFLARE.COM
DOWNLOAD FROM NITROFLARE.COM
DOWNLOAD FROM NITROFLARE.COM
DOWNLOAD FROM NITROFLARE.COM
DOWNLOAD FROM NITROFLARE.COM