Booking options
Price:
BuyContact Us£37.99
Course Images
The Complete Excel Guide: Beginners to Advanced
By Packt
🔥 Limited Time Offer 🔥
Get a 10% discount on your first order when you use this promo code at checkout: MAY24BAN3X
- 30 Day Money Back Guarantee
- Completion Certificate
- 24/7 Technical Support
Highlights
On-Demand course
15 hours 35 minutes
All levels
Description
This video course will help you learn all the basic and advanced concepts of Microsoft Excel 2019. You'll start with Excel basics and slowly move to the advanced concepts in Excel. Each section is accompanied by an exercise at the end to practice what you have learned.Everyone knows that the Microsoft Office suite is used by millions worldwide. Unlocking its full potential and learning it thoroughly will improve your productivity drastically. This course will help you grasp all the essential and advanced skills for Microsoft Excel 2019 with the help of interesting activities. We'll start with the basic topics and see what's new in Excel 2019. Then we will create workbooks; enter data into; explore page setup and print options; work with rows, columns, and cells; learn how the Cut, Copy, and Paste option works; understand functions and formulas; and also get introduced to PivotTables, logical, and lookup formulas. After this, we will move towards advanced concepts such as lookup and advanced lookup functions, financial functions including calculating interest and depreciation, statistical functions, learning how to connect to other workbooks and datasets outside of Excel, and creating awesome visualizations using sparklines and data bars. We'll also cover some advanced charts such as Surface, Radar, Bubble, and Stock Charts. By the end of this course, you'll become proficient in using Microsoft Excel for your professional and personal needs. All the resources for this course are available at https://github.com/PacktPublishing/The-Complete-Excel-Guide-Beginners-to-Advanced
What You Will Learn
Grasp techniques to back up and recover your Excel spreadsheets
Discover the essentials of using formulas and functions in Excel
Discover what's new or different in Excel 2019
Learn to effectively use autofill and flashfill
Discover how to create stunning charts and graphs in Excel
Learn practical methods to sort and filter your data in Excel
Audience
This course is designed for anyone who is interested in mastering Microsoft Excel 2019 and becoming an expert in Microsoft Excel. To get started with this course, you need to have basic computer skills and Microsoft Office installed on your computer.
Approach
With the help of simple narration, interesting exercises, and engaging activities, this video course will make you well-versed in Microsoft Excel 2019.
Key Features
Gain a solid understanding of Microsoft Excel 2019 * Uncover amazing Microsoft Excel suite techniques and shortcuts to make your job easy * Learn how to add life to your Excel spreadsheets by creating stunning charts and graphs
Github Repo
https://github.com/PacktPublishing/The-Complete-Excel-Guide-Beginners-to-Advanced
About the Author
Simon Sez IT
Simon Sez IT has offered technical courses for individuals, small businesses, and Fortune 500 companies since 2008, with thousands of employees who can benefit from the easy-to-learn and hands-on software training. It offers over 8,000 video tutorials on a range of software programs. Simon Sez IT ensures stress-free eLearning and enhanced employee productivity-whether you implement new software or a technological upgrade in your work environment. With over 600,000 students from 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses worldwide.
Course Outline
1. Excel 2019: Introduction
1. Introduction to Excel An introduction to Excel. |
2. What's New in Excel 2019 Let's see what's new in Excel 2019. |
3. Course Overview A quick overview of the course. |
4. Overview of the Excel Window Let's explore the Excel window. |
5. Mouse Features Let's explore the mouse features available in Excel. |
6. Backstage View Let's see what is the backstage view. |
2. Excel 2019 Beginner: Creating Workbooks
1. Entering Text and Numbers Learn how to enter text and numbers. |
2. Creating Basic Formulas Learn how to create basic formulas. |
3. Relative References Learn about the relative references. |
4. Order of Operations Learn about the order of operations. |
5. Working with Ranges Learn how to work with ranges. |
6. Module 2 - Practice Exercise Let's do a practice exercise. |
3. Excel 2019 Beginner: Saving Workbooks
1. Working with the Save and Save As Commands Let's explore the Save and Save As Commands. |
2. File Extensions, Share, Export, and Publish Files Understand file extensions, share, export, and publish files. |
3. Module 3 - Practice Exercise Let's do a practice exercise. |
4. Excel 2019 Beginner: Navigating Workbooks
1. Opening a File Let's open a file. |
2. Working with Larger Files Let us see how to manage larger files in Excel. |
3. Freeze Panes Option Let's explore the Freeze Panes option. |
4. Split Screen Option Let's explore the Split Screen option. |
5. Module 4 - Practice Exercise Let's do a practice exercise. |
5. Excel 2019 Beginner: Page Setup and Print Options
1. Headers and Footers This video aims to explain headers and footers. |
2. Print Titles This video aims to explain Print Titles. |
3. Comments This video aims to explain comments. |
4. Page Setup Options This video aims to explain page setup options. |
5. Fit to Print on One Page This video aims to explain how to fit to print on one page. |
6. Printing Workbooks This video aims to explain how to print workbooks. |
7. Module 5 - Practice Exercise Let's do a practice exercise. |
6. Excel 2019 Beginners: Working with Rows, Columns, and Cells
1. Adding and Deleting Rows, Columns, and Cells Learn how to add and delete rows, columns, and cells. |
2. Changing Column and Row Widths Let's learn how to change column and row widths. |
3. Module 6 - Practice Exercise Let's do a practice exercise. |
7. Excel 2019 Beginners: Moving Data
1. Cut, Copy, and Paste Learn and explore the cut, copy, and paste options. |
2. Copying Formulas Let's learn how to copy formulas. |
3. Module 7 - Practice Exercise Let's do a practice exercise. |
8. Excel 2019 Beginners: Formulas and Functions
1. Overview of Formulas In this video, let's take a quick overview of formulas. |
2. Create Formulas Using Functions: Part 1 Learn how to create formulas using functions. |
3. Create Formulas Using Functions: Part 2 Let's continue to learn how to create formulas using functions. |
4. Absolute Values Let's understand what are absolute values. |
5. Module 8 - Practice Exercise Let's do a practice exercise. |
9. Excel 2019 Beginners: Working with Sheets
1. Adding, Deleting, and Renaming Sheets Learn how to add, delete, and rename sheets. |
2. Additional Sheet Tab Options We will explore the additional sheet tab options. |
3. Dimensional Formulas Let's explore dimensional formulas. |
4. Module 9 - Practice Exercise Let's do a practice exercise. |
10. Excel 2019 Beginners: Formatting Worksheets
1. Formatting Cells: Part 1 In this video, let's learn how to format cells. |
2. Formatting Cells: Part 2 Continue with formatting cells. |
3. Formatting Numbers In this video, let's learn how to format numbers. |
4. Borders and Shading Let's learn borders and shading. |
5. Format as Table The aim of this video is to explore how to format as table. |
6. Using Styles The aim of this video is to explore how to use styles. |
7. Using Format Painter The aim of this video is to explore how to use format painter. |
8. Protecting Sheets The aim of this video is to explore how to protect sheets. |
9. Fill Handle and Custom Lists The aim of this video is to explore how to work with fill handle and custom lists. |
10. Module 10 - Practice Exercise Let's do a practice exercise. |
11. Excel 2019 Beginners: Charts
1. Creating Charts The aim of this video is to explore creating charts. |
2. Types of Charts The aim of this video is to explore types of charts. |
3. Editing Charts: Part 1 The aim of this video is to explore how to edit charts. |
4. Editing Charts: Part 2 The aim of this video is to further explore how to edit charts. |
5. Using Graphics to Enhance Charts The aim of this video is to explore how to use graphics to enhance charts. |
6. Linking Chart Titles The aim of this video is to explore how to link chart titles. |
7. Module 11 - Practice Exercise Let's do a practice exercise. |
12. Excel 2019 Beginners: Working with Names
1. Creating Range Names The aim of this video is to explore how to create range names. |
2. Managing Names The aim of this video is to explore how to manage names. |
3. Using Names in Formulas The aim of this video is to explore how to use names in formulas. |
4. Module 12 - Practice Exercise Let's do a practice exercise. |
13. Excel 2019 Beginners: Sorting and Filtering
1. Remove Duplicates The aim of this video is to explore how to remove duplicates. |
2. Sort Data The aim of this video is to explore how to sort data. |
3. Filter Data The aim of this video is to explore how to filter data. |
4. Advanced Filters The aim of this video is to explore how to apply advanced filters. |
5. Module 13 - Practice Exercise Let's do a practice exercise. |
14. Excel 2019 Beginners: Outlining and Subtotaling
1. Creating an Outline The aim of this video is to explore how to create an outline. |
2. Subtotals The aim of this video is to explore subtotals. |
3. Module 14 - Practice Exercise Let's do a practice exercise. |
15. Excel 2019 Beginners: Working with Views
1. Arranging Files The aim of this video is to explore how to arrange files. |
2. New Window Option The aim of this video is to explore the new window option. |
3. Custom Views The aim of this video is to explore the custom views option. |
4. Module 15 - Practice Exercise Let's do a practice exercise. |
16. Excel 2019 Beginners: Linking Files
1. Creating Formulas Between Files The aim of this video is to explore how to create formulas between files. |
2. Working with Links The aim of this video is to explore how to work with links. |
3. Consolidating Data The aim of this video is to explore how to consolidate data. |
4. Module 16 - Practice Exercise Let's do a practice exercise. |
17. Excel 2019 Beginners: Advanced Formula Creation
1. If Statements The aim of this video is to understand the If statements. |
2. VLOOKUPS The aim of this video is to explore how VLOOKUPS works. |
3. Data Validation The aim of this video is to explore how data validation works. |
4. Formula Auditing The aim of this video is to explore formula auditing. |
5. Module 17 - Practice Exercise Let's do a practice exercise. |
18. Excel 2019 Beginners: PivotTables
1. PivotTables The aim of this video is to explore PivotTables. |
2. Pivot Charts The aim of this video is to explore pivot charts. |
3. Module 18 - Practice Exercise Let's do a practice exercise. |
19. Excel 2019 Beginners: Additional Excel Features
1. Slicers The aim of this video is to explore slicers. |
2. Goal Seeker The aim of this video is to explore goal seeker. |
3. Text to Columns The aim of this video is to explore how to convert text to columns. |
4. Watch Window The aim of this video is to explore Watch Window. |
5. Customizing Ribbons and Tabs The aim of this video is to explore how to customize ribbons and tabs |
6. Module 19 - Practice Exercise Let's do a practice exercise. |
20. Excel 2019 Beginners: Shortcuts
1. Excel Shortcuts Every User Should Know The aim of this video is to explore how to use Excel shortcuts. |
21. Excel 2019 Beginners: Closing
1. Summary Let's summarize what we have learnt so far. |
22. Excel 2019 Advanced: Introduction to Advanced Course
1. Introduction Let's start with advanced Excel. |
2. Course Structure The aim of this video is to explain the course structure for advanced Excel. |
23. Excel 2019 Advanced: Functions
1. Functions - Part 1 What are the functions? |
2. Functions - Part 2 Let's continue with the functions. |
3. Autosum The aim of this video is to explore the Autosum function. |
24. Excel 2019 Advanced: Date and Time Functions
1. How Date and Time Works The aim of this video is to explore how date and time works. |
2. Basic Date and Time Functions The aim of this video is to explore the basic dates and time functions. |
3. Complex Date and Time Functions The aim of this video is to explore the complex dates and time functions. |
25. Excel 2019 Advanced: Text Functions
1. Using Text Functions - Part 1 The aim of this video is to explore how to use text functions. |
2. Using Text Functions - Part 2 The aim of this video is to explore how to use text functions. |
26. Excel 2019 Advanced: Logical Functions
1. Logical Functions The aim of this video is to explore logical functions. |
2. Exercise 01 Let's do a practice exercise. |
27. Excel 2019 Advanced: Lookup Functions
1. Lookup Functions - Part 1 The aim of this video is to explore lookup functions. |
2. Lookup Functions - Part 2 The aim of this video is to further explore lookup functions. |
3. Exercise 02 Let us do a practice exercise. |
28. Excel 2019 Advanced: Financial Functions
1. Financial Functions and Terminology The aim of this video is to explore financial functions and terminology. |
2. Personal Financial Functions The aim of this video is to explore personal financial functions. |
3. Principal and Interest Payments The aim of this video is to explore principal and interest payments. |
4. Depreciation The aim of this video is to explore depreciation. |
5. Exercise 03 Let us do a practice exercise. |
29. Excel 2019 Advanced: Statistical Functions
1. Statistical Functions for Description - Part 1 The aim of this video is to explore statistical functions for description. |
2. Statistical Functions for Description - Part 2 The aim of this video is to further explore statistical functions for description. |
3. Statistical Functions for Forecasting - Part 1 The aim of this video is to explore statistical functions for forecasting. |
4. Statistical Functions for Forecasting - Part 2 The aim of this video is to explore more statistical functions for forecasting. |
5. Exercise 04 Let us do a practice exercise. |
6. One Click Forecasting The aim of this video is to explore one click forecasting. |
7. Statistical Functions for Inference The aim of this video is to explore statistical functions for inference. |
30. Excel 2019 Advanced: Connecting to External Data
1. Connecting to Other Workbooks The aim of this video is to explore how to connect to other workbooks. |
2. Connecting to Access Databases The aim of this video is to explore how to connect to access databases. |
3. Connecting Web Data Sources The aim of this video is to explore how to connect to web data sources. |
4. Get and Transform The aim of this video is to explore get and transform. |
5. Exercise 05 Let us do a practice exercise. |
31. Excel 2019 Advanced: Tables
1. Introduction to Tables Let's start with tables. |
2. Working with Tables The aim of this video is to explore how to work with tables. |
3. Table References The aim of this video is to explore what are table references. |
4. Table Styles The aim of this video is to explore table styles. |
5. Exercise 6 Let us do a practice exercise. |
32. Excel 2019 Advanced: PivotTables
1. Introduction to PivotTables The aim of this video is to explore PivotTables. |
2. Working with PivotTables The aim of this video is to explore how to work with PivotTables. |
3. Filters and Slicers The aim of this video is to explore filters and slicers. |
4. Pivot and Charts The aim of this video is to explore pivots and charts. |
5. Exercise 07 Let us do a practice exercise. |
33. Excel 2019 Advanced: Data Analysis
1. What If Analysis The aim of this video is to explore What If analysis. |
2. Scenario Manager The aim of this video is to explore the scenario manager. |
3. Goal Seek The aim of this video is to explore goal seek. |
4. Solver The aim of this video is to explore Solver. |
5. Exercise 08 Let us do a practice exercise. |
34. Excel 2019 Advanced: Graphs and Charts
1. Area Charts The aim of this video is to explore area charts. |
2. Surface Charts The aim of this video is to explore surface charts. |
3. Radar Charts The aim of this video is to explore radar charts. |
4. Bubble Charts The aim of this video is to explore bubble charts. |
5. Sparklines The aim of this video is to explore sparklines. |
6. Stock Charts The aim of this video is to explore stock charts. |
7. Exercise 9 Let us do a practice exercise. |
35. Excel 2019 Advanced: Excel Web App
1. Web App - Part 1 Let's look and understand web app. |
2. Web App - Part 2 Let's continue with web app. |
36. Excel 2019 Advanced: Course Conclusion
1. Summary Let's summarize what we have learnt about Excel 2019. |
Course Content
- The Complete Excel Guide: Beginners to Advanced
About The Provider
Packt
Birmingham
Founded in 2004 in Birmingham, UK, Packt’s mission is to help the world put software to work in new ways, through the delivery of effective learning and i...
Reviews
There are no reviews for The Complete Excel Guide: Beginners to Advanced yet.Why not be the first one to review this course?