Master Excel 2019 365 With This Beginner To Advanced Bundle
Master Excel 2019 365 With This Beginner To Advanced Bundle
What you’ll learn
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
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
15-hours of videotutorials
Over 150 individual video lectures
Exercise filesto 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.
Who this course is for:
- Discover new and improved features in Excel 2019
- Learn to master data analysis tools like Pivot tables, Slicers, Sparklines and Data Bars in Excel
- Learn essential logical functions like IF, SUMIF, COUNTIF
- Learn powerful Lookup Functions VLOOKUP, HLOOKUP and INDEX MATCH
- Complete data entry, cell formatting, working with multiple worksheets and the “Ribbon” interface.
- You’ll cover all the basics like how to rename, insert, move, and reference an Excel worksheet
- Discover how to format dates and numbers in Excel
- 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.
- Discover how to create awesome charts and graphs in Excel
- Learn practical methods to sort and filter your data using Microsoft Excel
- How to protect and secure your Excel data
- Working with dates and times in Microsoft Excel
- Averages, percentiles, and LINEST functions
- You’ll learn financial and statistical functions like calculating depreciation
- Learn to visualize your data using Sparklines, data bars and Pivot Charts in Excel
- How to import and export data to and from Excel
- Microsoft Excel desktop version for Windows installed and ready to use on your computer.
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
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
15-hours of videotutorials
Over 150 individual video lectures
Exercise filesto 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.
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.
DOWNLOAD -
