One of the most challenging aspects of Excel is working with dates and times. It's certainly one of the most common topics I get asked about. Download my comprehensive Excel workbook and PDF that covers EVERYTHING you need to know about working with dates and time in Excel.
Following are the tricks you can do with the features Excel tables offer. Following list is in no particular order. I think all of them are handy that every excel user must know to make his/her work more easy. As there are more than 20 tricks you can perform with tables, the whole article has […]
These free websites and online tutors will take you from an Excel beginner to a spreadsheet master.
7 Quick Conversion Methods – Excel to PDF & PDF to Excel Excel and PDF are the two most popular file types and you might need to convert one format to another from time to time. This tutorial will cover exactly that - How to Convert Excel to PDF or PDF to Excel. PDF files...
Create Bingo game cards using Excel! This short Excel tutorial shows you how to make bingo cards that you can customize for any theme
Three core functions of Excel Excel is a necessity of every office now. And since its first version we all have reasons to love it more every year and for the same reasons almost everyone (engineers, managers, medical reps, mathematicians, accountants and the list is really long) needs to be acquainted with Excel. However, Excel’s […]
Could you use a free spreadsheet lesson to use with your students? Look no further! The instructions below are from TechnoSales. TechnoSales is a
Excel Power Query is one of the most powerful new features within Microsoft Excel and the easiest to learn. It was first introduced as an Excel add-in in 2013 and was then made available in Excel 2010. In Excel 2016 it was renamed to Get & Transform and was available (without using an add-in) under the...
If you have several excel sheets to work on and all the sheets share exactly the same data with exactly the same format. Than instead of copying and pasting the same data on different sheets we have a much better way for you do to do this in Excel. Have the workbook open, press and […]
Excel Power Query is one of the most powerful new features within Microsoft Excel and the easiest to learn. It was first introduced as an Excel add-in in 2013 and was then made available in Excel 2010. In Excel 2016 it was renamed to Get & Transform and was available (without using an add-in) under the...
Advanced Excel Formulas & Functions are a must know feature in Microsoft Excel that allows you to quickly analyze your data in many forms. Once you learn how to construct Excel Formulas & Functions, your Excel skills & level will increase exponentially. Below you will find 101 Excel formulas & functions examples for key formulas...
Let me show you how easy it is to Create Form in Excel for Data Entry without using VBA! Click to view this free Excel Data Entry Form tutorial now!
This tutorial explain how to use VLOOKUP in Excel to help you learn formula with VLOOKUP examples, fix common VLOOKUP ERRORS including advanced VLOOKUP uses
Content published by the Microsoft Education team and community.
Learn Excel Online with this Free Excel Course covering 77 Excel Lessons. Absolutely FREE Excel training and no sign-up needed!
In Excel workbook Power Query, you can consolidate multiple Excel workbooks into one in a couple of minutes! Click here to read our step by step guide.
Oops, this page was not found! No worries, as here are our Top EXCEL RESOURCES.... 333 Excel Shortcuts for Windows and Mac 101 Excel Formulas & Functions
Last year the cup stack was one of my FAVORITE team building activities (see post here). So, naturally, I wanted to give it another shot! The Cup Stack is a fun, yet challenging activity that promotes team work. The supplies are basic: cups, string, rubber bands. I go ahead and tie the string to the rubber bands so it is ready to go. I make a few for groups of 4 and a few for groups of 5, this way no matter what the numbers are in the classroom I can make it work. I start by asking students what teamwork is. What does it look like? sound like? feel like? We brainstorm a list of ideas that I hang in the classroom for students to refer to. Each class comes up with a variety of ideas, but they all center around the same theme. Then I introduce their challenge. I start off my admitting that this will be a frustrating activity. We discuss ways to handle our stress and feelings that arise when others make a mistake or don't do what we want them to do. I model that they will each be given 6 cups and a rubberband with strings attached to it. Their job is to stack the cups into a design by only holding onto their individual string. I demonstrate that when everyone pulls on their string the rubberband opens wider, and vice versa. I also show them the challenges of picking up a cup that has tipped on its side or fallen on the floor. No matter what happens, they must follow the one rule: YOU CAN ONLY TOUCH YOUR STRING. No touching the rubber band, no touching the cup, and no touching other group member's strings. I reinforce how communication is so important in order to reach the goal. Then I set them off. Here are some videos and pics. After about 10-15 minutes, we pause and reflect on our experiences. I ask them to rate their group on how well they worked together using the ideas we wrote at the beginning of the lesson. I ask them what went well for their group. I also ask them what didn't go well for their group. We talk about different strategies and ways we an handle ourselves when things don't go the way we want them to. Throughout the activity I walk around and facilitate positive communication, so I usually have a few examples to help springboard the discussion.
I've got so many great resources for making multiplication facts so much fun for elementary students! Check out my blog post for details!
The ones who like to plan adores to-do lists as well. And if you are also the one who likes to strike a line or tick or dash or mark then this tutorial is for you. As I teach ACCA and other professional qualification students and at the same time teaching several subjects it is […]
Want to try one of my digital math activities for free? Click the link to grab the teacher version or student version.
Before in Excel tips we learnt about Custom Lists feature in Excel and how to use it to sort and have custom autofill series. In our example we sorted the sales data using our own criteria of cities that was not alphabetical. That helped us having data of cities first that are more important to […]
If you have several excel sheets to work on and all the sheets share exactly the same data with exactly the same format. Than instead of copying and pasting the same data on different sheets we have a much better way for you do to do this in Excel. Have the workbook open, press and […]
If you have several excel sheets to work on and all the sheets share exactly the same data with exactly the same format. Than instead of copying and pasting the same data on different sheets we have a much better way for you do to do this in Excel. Have the workbook open, press and […]
Following are the tricks you can do with the features Excel tables offer. Following list is in no particular order. I think all of them are handy that every excel user must know to make his/her work more easy. As there are more than 20 tricks you can perform with tables, the whole article has […]
Excel Power Query is one of the most powerful new features within Microsoft Excel and the easiest to learn. It was first introduced as an Excel add-in in 2013 and was then made available in Excel 2010. In Excel 2016 it was renamed to Get & Transform and was available (without using an add-in) under the...