My Initial Reaction
I can’t remember how I discovered Excel.TV but I watched the episode 1 trailer and my initial reaction was something like this: “WHAT???” followed by “Who are these guys?” and “I’ve got to check this out!“. Continue reading
I can’t remember how I discovered Excel.TV but I watched the episode 1 trailer and my initial reaction was something like this: “WHAT???” followed by “Who are these guys?” and “I’ve got to check this out!“. Continue reading →
I have been asked this question many times so I thought I would write this post as a reference that I could share with anyone who wants to improve their Excel skills.
Download the Excel file from my OneDrive (file 00126) Continue reading →
If you extract all numbers, from left to right, you can create a Date/Time value of Nov 28, 2014 5:08pm (and 51 seconds) in Microsoft Excel.
Continue reading →
With any product there is a balance between the number of features versus the cost/performance. Race cars and stretch limos have different features and different purposes. Continue reading →
As much as I enjoy sharing my knowledge I have found that this series is just as beneficial for me as it is for others. I sometimes ask myself or others “Do you remember that Excel thing that does….” Continue reading →
I was thinking about this on Friday…. It’s got to be more than just the final score point difference.
Sure, an exciting finish like the 1991 Giants vs Bills game is a classic. Continue reading →
Sometimes there are data quality issues and you should examine the data before adding formulas and formatting.
This template allows you to keep track of events like birthdays and anniversaries. You can also create more events in the ‘Settings’ sheet. In the ‘Input’ sheet you walk through the steps of selecting the event type, adding the individual’s name and date, etc.
I work full time as a Data Analyst currently specializing in Microsoft Excel and Microsoft Access. To keep up to date I watch a fair amount of YouTube videos and follow several websites. Continue reading →
Are you a small business owner or are you thinking of starting a small business?
Do you wish you had more hours in a day?
If you answered yes to both of these questions then you should do an audit of all of your tasks to see where you can save time.
I created a free template called ‘Small Business Outsourcing Template’ that will help you determine where you need help.
You can download the file here or here from my OneDrive. Feel free to clear the data input range in sheet ‘3 Task Input’ and add you own data.
I also created a video that shows you how to use the template. Watch the video