Free Microsoft Excel online courses
Practically every day we use some of the applications that Microsoft offers us, some are simpler and others more complex, but of course the software ofOffice, and, specifically, how to use Excel and its spreadsheets, whether in its basic version, at the intermediate or advanced level.
For some of us it is essential to know its use for daily work. So… why not take advantage of the free opportunities that the Internet offers us to train ourselves?
We have compiled a selection of the best 2022 courses with the aim of helping the Microsoft Excel learning Always looking for informational quality and high-level teaching, both in the documentation provided, as well as in the relevant videos or seriousness.
They are both courses from Universities in MOOC (Massive Open On-line Course), as well as specialized platforms or Microsoft itself, taught in Spanish and online, so we no longer have an excuse to start any Excel course online nor by the level that we may need, since the selection that we have practiced is varied.
NOTE: Each of the following courses has a link in the style of "we can register from HERE" that will take you to an external website to be able to sign up for the corresponding course (We do not carry out training, we only inform about the existence of the courses).
Excel online courses
The matter we have searched for free Excel program training goes from a basic level to an advanced one allowinglearn about spreadsheet application from the comfort of being at home or wherever, and they are:
- Advanced Excel for Data Analysis (New)
- Basic Excel: Fundamentals and Tools
- Excel for data management
- Advanced Excel: data import and analysis
- Data Analysis: Dashboard Design and Visualization
- Data analysis: Take it to the MAX ()
- Master Office (New courses)
- Excel applied to business (New)
- Excel from Academica
In addition, at the end of the article there are two Bonuses: Try the Excel for free plus the complete course from Microsoft.
1.- Advanced Excel with data analysis
New Excel course to learn the use of dashboards, layout and visualization from the University of Delft. With a duration of 8 weeks (4-5 hours per week).
- Bringing your data to life through types of visualizations known as line and bar charts and new types of visualizations like trend lines, surface charts, and population pyramids.
- How to create impressive Microsoft Excel dashboards based on real data that can meet business and management needs.
- How to connect data from different sites; from the web or extracts from your CRM, ERP, SAP or datawarehouse.
- Data science and how to use viable analysis tools.
- Delve into Pivot Tables and introduce new tools for data analysis.
The course starts at the end of this month and we can register from HERE.
2.- Basic Excel: fundamentals and tools
In this Excel basic course You will learn the most common tools, from the most basic to graphs, formulas, functions, and data tables. Will study the capabilities of this microsoft program from a beginner level.
What will you learn in this Basic Excel online course?
- How to get started with it microsoft software and perform basic operations using formulas when performing accounting and financial tasks.
- Manage Excel formats and represent results.
- Use graphics and generate their analysis.
- What families of functions do we have and what are the most valued and used Excel formulas?
- Organize and manage data tables.
- The excel tools that are used most frequently.
- Basic knowledge about use for academic and professional purposes.
To register access from HERE.
3.- Excel for data management
In thisexcel course online It will delve into the techniques and tools for data management, treatment and analysis that you can use in Microsoft Excel for decision making.
What will you learn?
- How to create templates and link external data.
- How to group data in tables to extract information that helps you make smart decisions.
- Use dynamic charts and graphs to extract and present information with the help of this Microsoft software.
- A hypothesis analysis for better decision making according to needs.
- Learn data conversion utilities.
To register access from HERE.
4.- Advanced Excel: data analysis and import
In this course Microsoft Excel It is to learn the technical tools and advanced strategies to import, to consolidate and visualize with Excel data from any source that occurs to us.
What will you learn?
- How to do data preprocessing with advanced text editors to eliminate import problems.
- How should we use the Powerquery tools data import into Excel, the latest versions are included to automate the information intake process.
- How to use strategies to group, diverse functions and consolidate the data in a way that gives us the information we need and can use it intelligently.
- How to use the functions provided by the Powerpivot and the data model integrated in the new versions of Excel to work with data and multiple tables with millions of records in the Big Data style
- How to use advanced functions of tables, cutters and pivot charts in Excel.
To register access from HERE.
5.- Data analysis: Dashboard Design and Visualization
Is training is aimed at learninghow to transform data raw, with the use of tables in Excel, to support decisions from a business perspective.
What will you learn in this free online excel course?
- How to bring data to life through the different types of visualizations known as line lines, bars, and new types of visualizations like trend lines, surface charts, and population pyramids.
- How to create different dashboards in Microsoft Excel.
- How to connect data from different sources, such as from a website and extracts from your CRM, ERP, SAP or datawarehouse.
- Data science practices and how to use viable analysis tools.
- It also delves into tools such as Pivot Tables and introduces new tools for information analysis.
To register access from HERE.
6.- Data analysis: Take it to the MAX ()
East data analysis course free high level (business intelligence: BI) and for all those who want to improve their skills in analytics. Looking for a smart way to visualize information so it makes sense? Do you want to understand that collection of data that your boss gave you? Do you have many megabytes of information to analyze? Don't worry, we've got you covered! …
What will you learn?
- Overcome challenges in the data analytics in your research or work.
- Increase productivity or make better decisions in potential deals with data analysis techniques
- Improve your skills and production of data analysis using spreadsheets.
- Advanced possibilities on spreadsheets such as matrix formulas or pivot tables.
- Characteristics of Excel 2013 as PowerPivot and PowerMap.
- Use Python to parse and manipulate all kinds of references.
- How to evaluate and organize your spreadsheets
To register access from HERE.
Remember that you can see all the capabilities of the latest version of the Microsoft Office office suite, be it Excel 2013 or 2016 … and also try it for free from HERE. With explanatory videos, manuals and tutorials from HERE the official page.
And if it doesn't quite convince, we recently also publishedtotally free online courses of interest to the community:
- Course on cities in crisis and new urban policies
- Course on formwork and falsework
- 10 free courses for architects and engineers
7.- Master Office with the UNAM
We have recently encountered some free Microsoft Office courses very complete run by the National Autonomous University of Mexico (UNAM) which has recently created a complementary training platform, and totally free. All three courses are about Microsoft Excel, Microsoft Word and Power Point.
- Microsoft Excel course: Management and organization of daily activities (30 Hours)
- Microsoft Word: Management and organization of text tools (20 Hours)
- Power Point: Prepare presentations of all kinds with multimedia resources in a simple and practical way (30 Hours)
You have to access the University training platform from here. Register, search for courses and start training. Totally free!
8.- Excel applied to business
From the Austral University they have launched a training of 10 modules whose objectives are:
General Objectives: At the end of the course, you will be able to:
- Understand and deepen specific aspects of different forms of work (group and individual).
- The use of advanced functions with the intention of manipulating data and CREATING your own analyzes using specific techniques such as pivot tables, hypothesis analysis, scenario management, single and double entry tables, resource optimization analysis.
- How to link Excel with other applications by importing information from text files and databases, exporting information to text files in various ways.
- Understand the use of macros in applications that will make your work much more productive.
We can sign up for free training from HERE.
9.- Excel from the Academic platform
The Academic platform is a digital community that disseminates free knowledge through the Carlos Slim Foundation and the TELMEX TELCEL Foundation we have found a advanced Excel course by 2022 with a duration of 16 hours and taught over a month. The agenda is based on:
- Filtering data series
- Formulas and functions
- Dynamic tables
- Dynamic graphics
NOTE: We have verified that access to the course is closed but, a year they launch several calls that are tutored. In addition, there are other training offers that may be interesting. We can consult more information from Academica.
Bonus 1: Learn Excel with LinkedIn
Of the options that the network provides us and of the little known ones to improve our training, there is the LinkedIn platform that not only serves to increase our contacts, but we can also practice online teaching where the first month is free from LinkedIn Learning.
Actually, as we can see in the previous image, there are many excel videos to learn; tables, tricks, advanced options, working with multiple sheets, management, forms, functions, etc. With beginner, intermediate and advanced levels. To try from HERE.
Another quick way to find training on Linkedin about Excel is from our profile. We just have to put "free excel courses" in the search engine and you will see the latest user activities with hundreds of proposals, such as the following image:
Bonus 2: Training in Excel with Udemy totally free
We keep looking at the big training platforms. In this case, we are focusing on Udemy, because it has a free training section, and there is a lot to look at. Look at the following image:
We must access from this link but we must bear in mind that:
- You do not have to browse the platform, it will be difficult for us to find the free training even if we apply "Spanish" filters and the "Free" price.
- Click on the cursor as we see in the previous image (The courses will appear in Spanish first, and then in English)
Try Office 365 for free
Sometimes we get to work and learn like crazy but we don't remember that Microsoft excel online give us one one month free trial with unlimited access to all extensions of the latest version of Office 365, which includes cloud access to the latest Office applications with access features; Word, Excel, PowerPoint, Outlook, OneNote… etc.
The only thing we need to register is a Hotmail account and go to the platform HERE … (We can see the following image), we will get access to a excel online free and with the latest version of the application:
And also, for those interested, the platform itself Microsoft has a training section free in Spanish where we have so much access to documentation, a forum or videos that we can access from HERE, and we will see:
Of course, we no longer have an excuse to train by having access to Office software free for one month. The only thing we need is desire and of course, time!
If you liked this article, share it!
