I decided to do another short post to save you some time. This image/post takes a look at how to setup the camera tool and then how you can use it on a separate worksheet to begin the setup of a new dashboard. The Excel Camera Tool allows you to take an image of a range of cells and create a picture/object out of it. Once that picture is created, it will automatically continue to refer to the cells that the image was taken of and will update as the cells change. Feel free to leave any questions in the comments. (more…)
Over the next couple of weeks, I will be building a dynamic salesman dashboard that allows the user to interact with the spreadsheet to get the information that they need. This post will first focus on building a data validation list that will immediately make the spreadsheet interactive. (more…)
Now that the holiday season is over (almost 2 weeks ago now) I’ve finally got myself back into a routine and I wanted to start off the year with a quick tip for those of you looking on how to build a list of weekday dates for your planning purposes and to get the year started off right. This simple trick can be used to build a quick calendar to record daily sales, production numbers, number of orders shipped etc.
You’ll notice that when using the auto fill option located in the bottom right hand corner of the current cell that you’ve highlighted, that as you drag the mouse over other cells, the dates automatically populate in chronological order. The only problem here is that you only want to include weekdays and not all days of the week. This post will show you how to easily and quickly only show the weekdays in the calendar that you’re building. (more…)
This is a guest post by CPA David Ringstrom from Accounting Advisors, Inc. David covers some functionality from Excel tables in 60 seconds. His video shows you how to expand tables, add total rows, autofill data and shows us how the filter option becomes immediately available.
If you are encountering any issues with not being able to see the video directly from the website (videos don’t seem to render with the new IOS7), you can access the video here – Excel in 60 Seconds.
I want to send out a big thanks to David for taking the time to put something together!
