Description
**Course includes practice exercise files, LIFETIME access and is covered by the Udemy money-back guarantee**
Everything you need to become a spreadsheet guru in Microsoft Excel 2019/365 from Beginner to Advanced users by Excel experts Simon Sez IT.
Excel for Beginners 2019
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 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
Advanced Excel 2019
With this 8-hour, expert-led video training course, you’ll gain an in-depth understanding of more advanced Excel features that delve into high-level consolidation, analysis and reporting of financial information.
What You'll Learn
-
What's new/different in Excel 2019
-
Advanced charting and graphing in Excel
-
How to use detailed formatting tools
-
Lookup and advanced lookup functions
-
Financial functions including calculating interest and depreciation
-
Statistical functions
-
Connecting to other workbooks and datasets outside of Excel e.g. MS Access and the web.
-
How to create awesome visualizations using sparklines and data bars
-
Mastery of PivotTables and Pivot Charts
-
Scenario Manager, Goal Seek and Solver
-
Advanced charts such as Surface, Radar, Bubble and Stock Charts
***Exercise and demo files included in both courses***
This 2-course bundle includes:
15-hours of video tutorials
Over 150 individual video lectures
Exercise files to practice what you learned
Demo files used by the trainer
Certificates of completion
This Excel mega bundle is designed for students of all Excel capabilities. If you are brand 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, then the start at the beginning.
If you already have a good understanding of MS Excel then you might want to start in the Advanced section where the expert author will help you take your spreadsheeting skills to the next level.
Contents and Overview
Through 152 lectures and over 15-hours of content, this course will teach you to understand spreadsheet basics, including:
-
Creating your first workbook and how to navigate Excel
-
Page and print setup - just print the bits of Excel you mean to!
-
Moving data around and adding and deleting
-
Introduction to formulas and functions, what you need to know.
-
How to create amazing looking charts and graphs
Before moving onto the most business-relevant advanced functions and formulas you might need. This includes:
Upon completion of this course, you'll have a great grounding in Excel formulas and functions. You’ll be confident in navigating, sharing and using spreadsheets in a variety of ways.
You’ll be able to create charts that have an impact from databases that communicate data and financial records efficiently and effectively.
You will be able to report data in various formats including: tables, graphs and PivotTables. Once completed you'll have advanced understanding of Excel that will positively impact your professional capability.
What People Are Saying:
★★★★★ "This is an excellently pieced together information. Beautifully explained with lots of examples and external resource areas for the nerds. I highly recommend this course for anyone whose intention is to learn Excel.” -Frank Uchegbu
★★★★★ “Greatly explained and great zoom in of the working area.” -Jorge Tech
Who this course is for:
- 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.
- Users with basic knowledge of Excel and those upgrading from previous software versions
- Users who have a foundation of Microsoft Excel and seeking to advance their Excel knowledge.
Course content
- Excel 2019 Beginner: Intro to Excel
- Intro to Excel
- Essential Information for a Successful Training Experience
- Course exercise files
- What's New In Excel 2019
- Course Overview
- Overview of the Excel window
- Mouse-Features
- Back Stage View
- Section 1 - Quiz
- Excel 2019 Beginner: Creating Workbooks
- Entering Text and Numbers
- Creating Basic Formulas
- Relative References
- Order of Operations
- Working with Ranges
- Module 2 - Practice Exercise
- Section 2 Quiz
- Excel 2019 Beginner: Saving Workbooks
- Working with the Save and Save As Commands
- File Extensions, Share, Export and Publish Files
- Module 3 - Practice Exercise
- Section 3 Quiz
- Excel 2019 Beginner: Navigating Workbooks
- Opening a File
- Working with Larger Files
- Freeze Panes Option
- Split Screen Option
- Module 4 - Practice Exercise
- Section 4 Quiz
- Excel 2019 Beginner: Page Setup & Print Options
- Headers and Footers
- Print Titles
- Comments
- Page Setup Options
- Fit to Print on One Page
- Printing Workbooks
- Module 5 - Practice Exercise
- Section 5 Quiz
- Excel 2019 Beginners: Working with Rows, Columns and Cells
- Adding and deleting rows columns and cells
- Changing Column and-Row Widths
- Module 6 - Practice Exercise
- Section 6 Quiz
- Excel 2019 Beginners: Moving Data
- Cut, Copy and Paste
- Copying Formulas
- Module 7 - Practice Exercise
- Section 7 Quiz
- Excel 2019 Beginners: Formulas & Functions
- Overview of Formulas
- Create Formulas Using Functions Part 1
- Create Formulas Using Functions Part 2
- Absolute Values
- Module 8 - Practice Exercise
- Section 8 Quiz
- Excel 2019 Beginner: Working with Sheets
- Adding Deleting and Renaming Sheets
- Additional Sheet Tab Options
- 3 Dimensional Formulas
- Module 9 - Practice Exercise
- Section 9 Quiz
- Excel 2019 Beginner: Formatting Worksheets
- Formatting Cells Part 1
- Formatting Cells Part 2
- Formatting Numbers
- Borders and Shading
- Format as Table
- Using Styles
- Using Format Painter
- Protecting Sheets
- Fill Handle and Custom Lists
- Module 10 - Practice Exercise
- Section 10 Quiz
- Excel 2019 Beginner: Charts
- Creating Charts
- Types of Charts
- Editing Charts Part 1
- Editing Charts Part 2
- Using Graphics to Enhance Charts
- Linking Chart Titles
- Module 11 - Practice Exercise
- Section 11 Quiz
- Excel 2019 Beginner: Working with Names
- Creating Range Names
- Managing Names
- Using Names in Formulas
- Module 12 - Practice Exercise
- Section 12 Quiz
- Excel 2019 Beginner: Sorting and Filtering
- Remove Duplicates
- Sort Data
- Filter Data
- Advanced Filters
- Module 13 - Practice Exercise
- Section 13 Quiz
- Excel 2019 Beginner: Outlining and Subtotaling
- Creating an Outline
- Subtotals
- Module 14 - Practice Exercise
- Section 14 Quiz
- Excel 2019 Beginner: Working with Views
- Arranging Files
- New Window Option
- Custom Views
- Module 15 - Practice Exercise
- Section 15 Quiz
- Excel 2019 Beginner: Linking Files
- Creating Formulas Between File
- Working with Links
- Consolidating Data
- Module 16 - Practice Exercise
- Section 16 Quiz
- Excel 2019 Beginner: Advanced Formula Creation
- If Statements
- VLookups
- Data Validation
- Formula Auditing
- Module 17 - Practice Exercise
- Section 17 Quiz
- Excel 2019 Beginner: Pivot Tables
- Pivot Tables
- Pivot Charts
- Module 18 - Practice Exercise
- Section 18 Quiz
- Excel 2019 Beginner: Additional Excel Features
- Slicers
- Goal Seeker
- Text to Columns
- Watch Window
- Customizing Ribbons and Tabs
- Module 19 - Practice Exercise
- Section 19 Quiz
- Excel 2019 Beginner: Shortcuts
- Excel Shortcuts Every User Should Know
- Excel 2019 Beginner: Closing
- Excel 2019 Advanced: Introduction to Excel 2019 Advanced Course
- Introduction to the Course
- Essential Information for a Successful Training Experience
- Excel 2019 Advanced Course Exercise Files
- Excel 2019 Advanced Course Demo Files
- Course Structure
- Excel 2019 Advanced: Functions
- Functions - Part 1
- Functions - Part 2
- Autosum
- Section 23 Quiz
- Excel 2019 Advanced: Date and Time Functions
- How Date and Time Works
- Basic Date and Time Functions
- Complex Date and Time Functions
- Section 24 QUiz
- Excel 2019 Advanced: Text Functions
- Using Text Functions - Part 1
- Using Text Functions - Part 2
- Section 25 Quiz
- Excel 2019 Advanced: Logical Functions
- Logical Functions
- Exercise 01
- Section 26 Quiz
- Excel 2019 Advanced: Lookup Functions
- Lookup Functions - Part 1
- Lookup Functions - Part 2
- Exercise 02
- Section 27 Quiz
- Excel 2019 Advanced: Financial Functions
- Financial Functions and Terminology
- Personal Financial Functions
- Principal and Interest Payments
- Depreciation
- Exercise 03
- Section 28 Quiz
- Excel 2019 Advanced: Statistical Functions
- Statistical Functions for Description - Part 1
- Statistical Functions for Description - Part 2
- Statistical Functions for Forecasting - Part 1
- Statistical Functions for Forecasting - Part 2
- Exercise 04
- One Click Forecasting
- Statistical Functions for Inference
- Section 29 Quiz
- Excel 2019 Advanced: Connecting to External Data
- Connecting to Other workbooks
- Connecting to Access Databases
- Connecting Web Data Sources
- Get and Transform
- Exercise 05
- Section 30 Quiz
- Excel 2019 Advanced: Tables
- Introduction to Tables
- Working with Tables
- Table References
- Table Styles
- Exercise 6
- Section 31 Quiz
- Excel 2019 Advanced: Pivot Tables
- Introduction to Pivot Tables
- Working with Pivot Tables
- Filters and Slicers
- Pivot and Charts
- Exercise 07
- Section 32 Quiz
- Excel 2019 Advanced: Data Analysis
- What If Analysis
- Scenario Manager
- Goal Seek
- Solver
- Exercise 08
- Section 33 Quiz
- Graphs and Charts
- Area Charts
- Surface Charts
- Radar Charts
- Bubble Charts
- Sparklines
- Stock Charts
- Exercise 9
- Section 34 Quiz
- Excel 2019 Advanced: Excel Web App
- Web App - Part 1
- Web App - Part 2
- Section 35 Quiz
- Excel 2019 Advanced: Course Conclusion
Master Excel 2019 365 with this Beginner to Advanced Bundle.part1.rar
Master Excel 2019 365 with this Beginner to Advanced Bundle.part2.rar
