Search 79,542 tutors
FIND TUTORS

Microsoft Excel Resources

Blogs

Ever had to figure out the total amounts received from all of your eBay sales in a year? Or when you should stock up your inventory for a list of product based on a 90-day cycle? Or simply converting an Excel date serial number to its appropriate date form? Here are a few useful formulas for the next time you encounter these and other similar challenges.   First of all, imagine... read more

Blogs

Hi everyone!   I have tutored students who take this class many times.  It is a very confusing class and teaches old concepts rarely used in business anymore, as the internet has changed how we use Excel and other data management tools. Further, it does not teach definitions of terms so it becomes difficult to look for information online.   I wanted to give some... read more

Blogs

I work for a Tag and Title Office and deal with numbers and stats all of the time.  One of my statistics files is set up so people who don't understand Excel at all can make entries into just a few cells throughout and the year, and at year end, I have dozens of ways to analyze productivity, accuracy, missed opportunity to serve customers and comparison one location's productivity to another... read more

Blogs

Did you know you can use Excel to let people to sign up for an event?  I use it every year for the staff Christmas party.  I email employees a link...they enter their information like whether or not they plan to bring a guest or what menu item they choose...and when they complete the form, their response comes back to you in email form.  You can have people submit one or two bits... read more

Blogs

You can generate email reminders based on almost any condition you can think of.  I use it at work to automatically open up at 10 a.m. on Wednesdays...check to see if employees' notary commissions are current...and send emails to those who are within 90 days or needing to renew.  Imagine the uses.  If you track anything and want to remind others it's time to take action, Excel has... read more

Blogs

Of course Excel lets you keep track of your members, their information, if their dues are current and how much they owe.  But did you know that in tandem with Outlook, you can get Excel to send your members email reminders about how much they owe?  Or you can thank them for paying promptly.  It's cool and easy using the VBA programming language that is a standard part of Excal....

Blogs

If you are using Excel 2007 or newer, did you know there's a way to save your files that makes them a fraction of the size?  When you save the file, choose the .xlsb format, and as long as the file is only intended to be opened in Excel (as opposed to generic spreadsheets), you lose no functionality and cut the size way down.  If you are the only one who uses your files, there is no... read more

Blogs

From business school to being in the corporate world for over 15 years, I've observed that majority of people 'feel' that they should be better with Microsoft Excel but are not.  Nevertheless, they never take the time to learn even the basics of this software and are struggling for hours with some simple work that should take them a couple of minutes to complete.    For... read more

Blogs

Microsoft Office is suite of programs used around the world for office and school work.  The Office suite includes Excel, Word, and PowerPoint.  One of the advantages of using these programs is that they have a lot of features, and you can use them to create a variety of projects in many different styles and formats.  Another advantage is that many of the shortcuts that work in... read more

1 2 3 4 5