Getting started with Microsoft Excel
You will learn everything basic about Microsoft Excel. This program is wonderful to work with numbers, analytics, tables and create inventories. It is a program that facilitates our work to keep everything in order
Work Smarter with Microsoft Excel
This course is intended for learners with some experience using Microsoft Windows, who are seeking to build presentation skills with Microsoft Excel. To be successful in this course you should have an understanding of the basics of using a Windows-based computer. Experience with printing and using a web browser are an asset, but not required.
Excel Skills for Business Specialization
This specialization is intended for anyone who seeks to develop one of the most critical and fundamental digital skills today. Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces across the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. In the United States alone, millions of job advertisements requiring Excel skills are posted every day. Research by Burning Glass Technologies and Capital One shows that digital skills lead to higher income and better employment opportunities. At a time when digital skills jobs are growing much faster than non-digital jobs, completing this specialization will position you way ahead of others.
Excel for Beginners: Introduction to Spreadsheets
This 1-hour, project-based course is an introduction to spreadsheets. We’ll be using Excel on the Web in this project, which is the free spreadsheet program offered by Microsoft. However, all of the concepts that you will learn in this project will be applicable to other spreadsheet programs, such as LibreOffice Calc and Google Sheets
Excel for Beginners: Advanced Functions
This 1-hour, project-based course introduces learners to more-advanced spreadsheet functions. We’ll be using Excel on the Web in this project, which is the free spreadsheet program offered by Microsoft. However, all of the concepts that you will learn in this project will be applicable to other spreadsheet programs, such as LibreOffice Calc and Google Sheets.
Using Advanced Formulas and Functions in Excel
In this project, you will learn the advanced formulas and functions in Excel to perform analysis on several different topics. First, we will review basic formulas and functions and take a tour through the many choices in the Excel Formulas tab. Then we will explore the advanced financial formulas and functions followed by logic and text. Last, we will learn many ways to perform lookup and reference type queries. Throughout the project, you will work through some examples that will show you how to apply the formulas and functions you have learned.
Create a Project Management Tracker using Microsoft Excel
As a small business owner, budgets are often tight for the “extras.” Often times, this means that some of those high-value marketing tools cannot be offered. Small business owners should turn to free or low-cost alternatives. An easy-to-use and manageable alternative is a free online version of Microsoft Excel from Microsoft Office 365. In this project, you will learn how to create a simple project management tracking sheet.
Create a Simple Gantt Chart using Microsoft Excel
By the end of this project, you will be able to create a simple Gantt chart to manage your next project. You will utilize the free online version of Microsoft Excel to create a Gantt chart from scratch. This Gantt chart will give you a better idea of how bar charts and conditional formatting work. This guide will incorporate some Excel functions to teach you how to use conditional formatting to make your chart and data interactive. In addition, this Gantt chart will allow you to track multiple tasks that run parallel with each other, and will incorporate some unique features such as a weekly view bar to organize dates more efficiently.
IBM Data Analytics with Excel and R
This Professional Certificate is intended for anyone who is seeking to develop the job-ready skills, tools, and portfolio for an entry-level data analyst or data scientist position. Through these eight online courses, you will dive into the role of a data analyst or data scientist and develop the essential skills you need work with a range of data sources and apply powerful tools, including Excel, Cognos Analytics, and the R programming language, towards becoming a data driven practitioner, and gaining a competitive edge in the job market.
Excel to MySQL: Analytic Techniques for Business Specialization
In this Specialization, you’ll learn to frame business challenges as data questions. You’ll use powerful tools and methods such as Excel, Tableau, and MySQL to analyze data, create forecasts and models, design visualizations, and communicate your insights. In the final Capstone Project, you’ll apply your skills to explore and justify improvements to a real-world business process.
Using Basic Formulas and Functions in Microsoft Excel
Have you started using spreadsheets like Excel and want to learn how to write formulas and functions to perform simple data analysis? In this project, you will learn about the general format for writing formulas and functions in Excel to perform analysis on the sales data from a sample company. In this analysis, you will calculate total sums of profits, you will learn how to use functions to analyze the popularity of the items sold and you will also learn how to calculate averages and percentages of monthly profits. Throughout the project, you will work through some examples that will show you how to apply the formulas and functions you have learned.
Excel for Beginners: Pivot Tables
This 1-hour, project-based course introduces learners to the powerful pivot table feature of most spreadsheet applications. We’ll be using Excel on the Web in this project, which is the free spreadsheet application offered by Microsoft. However, many of the concepts that you will learn in this project will be applicable to other spreadsheet programs, such as LibreOffice Calc and Google Sheets.
Excel/VBA for Creative Problem-Solving Specialization
This Specialization is for learners wishing to dramatically change the way that they use Excel spreadsheets by unleashing the power to automate and optimize spreadsheets using Visual Basic for Applications (VBA). The first two courses will teach learners the basics of VBA through the use of dozens of educational screencasts and a series of quizzes and in-application programming assignments. Finally, in Part 3 of the course, learners will complete 3 “real world” and somewhat open ended projects, which are graded through peer review.
Excel Skills for Business: Advanced
Spreadsheet software remains one of the most ubiquitous pieces of software used in workplaces around the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. Across the globe, millions of job advertisements requiring Excel skills are posted every day. At a time when digital skills jobs are growing much faster than non-digital jobs, completing this course will position you ahead of others, so keep reading.
Create a budget with Microsoft Excel
In this project, you will learn how to create a budget using Microsoft Excel. This program is terrific for working with numbers and tables and creating budgets. It is a program that facilitates our work to keep everything in order. You will complete different tasks to understand and use the Microsoft Excel tool.
Create a Simple Project Timeline in Microsoft Excel
By the end of this project, you will create a free account on Microsoft 365, get access to Microsoft Excel, define a project, understand what elements need to be identified and documented before creating a project timeline, and also understand the importance of a project time. Your new skills will help you track your project timeline both for personal and professional purposes.
Create a Financial Statement using Microsoft Excel
By the end of this project, you will be able to complete a financial statement with Microsoft Excel, composed of a transactions page, profit and loss statement, and balance sheet. You will learn how to enter your business transactions and interpret the data presented in the profit and loss statement. You will also learn about the components of a balance sheet and will have a better understanding of how a financial statement can be used to help track and present financial information for your company.
Introduction to Data Analysis using Microsoft Excel
In this project, you will learn the foundation of data analysis with Microsoft Excel using sales data from a sample company. You will learn how to use sorting and filtering tools to reorganize your data and access specific information about your data. You will also learn about the use of functions like IF and VLOOKUP functions to create new data and relate data from different tables. Finally, you will learn how to create PivotTables to summarize and look at comparisons within your data. These skills will help you efficiently perform data analysis on many different types of data and give you the foundation to expand your toolbox as you explore other strategies for data analysis.
Excel Basics for Data Analysis
Spreadsheet tools like Excel are an essential tool for working with data — whether for data analytics, business, marketing, or research. This course is designed to give you a basic working knowledge of Excel and how to use it for analyzing data.
Data Visualization with Advanced Excel
In this course, you will get hands-on instruction of advanced Excel 2013 functions. You’ll learn to use PowerPivot to build databases and data models. We’ll show you how to perform different types of scenario and simulation analysis and you’ll have an opportunity to practice these skills by leveraging some of Excel’s built in tools including, solver, data tables, scenario manager and goal seek. In the second half of the course, will cover how to visualize data, tell a story and explore data by reviewing core principles of data visualization and dashboarding. You’ll use Excel to build complex graphs and Power View reports and then start to combine them into dynamic dashboards.
Create Charts and Dashboards Using Microsoft Excel
In this project, you will learn how to create charts in Microsoft Excel to analyze sales data of a sample company. You will learn how to create PivotTables to assess different aspects of the sales information, and represent the information from the tables as line, bar, and pie charts. When creating the charts, you will learn how to format them so they are easily interpreted and you will then assemble the charts in a dashboard to provide a global picture of the sales data.
Charts, Pictures, Themes, and Styles in Microsoft Excel
By the end of this project, you will create a free account on Microsoft 365, get access to Microsoft Excel, and will create a workbook with charts, pictures, themes, and styles. Your new skills will help you manage information in Microsoft Excel in the most efficient way.
Excel Skills for Business Forecasting Specialization
The current state of the world makes business forecasting even more fundamental to the operation of institutions. In this Specialization we focus on Excel Skills for Business Forecasting in three courses — Time Series Models, Regression Models, and Judgmental Forecasting.
Custom & Conditional Formatting in Microsoft Excel
At the end of this project, you will be able to customize your formatting in Microsoft Excel. You will also be able to use basic conditional formatting to ensure a seamless use of Microsoft Excel and to highlight important sections of your sheet. Being able to use custom and conditional formatting in Microsoft Excel will allow you to make sense of the data quickly. This allows you to visualize your data and make it easier for you and for others to understand the data. This becomes more important the more data is contained in the sheet.
Create Customer Support Data with Microsoft Excel
By the end of this project, you will create a free account on Microsoft 365, get access to Microsoft Excel, and create a table with customer data. You will edit and format the data, hide sensitive information, sort, and filter data. Your new skills will help you manage your customer relations and be more efficient.
How to Use Lookup Reference Math and Text Functions in Excel
By the end of this project, you will learn how to use lookup reference, math and text functions in an Excel Spreadsheet by using a free version of Microsoft Office Excel.
Please note that this article contains affiliate links.