Recently, I was registering a new business with Google local, if you have ever seen a map and local business listings in the top of search queries, that is Google local. Initially, I was going to put my cell phone number down as the business number, but it just didn’t look professional to me. Up to this point, I had never considered getting a 1800 number, they seemed to smack of bigger businesses and call centers. [click to continue…]
{ 3 comments }
If you have a small business maybe you have used a flyer to market your services and promote your business. Flyer design is the popular term used to describe a one page flyer with information about your business that you want people to know. You have probably seen really simple ones from the Chinese restaurant flyer to the really expensive and fancy ones, such as, flyers promoting a popular movie. [click to continue…]
{ 1 comment }
If you are a small business owner looking to scale your sales or even someone who is simply looking for a way of making extra income, I’m going to show you how to sell products on eBay that will make you money. The first thing we need is an eBay account -you can register here , it’s free and easy to sign up for. I’m also going to put all the links I use in this tutorial at the end in case you want to read through this first. [click to continue…]
{ 2 comments }
In this short tutorial, you’ll learn how to use the AutoFormat feature. The Autoformat feature lets you pick from a group of pre-canned table formatting options to format your table or spreadsheet instantly.
1.Go to File>Open to open a new or existing workbook. Enter the data or select the already existing data, and go to Format>AutoFormat. [click to continue…]
{ 1 comment }
In this tutorial, you’ll learn how easy it is to insert graphics, pictures, or WordArt to your tables or charts. The thing to remember is to do it with taste and a purpose so that your audience is not overwhelmed or distracted from the data highlights that you want to emphasize.
1.Go to File>Open to open the workbook containing the table or chart where you want to insert a graphic or picture.
[click to continue…]
{ 1 comment }
In this tutorial, I’ll show you how to combine two chart types to better present two different sets of data.
1.Go to File>Open and open the workbook containing the data that you want to combine in one chart.
2.Next go to Insert>Chart Type. The Chart Wizard pop up window will appear, so click on the Custom Types tab. Now go down to the chart type called “Lines on 2 Axes,” select it and click Next.
[click to continue…]
{ 0 comments }
In this tutorial, you’ll learn how to quickly switch from one chart type to another.
1.Go to File>Open and open the workbook containing the chart that you want to change.
2.Next, click on the chart area to select it and right click it, and go down to Chart Type. Now you will see the Chart Type pop up window appear, under Chart Type, select another chart and click OK. [click to continue…]
{ 0 comments }
In this short tutorial, you’ll learn how to create and save a styled template for your spreadsheets. If you want, for example, your future spreadsheets to be written in red, bold, 14 pt. Comic Sans font and any other formatting specification, you can make this happen with the Style feature within Excel.
1.Go to File>Open and open an existing or a new spreadsheet. Then go to Format>Style, and the Style pop up window will appear,as you can see, there are general specifications next to the formatting titles: Number, Alignment, Font, Border, Patterns, and Protection. Click on the Modify button, and the Format Cells pop up window will appear.
[click to continue…]
{ 0 comments }
You may know how to create a simple chart in excel but what if you could create an even more complex and attracting looking chart like a 3-D column chart from an Excel advanced feature like Pivot Tables? Well, you’re in luck, in this lesson, I will show you step by step how to create a pivot table from raw data and from that pivot table how to create a cool looking 3-D column chart. I promise the final product looks impressive, but you’ll be more surprised at how easy it is to do. With this skill under your belt, you will be a star in front of your marketing and finance colleagues.
[click to continue…]
{ 4 comments }
So now you need to know how to make business cards? You finally did it, and started your own business. It’s exciting, scary and expensive, so if you are like most new small business owners, then you probably have a budget and are trying to keep costs to a minimum. One of the most important things to do is to market your new business and get the word out there that you have new products and services to offer. In keeping costs down, Microsoft Word is fantastic in helping you develop your own marketing materials. In this lesson, I will you show how to create your own business cards in Microsoft Word. But to be honest, the easiest most time efficient way I have found is to just order through vistaprint , You get 250 cards for just shipping and handling and they look tremendously professional, I think you have to add $1 to have a clear backside , but that’s about it, total is about $8 and it’s on your doorstep in a few days. You can click here for that. The bad news is it’s only valid for Canada and the US. Sorry to you guys in India, I know a lot of you visit here.
[click to continue…]
{ 39 comments }
You have been given a special project that requires you to travel and conduct massive training workshops for new employees that have been hired by your company, Happy Tummies, a restaurant chain. You will need to train a co-worker to fulfill your job duties for about a month. You only have two days to train her. One of your main responsibilities is creating various monthly training reports, and you have created macros that quickly and automatically run monotonous steps associated with the reports. You decide to create toolbar buttons for the most commonly used macros in order to train your co-worker faster and make it easier for her to prepare the training reports using the macros in your absence.
[click to continue…]
{ 12 comments }
Finally, you have mastered the art of creating simple macros in Excel and they are working great. You are getting your work done quickly and efficiently. But, now your company has expanded and with this growth, you have had to add extra data to your reports and steps, so now you need to edit your wonderful macros in order to make your work life manageable again.
You don’t want to recreate the macros, just add new information and steps. But the bigger problem you face is that to edit the macros in Excel you need to use another program called Visual Basic Application, and you don’t know anything about it. Don’t be intimidated by this program which uses code to create and edit macros because you don’t need to be a computer language wiz or techie to use it. You just need to know some basics about the program itself to get you started.
[click to continue…]
{ 12 comments }
I was asked once to design a cover for a training manual, and I agreed, not really knowing what program I could use. I didn’t have any of the fancy image editing programs, such as, Fireworks or Photoshop. I agreed thinking that I would use Microsoft Word, but then I had an idea, why not use Microsoft PowerPoint? I had used it to create fantastic looking presentations, so why not a cover for a booklet that would be printed. I had access to the company’s pictures and logos, so the only thing needed was my own design inspiration. In the end, my design was such a hit that it was submitted to an advertising company and used for a whole line of training materials. So, for initial design efforts, Microsoft PowerPoint is a jewel in disguise. In this tutorial, I will show you how to design and create a booklet cover using Microsoft PowerPoint.
[click to continue…]
{ 1 comment }
Your boss comes in and tells you that the budget meeting will be today, but he has some new totals that will vary and wants you to prepare the reports showing how the different totals will affect the final figures. You panic because you had already prepared the proposed budget with the original figures given to you and now you have to plug in new values that will affect the final totals and prepare the reports showing how these new figures compare to one another. You just don’t have time to go into your Excel spreadsheet and delete, input, save and print all the reports with the different scenarios. Well, you don’t need to panic, luckily for you and all of us, Microsoft Excel has a very useful function called Scenarios that allows you to change variable information in cells that affect the final totals of a formula in minutes and prepares scenario reports instantly. In this tutorial, I will show you how to use the Scenario function in some simple quick steps.
[click to continue…]
{ 13 comments }
All jobs and fields require some repetitive steps. Even the most creative jobs can usually require some monotonous tasks. Tools like Excel can help us automate some of those repetitive steps and that way makes our lives easier, so we can get the work done quickly and have more leisure time. In essence that is what Macros do; they’re shortcuts for repetitive tasks done within Excel. In this tutorial, I will show you how to create a simple macro that will memorize the steps involved in a simple repetitive task. We are going to be using fictitious information for the Training Department in a restaurant chain company called Happy Tummies. This company has restaurants in five major cities, so a great deal of training is done all year round. All restaurants are assigned a Training Manager, there are five Training Mangers in total. We’ll pretend you are the Training Specialist who works out of the Corporate Office located in Miami, FL and are responsible for analyzing and preparing reports on all the trainings completed. One repetitive task that you always perform is entering the names of all the Training Managers to prepare the daily training reports.
Let’s Get Started!
[click to continue…]
{ 128 comments }
Have you ever been inundated with large amounts of data and not enough time to figure out how to make sense of it all or even worse to analyze it? Sure you have, we all have. In any line of work, from the corporate world to the small business owner to the college professor or PhD student, we have all been there and we know that there are tools out there like Excel that could really help us navigate through the sea of raw data and make sense of it. Pivot tables work well for making reports from vast of amounts of data. But, we think it is difficult or we just don’t have the time to use the help feature and go through a bunch of steps to get to the one step that we actually need. Well, fear no more because in this tutorial, I will show you some basic steps to using the auto filter and advance filter functions in Excel.
Please don’t be scared of them, although, the filtering functions are very powerful, they can be learned and the more you play with them the better you will get. The Autofilter and Advanced Filter functions in Excel are used to display specific groups of data and hide from view the rest of the data and this way help you find and focus on the data that you actually need. It is different from the sorting function, which actually regroups data or resorts the data in a different way, for example, in alphabetical order.
[click to continue…]
{ 6 comments }
Loading ...