Basic Mathematics
Learning The Basics of Microsoft Excel Will Increase Business Efficiency by Jeanne Kolenda
Spreadsheets are one of the most useful tools in your business tool bag. Even if you never become an expert, just learning to use the raw, simple power of the basics of a software program such as Microsoft Excel will make a huge difference in your efficiency as a business owner or manager. There are other spreadsheet programs on the market, but Microsoft Excel or the Open Office equivalent is far and away the proverbial 800 lb. gorilla. Kind of like Google is when you talk about search engines.
What’s In a Spreadsheet?
A spreadsheet is comprised of cells in rows and columns that make an electronic grid where you can add numerical data of any kind – dates, currency, percentages, or just plain ol’ numbers. Managing varying types of numbers is a vital part of staying in business. Unless you have a huge client base, most of your basic tracking and accounting could be done in a spreadsheet if you have some basic skills to set it up. When you begin to increase the number of clients, and your inventory, you would need to think about migrating over the numbers to a true accounting software.
Here are some common uses of a spreadsheet for your business:
* Tracking expenses
* Recording new sales
* A record of prices
* Cash flow projections
* Keeping track of job times
* Tracking commissions due and paid
The Uses Are Limited Only By Your Imagination
As you read this list, I’m sure your wheels are turning, and you’re already thinking of many other ways you could use a spreadsheet. I own a voice messaging company and my “inventory” is phone numbers. My accounting software had no good way for me to tie a list of phone numbers to a particular client, especially when they added numbers, deleted numbers, etc., as the employees changed.
One of the first spreadsheets I ever learned to make was to keep track of what numbers were assigned to which customer. That was 17 years ago, and I still use that same spreadsheet. I cannot imagine running my business without it. I have another useful spreadsheet that tracks my recurring revenue. There is a certain element involved in this rather complex business that just isn’t handled the way I prefer in my accounting software, so a spreadsheet does the trick for me.
Text can be added to a spreadsheet as well as charts, graphs and even pictures. Microsoft Excel is probably one of my most heavily used programs, next to Word, of course!
Once you have entered your data, then the fun starts by making formulas with the basic mathematical functions such as addition, substraction, multiplication and division. To see what would happen if…just change the number in one cell and watch the magic take place. It’s a great way to dream of “what if…” and actually see the numbers come to life.
To receive a free 10-page report on Microsoft Office Tips, please visit http://MakeExcelWork.com I think you’ll really like what you see.
About the Author
Jeanne Kolenda is a partner in BusinessTrainingTeam.com, a company dedicated to training business owners and managers, as well as coaching and consulting, particularly in how to bring an offline business online. Her blog can be found at jeannekolenda.com
Basic Math: Lesson 1 – Numbers
|
|
Learn to Subtract: Basic Math fundamentals grades 2 thru 6 $5.70 BASIC MATH FUNDAMENTALS (grade 2 thru 6). 3-G Homevideo brings children a classroom-like video interactive program that updates the time tested 3 X 5 learning method of repitition of basic math problems. Each inteactive program includes the latest in compute graphics to entertain, and teach kids, on their own t.v., simple math problems that they watch, lay along with and have fun while learning to… |
|
|
Learn to Multiply: Basic Math fundamentals grades 2 thru 6 $3.95 BASIC MATH FUNDAMENTALS (grade 2 thru 6). 3-G Homevideo brings children a classroom-like video interactive program that updates the time tested 3 X 5 learning method of repitition of basic math problems. Each inteactive program includes the latest in compute graphics to entertain, and teach kids, on their own t.v., simple math problems that they watch, lay along with and have fun while learning to… |
|
|
Basic Math (The Teaching Company High School Series: SuperStar Teachers) $159.00 Basic Math is designed to instruct three different audiences. The first audience consists of students using this series at the outset of their study of arithmetic. Such a group may include children attending homeschool. The lessons are arranged sequentially to allow for logical development of the material. The second audience is comprised of students experiencing difficulty with elementary mathe… |
|
|
DEWALT Construction Professional Reference (Dewalt Trade Reference Series) $12.08 This outstanding “answer book” is the perfect professional reference for questions concerning basic building disciplines. The DEWALT Construction Professional Reference features at-a-glance information on hardware sizing, correct nailing patterns, walls and flooring, doors and door openings, roof pitches, stairway stringers, steel, excavation, masonry, and much more! With illustrative diagrams an… |
|
|
The 1st – 7th Grade Math Tutor – 7 Hour Course! – 2 DVD Set! – Learn By Examples! – Addition, Subtraction, Multiplication, Division, Fractions, Decimals, Percents & More! $21.95 The author has a BS and MS in Electrical Engineering and an MS in Physics. Other Titles Available By This Author: – The Math Video Tutor – Fractions Thru Algebra – 10 Hour Course!- 5 Hour Course! – The Calculus 1 & 2 Tutor – 8 Hour Course! – The Ultimate Physics Tutor – 11 Hour Course!… |
|
|
Math Video Tutor: Fractions Thru Algebra $16.25 IMPORTANT NOTE: This Algebra Product has been completely refilmed in 2012, greatly improving the Audio/Video quality of the production. The newly refilmed course is available on Amazon now under the following titles: – Algebra 1 Tutor: Volume 1 (ASIN B006S4D5BI) – Algebra 1 Tutor: Volume 2 (ASIN B006S4D59A) This product, “Math Video Tutor Fractions Thru Algebra” DVD, has been replaced by … |
|
|
The Probability and Statistics Tutor – 10 Hour Course – 3 DVD Set – Learn By Examples! $26.95 The Probability and Statistics Tutor is a 10 hour video course that teaches the student how to tackle probability and statistics through fully worked example problems. Most students have problems with probability because almost every problem is a word problem. This requires the student to read the problem and truly comprehend exactly what is being asked before any solution can be attempted. In … |
|
|
VICTOR TECHNOLOGY, VICT VCT9700 Desktop Calculator Extra Large (Catalog Category: Calculators Basic) $12.28 Extra large, 12 digit adjustable tilt display. Cost/sell/margin, tax set and tax +/-, mark up and grand total keys. Selectable decimal and rounding slide switches. Includes square root key, percent key, change sign key, backspace key and 3-key independent memory. Solar powered with battery back-up…. |