Microsoft Excel A to Z: Boost Office Productivity & Reports udemy course free download
What you'll learn:
Microsoft Excel and Google Sheets for Data Analysis
-
Knowledge of all the essential Microsoft Excel and Google Sheets functions
-
Master Microsoft Excel and Google Sheets’ most popular lookup functions such as Vlookup, Hlookup, Index, and Match
-
Become proficient in Microsoft Excel and Google Sheets data tools like Sorting, Filtering, Data validations, and Data importing
-
Harness the potential of Microsoft Excel and Google Sheets by creating Pivot tables with slicers
-
Visually enchant viewers using Bar charts, Scatter Plots, and Histograms in Microsoft Excel and Google Sheets.
-
Make great presentations using the Conditional and Table formatting options in both Microsoft Excel and Google Sheets
Requirements::
-
You will need a PC with a working internet connection
Description:
Microsoft Excel and Google Sheets are powerful applications that allow you to create sophisticated spreadsheets. They can help you organize, analyze, and understand your business's most important data.
In this 2-in-1 course, we'll cover everything you need to know to master both Google Sheets and Microsoft Excel. Using these two applications, you'll learn how to create supercharged spreadsheets with sophisticated functions and visualizations that will allow you to speed up data analysis and communicate actionable findings with your team.
Follow along as we go through the exercises, and use multiple spreadsheets to practice your new and exciting skills.
At the end of this course, you’ll be able to master:
-
Sorting and filtering data, filtering views, publishing files, and other data preparation tasks.
-
Increasing productivity by using different data types, formatting cells, formulas, and other advanced techniques.
-
Creating sales sheets, printable invoice templates, pivot tables, and charts for sales statistics.
-
Creating Google spreadsheet scripts to perform programmable actions.
-
Working faster with keyboard shortcuts and techniques.
Now the real office productivity begins! Learn Excel and Google Sheets from the ground up!
This course offers 67 lessons with more than 10 hours of video content, multiple assignments and real-life projects.
About the Instructor
This course is ministered by Ivan Lourenço Gomes, a top-rated Udemy instructor, famous for his easy-to-follow and hands-on teaching style. Ivan has more than 16 years of experience working for multinational companies and has ever since used Microsoft Excel and more recently Google Spreadsheets to boost the productivity and data analysis of his team.
Enroll now and master these wonderful tools for businesses and individuals.
Who this course is for:
- Professionals of any business career seeking to master Microsoft Excel and Google Spreadsheets
- Sales managers and employees willing to improve the control over sales data and reports
- Any person willing to improve their Microsoft Excel skills for usage in many different applications
Course Details:
- 10.5 hours on-demand video
- 27 downloadable resources
- Access on mobile and TV
- Certificate of completion