In this Blog, you'll learn five Excel tips to improve speed and accuracy:
Excel Help Tip #1. Keyboard shortcuts: why breaking up with your mouse might be a good thing to do
Excel Help Tip #2. How to wrangle worksheets without frustration
Excel Help Tip #3. Ways to type less and get more done with AutoFill, AutoCorrect and Custom Lists
Excel Help Tip #4. How...
Creating a scatter plot after breaking some econometric data into two groups. Basic "White-belt" level.
How to do a multiple regression analysis of data in an Excel worksheet. If you have not done so already, you will need to add-in the analysis toolpak as described in that video. This video is basic "Yellow-belt" Excel.
Excel's built-in statistical functions can be supplemented with the Analysis Toolpak. If you are not sure how to load an Add-In into Excel, this video demonstrates the simple technique and shows you how to get started with the Analysis Toolpak....
Excel's Scenario Manager conveniently keeps track of several different sets of values that can be plugged into a worksheet to examine the consequence of changes. For example, we might want to examine growth under several potential changes in unemployment...
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...
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...
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...
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...
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...
After working with a few students in basic and advanced Microsoft Excel techniques, I've created a syllabus that I think will work for anyone trying to learn Excel. Complete with worksheets, tutorials, and homework assignments.
The following table contains a random sample of 40 women partitioned into three groups:
Group 1: ages below 20
Group 2: ages 20 through 40
Group 3: ages over 40
the values in the table...
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.
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...
Sometimes you need to repeat the data or formula from just one cell, and you don't want to bother with copy and paste.
You can quickly copy the contents of a cell to the cell just below it:
Click in the cell just below the cell you want to copy
Press CTRL + ' (apostrophe)
It's that simple!
Through the years, I have seen numerous reports that provided the reader with no useable information. Why you may ask? Because the report creator didn't understand the difference between data and information.
Data is a number; an answer; a disparate answer without focus or label. An example could be 7, apple, The Oscars.
Great, what does 7 mean? I know what an apple is, but what is the...
It is the mark of an educated mind to be able to entertain a thought without accepting it. (Aristotle)
This quote provokes me never to accept the status quo and always challenge assumptions. It is the thought that through education we never stop learning or seeking after truth and knowledge.
The IRS have opened up form 8863 Education Credit and you can file that form now.
Many other credits are still not ready and taxpayers await these in order to file. What is my opinion as a tax professional for 26 year? See below.
It is perfectly legal to plan your tax affairs to your advantage as long as you don't break Tax Law. Many people don't know this. Some avoid...
Hello! This whole site is pretty new to me, but I wanted to briefly show my interests and experiences, as they are fairly diversified:
Sciences: As noted above, most of my experience is with chemistry. Organic Chemistry is my specialty, but I am also familiar with Inorganic Chemistry. I've been a Teaching Assistant for college freshman level courses through upper level chemistry courses....