Description
Mastering Excel program is intended to make you Excel champion by acquiring the fundamentals of Excel spreadsheets to perform basic to advanced data analysis.
Core & Advanced Excel with Dashboard
MS Excel from beginner to Advance excel, Formulas, Chart tips and Tricks in MS Office and Office 365 including ChatGPT & Google Sheets.
This course is designed to teach you the basics of Microsoft Excel all the way to Excel mastery. It’s perfect for you if you are a beginner and want to increase your excel skills to impress your boss, get a raise or even land a new job. Everything in the course is taught step-by-step in an easy, stress-free way. The topics we have prepared will challenge you as you learn how to use advanced formula techniques. You will clean and prepare data for analysis, and learn how to work with excel functions.
What you will learn:
- Master Microsoft Excel from Beginner to Advanced
- Format sheets and charts professionally
- Learn new keyboard shortcuts and be even faster in Excel
- Use Cell Styles and format spreadsheets easier and faster
- Writing Formulas and performing Calculations
- Use Excel as a Database with Sort and Filter options
- Increase productivity with functions: IF, PMT, VLOOKUP, FIND, SEARCH, MATCH, INDEX and much more…
- Updated to include the new FILTER, XLOOKUP, SORT & UNIQUE functions
- Learn several hidden Excel tips and tricks
- Learn to use Pivot Tables, Pivot Charts, Slicers and Time Lines for Interactive Excel Reports.
- Learn to make Excel dashboards.
- Explore Google Sheets
- Learn Excel with ChatGPT