The =CONCATENATE(x) function is one of the LEAST heard of functions in all of Excel. It allows you to combine multiple cells into one cell. There is no limit to how many can be combined, so =CONCATENATE(A1," ",B1," ") will combinie A1 with B1, and place a blank space in between both cells - if they are words that require a space in between. Concatenate Away!
Thursday Excel Magic: If you have a data-set that is formatted incorrectly with capitalization, such as ALL CAPS, all lowercase, or MiXeD - You can use the =Proper(x), =UPPER(x) or =lower(x) to correct ANY capitalization issues - instead of manually re-typing
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 that you have a list of dates that you want to copy from another document into an Excel spreadsheet. You do your usual right-click + copy (or Ctrl + C), shift over to Excel, and right-click + paste (or Ctrl + V); and behold...a list of serial numbers came into view.
But I copied a list of dates, not serial numbers. You thought to yourself.
How do I fix this?
The answer to this is quite simple: Highlight the column where the data resides (i.e. Click on the column header "C" if the serial numbers are pasted into column C), go to the
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 definitions here that will help you at least search for help online:
In Excel, things that start with = are called "formulas".
A bunch of characters together are called a "string". Strings can have spaces and punctuation.
If you cut off a piece of a string (which is done using the LEFT, RIGHT, and MID formulas), that is called "parsing a string".
An "array" is a list of numbers or cells. Arrays have have a : in them, and mean STARTING CELL:ENDING CELL (like A1:A20).
Each formula has a name, and starts with = and the name, then has...
If you are in a profession where you must analyze data to turn it to information; or if you do such at home or at school Excel is the application for you. But sometime trying to learn Excel on your own, even with books, can be difficult. That's why an experienced tutor can be valuable, by offering you real world examples of using Excel, while providing basic and intermediate lessons on the application features.
Understanding the Excel Object Model is fundamental to understanding Excel’s structure and the relationship of these objects to each other. But understanding the tabs/ribbons are key to understanding and knowing where to find and how to apply features, setting, properties to Excel objects.
Formulas are what make spreadsheets worth-while. Formulas and built-in Functions bring Excel alive. When Excel is alive with formulas, functions, and code there are wonders to be observed while creating information from raw data. That is the real purpose of Excel, to store...
You already have some income but it is not enough. So you decide that you need some part time work to supplement your income. How many hours of part time work do you need if they pay you $35.0 an hour? What if your part time work only pays you $20.0? In my two hour specialized Excel class, I will show you power of Excel Data Tools to help you with above scenario and other help that Excel can offer. If there is additional time, we can go over Excel features such as Chart, etc. If you are not part timer, you can still use Excel to help you with personal finance.
Working out your accounting homework in Excel can be frustrating and tedious, especially for students just starting off their accounting coursework. You might think "hey, I can do this faster on paper with my calculator." But if you plan on getting past Financial Accounting, you're going to need to master this essential program, and homework is the best way to practice. Besides that, your professors will prefer it and in the long run your grade with thank you. Here's why:
1.) End of Term Projects
Just about every accounting class I've ever taken has had a hefty term project, usually a set of financial statements, and its always due in Excel/spreadsheet format. While you may be able to get through most of the semester turning in homework problems done in pencil, you don't want to be struggling with both excel and complex calculations when the deadline for your term project is looming and you are crunched for time. Learn it now, and spare yourself the stress...
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 most people, all it takes is some simple demonstration of the ease of the program and I've seen dramatic improvements in a very short amount of time. If you have ever felt this way, there are ways to get better and more comfortable. I welcome comments and questions regarding getting more comfortable with Excel.
If you are taking an online course, or have homework assignments that are on your computer, I have a method where I can view your computer, with your permission, while you are online with me, and see and even control your desktop from my mouse, at no cost to you other than my time.
We can talk over the phone, share desktops, as I can show you things from my desktop too, and get the session moving forward regardless of the distance between us. So if you are taking a vacation or a weekend trip and need some assistance, call me and I'll call you back for a free call, and we can work in this manner. I have done this many times in business and other categories. I haven't done it yet over an iPhone but, that's next I think.
Technology is great isn't it?