These practice exercises aren't just engaging they are actually fun. Through hands-on repetition and smart skills targeting, I've distilled all the skills I've learned from years of working with Excel to a program that can be completed in a matter of days. You'll also practice keyboard shortcuts on your own keyboard to build muscle memory and get faster at manipulating spreadsheets. We walk you through all the Excel functions that you need to know, forcing you to type through practice exercises to get hands-on and commit them to memory. That's just one of the ways Excel Exercises helps you learn more efficiently and maximize your practice time.Įxcel Exercises Solves the "Boring Video" Problem Each lesson is designed to keep you engaged and entertained while walking you through new concepts, so that you can't advance if you're not absorbing the information. There's a reason thousands of people are choosing to get their Excel practice from Excel Exercises: because it works. This is Excel practice for those who learn by doing, not by watching. Practice Excel the right way - in small, bite-sized, engaging lessons, rather than falling asleep reading a lengthy article or daydreaming through a long video. And without immediately putting the techniques from the videos into practice, I'd forget the techniques right after watching the video. I'd find myself zoning out and would need to rewind and re-watch each video two or three times. Like I mentioned before, I spent hours watching Excel training videos, but they were honestly kind of boring. I started wondering why there wasn't an easier and faster way to master Excel. It took me a few years of working in finance and consulting- using Excel nearly every day- to internalize all the keyboard shortcuts and functions. I watched several hours worth of Excel training videos, but found I didn't really master a formula until I actually got my hands dirty and used the formula at work. You can change this by right clicking on it and choosing which summaries to show.Welcome to the fun, hands-on way to learn Excel! My name is Jake and I'm known as a spreadsheet wizard around my office, but it wasn't a fast or easy process to get here. The status bar also shows quick summaries of selected cells (count, sum, average, minimum or maximum values). You can tell if Excel is busy calculating a formula, creating a pivot report or recording a macro by just looking at the status bar. Status bar: This tells us what is going on with Excel at any time. If you want to access other sheets, just click on the sheet name (or use the shortcut CTRL+Page Up or CTRL+Page Down).ĥ. To see more rows or columns you can use the scroll bars to the left or at bottom. But the spreadsheet grid shows few rows & columns of active spreadsheet. Each Excel file can contain several sheets. Spreadsheet Grid: This is where all your numbers, data, charts & drawings will go. You will understand the relevance of it once you start building formulas.Ĥ. Formula Bar: This is where any calculations or formulas you write will appear. The most important ribbons are – Home, Insert, Formulas, Page Layout & Data.ģ. Since Excel has 1000s of features, they are grouped in to several ribbons. It depicts all the features of Excel in easy to understand form. But you can add any feature of Excel to to Quick Access Toolbar so that you can easily access it from anywhere (hence the name).Ģ. When you start Excel for the very first time, it has only 3 icons (Save, Undo, Redo). Quick Access Toolbar: This is a place where all the important tools can be placed. There are 5 important areas in the screen.ġ. When you open Excel, this is how it looks.
So one of the basic survival skills is to understand how to navigate Excel and access the features you are looking for. It is very easy to get lost once you open Excel. Excel is a massive application with 1000s of features and 100s of ribbon (menu) commands.