Excel and Google Spreadsheet is a basic skill today as it is needed for many jobs, from a sales manager to a data analyst. This tool is simple and very powerful at the same time as you can solve a bunch of issues in one place. This means that knowing what Excel has to offer would only benefit you and can help with career growth.
Why learn Excel and Google Spreadsheets
The main question you should always ask yourself is “Why do you need this?”; otherwise, your effort can be waste of time.
Excel is very useful for many tasks:
Data storage (text-based or numerical data) – it allows to keep a different kind of information in one place and do different operations with this data.
Data analysis – this tool offers a lot of functions to clean, filter, and modify the information so to get useful insights from it.
Math – it offers a huge number of mathematical operations which you can perform with your data; and those operations can also be combined and automated in different ways.
Visualization – with this tool, you can do different charts and graphs which provide visual answer to the data.
Collaboration – with Google Spreadsheets (which is the main online alternative to traditional Excel), many people can work simultaneously on one task in one document.
Excel skills by levels
Let’s start with what skills describe each level of knowledge:
This program by Coursera consists of three courses. The first one is for beginners and covers a number of beginner-to-advanced financial, logical, and text functions to data visualization. The second course reveals more advanced topics (advanced data management techniques and financial calculations in Excel and also includes advanced Excel tools like Data Tables, Goal Seek, and Solver Regression tool; this one shows how to perform “what-if” analyses and building predictive regression models. The last section is a project-based course.
The course consists of four sections where the first one gets you to the fundamental topics like Data Structures and Data Analysis Methods, while including also such interesting ones as Data Analysis in Context and Data Ethics. The next sections cover topics of essential functions (like creating pivot tables) and data visualization. The last course is Essential Mathematics for Data Analysis in Microsoft Excel, where students can learn common statistics and math functions. Moreover, it’s quite a business-focused course with practical assignments like Profitability Analysis and Finding Anomalies or final topics like Business Statistics and Business KPIs.
This course on Microsoft Excel consists of three sections, Exploring Data (a free one), Preparing Data, and Analyzing Data. The first section covers how to understand data and its types, clean it, and classify it. The second and the third sections show important functions like VLOOKUP, counting (different cases of using COUNTIF(s) functions), Math functions, logical and conditional operations, and other topics.
The course of 4 sections is designed for complete beginners and shows how to work with tables (filtering, sorting, calculations). Its feature is that there is in-depth coverage of pivot tables (3 out of 4 weeks are dedicated to this topic).
This course is designed to teach the main Excel alternative by Google – Google spreadsheets. The course covers such topics as data types and how to operate them, main data analysis with main functions (SUM, AVERAGE, and VLOOKUP), pivot tables, and data visualization (charts, dashboards, conditional formatting).
This class combines all the Google Sheets-related topics in one place. It covers main functions (VLOOKUP, INDEX & MATCH, FILTER & SORTN, SUMIFS, COUNTIFS, etc.), working with more advanced POWER QUERY function, creating pivot tables and charts, and finally (the most advanced topic), automating work with macros and Google Apps Script. By the way, Leila Gharani, the author of the course, has also an excellent Youtube channel, where she covers Excel issues.
This program includes 8 courses grouped by complexity (beginner, intermediate, and advanced levels). The first course is Recording and Managing Excel Macros (which is a good one for beginners to start with Excel automation). Four courses within the intermediate level are focused on logical, statistical, and lookup operations. The last section includes two courses for using Excel’s Visual Basic for Applications.
This is a set of 3 courses (the first two explain Visual Basic for Applications (VBA) and how to use it, and the last one is a project to practice). The first course shows how to create macros for the automation of routine Excel tasks and provides the basics of programming structures in VBA. The second one covers the essentials of working with arrays, text strings, and shows how to automate the import, modification, and consolidation of information from multiple worksheets. The third one is a project to implement the skills learned.
This one is focused on Power Query in Excel and also shows Power BI basics. It starts with the fundamentals of Power Query (why this function is powerful, how to transform, combine, and append data with PQ, etc). The second section proceeds to advanced techniques with Power Query (Power Pivot, merging data, advanced problem solving). It also includes practical assignments (like Report on HR Data).
Over 16 hours of video Over 200 workbooks included
This course consists of 4 weeks (1 week=1 topic). The first topic cover building relational models and visualizing data with PowerPivot. The second topic explains three important analytical methods: scenario analysis, sensitivity analysis, and simulation. The next two topics are focused on data visualization (starting with data visualization theory and finishes with creating charts and dashboards) and building interactive dashboards.