Microsoft Excel is the industry standard spreadsheet program used for data calculations, analysis, visualization and much more. It can be programmed to access data from external databases and is an excellent tool for data modeling, statistics and financial calculations with built-in functions to quickly and easily perform common tasks. Proficiency in Excel is typically required for accounting, business analytics, data analysis and statistics jobs.
Microsoft offers free Excel classes online on edX to learn both fundamental and advanced Excel skills. Introduction to Data Analysis using Excel is a 4-week, self-paced online course perfect for learners with little or no prior experience using the software. Learn how to set up an Excel sheet, perform calculations, use basic and advanced Excel formulas and create visual representations of data with charts and graphs. Learn how to quickly create different views of data with pivot tables and much more, directly from the Excel team at Microsoft.
Additional Excel training courses explore the more advanced statistics and data visualization features of the software. Learn about descriptive statistics, basic probability, random variables, Excel VBA, sampling and hypothesis testing. Perform data mashups and visualizations using data pulled from multiple sources. Some other elements you will learn on Microsoft Excel include conditional formatting, pivot tables, keyword shortcuts, and more. The advanced features courses are part of the Microsoft Professional Program Certificate in Data Science, a specialization designed to get learners on a path to a career in data science or related field. If you've been looking to learn Excel, you've come to the right place.
To give you an idea of the vast popularity of Excel among employers, a recent keyword search of “Excel” on Indeed.com produced almost 600,000 results. Excel skills are marketable in almost every industry and consistently rank near the top of the list of most important skills to add to your CV. Whether you’re in healthcare, IT, finance, business intelligence or computer science, taking an Excel tutorial or short online Excel course to learn the latest features can boost your performance. Learning Microsoft Excel can be a skill that applies to most business operations. EdX also offers advanced excel training courses to help promote your skill set to the next level.