What you’ll learn
Excel fundamentals.
Data entry and editing using different formats
Calculating with formulas and functions
How to format and optimize spreadsheets.
How to manage spreadsheets using Filter and Sort data capabilities
Previewing and printing
Basic charts can be a great way of visualizing data.
Excel basics: spreadsheet management and data wrangling.
This Excel course will provide you with a solid foundation so you can organize, analyze and work with data. You will learn essential Excel skills like managing and wrangling your data and data analysis.
This course is designed for those with little or no Excel knowledge, as well as those who have some Excel skills but would like to improve. In six weeks, you’ll be able create charts and graphs with your data using Excel. For any company who wants to succeed, this course is essential.
What you’ll learn
Excel fundamentals.
Many formats are available for data entry and editing
Calculating with formulas and functions
How to format and optimize spreadsheets.
How to manage spreadsheets using Filter and Sort data capabilities
Previewing and printing
Basic charts can be a great way of visualizing data.
To support strategic decision-making, advanced data analysis, dashboard visualization, and data wrangling are possible.
This advanced Excel course builds on the lessons from Course 1: Core foundations, and Course 2 Data management. This course is designed for Excel professionals who are comfortable with extracting insights from large quantities of data.
No matter whether you’re processing numbers for your personal or business purposes, it doesn’t really matter what. Understanding how to interpret data is essential. This course will give you the competitive edge and value your company requires. Learn how to extract valuable organizational intelligence from raw data, and present it visually. Excel can be used to create powerful dashboards and complex spreadsheet designs.
What you’ll learn
How to use advanced formulas, conditional logic.
How to analyze and report data regularly
Automate repetitive and complex tasks
How to perform advanced data analysis, collaborate on workbooks with other users, and automate workbooks
Protecting your workbooks.
Formula Audits and Data Validation
UseVisual Basic to create macros.
Advanced Charting Techniques to create professional dashboards
Basic data analysis and Excel spreadsheet basics. This course will teach students how to use Excel spreadsheets for data analysis.
Students will learn the basics of Excel spreadsheets and basic analysis. The course ends with an assignment that will help you put your learnings into action.
Excel is an essential tool to work with data for marketing, business and research. This course is designed for individuals who want to be Data Scientists or Data Analytics professionals. It also serves those who just need to use Excel to perform data analysis in their company.