Master Microsoft Excel 2019/365 - Advanced Excel udemy course free download
What you'll learn:
Master Excel 2019/365 with this Beginner to Advanced Bundle – Course Site
- Discover new and improved features in Excel 2019
- Learn to master data analysis tools like Pivot tables, Slicers, Sparklines and Data Bars in Excel
- How 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
- Discover the essentials of using formulas 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
Requirements::
- Microsoft Excel desktop version for Windows installed and ready to use on your computer.
Description:
**This course includes practice exercises and LIFETIME access**
Get beyond the basics and supercharge your current Excel skills.
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 2016
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***
This course includes:
8-hours of video tutorials
Over 55 individual video lectures
Exercise files to practice what you learned
Demo files used by the trainer
Certificate of completion
This course is designed for students that already have a good understanding of Microsoft Excel and are looking to take their capabilities to the next level.
Contents and Overview
Through 57 lectures and over 8-hours of content, this course will take you through learning how to use the most business-relevant advanced functions and formulas you might need. This includes:
Financial functions (interest depreciation etc.)
Statistical functions
How to best visualize your data using PivotTables and Pivot Charts
Advanced charting
And so much more...
Upon completion of this course, 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.
Here’s what our students 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
★★★★★ “Everything is thoroughly explained in a clear and concise way, starting from the very beginning so that anyone without any prior knowledge of the programme can easily follow the explanations.
I would recommend this course to anyone that would like to get started on learning Excel or reinforce the basics of using the software, since this course covers concepts that can be useful to anyone without any prior training.”
- Blanca Estaban
Did 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!
Who this course is for:
- Users with basic knowledge of Excel 2019/365 and those upgrading from previous software versions
- Users who have a foundation of Microsoft Excel and seeking to advance their Excel 2019/365 knowledge.
Course Details:
- 11 hours on-demand video
- 4 articles
- 4 downloadable resources
- Full lifetime access
- Access on mobile and TV
- Certificate of completion