What you'll learn:
- The Ultimate Microsoft Excel Course - Master Microsoft Excel - formulas and functions - shortcuts and tips - charts and graphs - for beginners to advanced users
- Taught by a best-selling Udemy author, Udemy Instructor Partner, Microsoft Certified Educator, Microsoft Office Specialist Expert, & Tenured College Professor
- From the fundamentals to the most advanced features, this training covers everything about Microsoft Excel including automation & VBA programming
- Presented with high-quality video lectures, this Microsoft Excel comprehensive course will visually show you how to do everything in Excel
- 128 page course outline included with the course, along with lifetime access, allowing you to review material at any time and learn new material
- Hands-on exercises with video solutions, including all Excel files, allow you to apply what you are learning and grow your abilities with Microsoft Excel
- Extensive coverage of Excel functions & the Top 10 functions: SUM, IF, LOOKUP, VLOOKUP, XLOOKUP, MATCH, CHOOSE, DATE, DAYS, FIND, FINDB, INDEX, AVERAGE, COUNT
- Excel charts, graphs, & sparklines - data visualization - conditional formatting - spreadsheet formatting - Excel tips & tricks - data entry shortcuts
- Data management & analysis - pivot tables - get & transform - power query editor - data validation - goal seek - macros & VBA (Visual Basic for Applications)
- Data cleaning and transformation - filter & sort data - formula tracing - learn to read Excel's documentation so that you are empowered to find answers
- Over 400,000 students taught, Lifetime course access, Hands-on exercises with solutions
- 100% satisfaction guaranteed, Learn at your own pace, This course is tested and proven
This is the Comprehensive Excel Course.
This course covers everything there is to know about Microsoft Excel.
From the fundamentals, to the most advanced features, after taking this class you will be able to use Microsoft Excel at an expert level.
Beginners can begin right at the beginning, then work their way through the course to achieve mastery. Intermediate users can join the course where needed to forward their skills. Advanced users can also drop into sections they need to achieve mastery.
You can learn Excel quickly if it is taught correctly. Developed by a …
Best-selling Udemy author
Microsoft Certified Educator
Microsoft Office Specialist Expert
Tenured College Professor
Udemy Instructor Partner
… this course has been designed and perfected to make it easy for you to master Microsoft Excel. Here are highlights of what you will learn in this course:
Learn to navigate around Excel
Learn to enter and edit data in Excel
Learn to adjust the way data and information are displayed in Excel
Learn to write formulas quickly and easily with the point-and-click method
Learn to use relative, absolute, and mixed references in Excel
Learn to create powerful calculations with Excel functions
Learn to use documentation so that you can work with every function
Learn to visually represent your data: charts, trendlines, sparklines, combo charts
Learn to use Excel data tools like sorting, subtotaling, and filtering
Learn to "freeze columns and rows" with freeze panes in Excel
Learn to remove duplicates from data in Excel
Learn to "transpose data" - switching the columns and rows in Excel
Learn to use Excel to leverage data with Pivot Tables & Pivot Charts
Learn to format worksheets including conditional formatting
Learn to automate Excel tasks with time-saving macros
Learn to integrate Microsoft Excel with Microsoft Word
Learn to use passwords in Excel to protect your work in multiple scenarios
Learn tips and tricks about Excel, as well as Excel secrets and shortcuts
Learn to use printing and sharing in Excel
Learn to harvest data from the web
Learn to create powerful random data generators
Learn to use freeze panes, sorting, filtering, & advanced filtering
Learn to "what if" sensitivity analysis such as goal seek, scenarios, & data tables
Learn to use multiple windows, selection panes, proofing, & translating tools
Learn to print your worksheets with various formatting to various formats including PDF
Learn to use pivot tables, slicers, timelines, & pivot charts
Learn to apply styles, themes, stats, accessibility, watch & calculation options
Learn to use get & transform and the power query editor
Learn to use the data model and to create relationships between your data
Learn to work with data joins and to append data
Learn to use 3D maps and to create recorded scenes
Learn to program Microsoft Excel with VBA (Visual Basic for Applications)
Download all of the Excel project files that are used in the videos
Described as “fun,” “amazing,” and “life changing,” this Excel training will forever transform the way you work with numbers. Try this course for yourself and see how quickly and easily you too can master Microsoft Excel.
