Open this document up to work through the tasks to gain a better understanding of how you can use Excel. These tasks will be using the Microsoft O365 Online Excel.
Walk through the basics of Microsoft Excel. This will take you through the everyday beginner tasks and the elementary charting of your data.
Click here to see the practice data examples. Please make a copy and move to your own Google Drive, Desktop, or Microsoft 365 Account.
As we work through the basics of Excel feel free to use this data to help practice those tasks that you are trying to master. Remember to make a copy of this data from the Google Folder and then download it to your desktop or Microsoft 365 Online Account.
Being to lean some of the next level of using your Excel account to organziae and report out the data that you are collecting. Dive deeper into the formating and reporting of your data.
Self Guided Free Courses for Excel
Free Excel tutorial, lean how to create formulas and charts, use functions, format cells, and do more with your spreadsheets.
The target audience for the course are those who have never used Excel before and those who are beginner level users. The files are available for download and you can follow along the videos while practicing.
The course has 89 videos and runs for 9.5 hours.
Since this is a free course, Udemy does not offer certificates anymore
Learn more about formatting, filters and conditional formatting - they can improve the presentation of your spreadsheets with just a few clicks.
Create tables, PivotTables, Chart, PivotCharts and Sparklines - create analyses very quickly.
Find out how powerful Visual Basic for Applications (VBA) is - automate your code.
And learn functions such as SUM, SUMIF, VLOOKUP, OFFSET and iNDIRECT - translated into 15 different languages.
Video Guides for Excel
Getting Started
A runthrough of the basics of Excel.
How to use Formulas
A look at how to use formulas with your data.
Pivot Tables
How to create pivot tables to better review your data.
SCOE Badge Project
Show what you know and earn badges by demonstrating your understanding on the basics of Microsoft Excel.
