The only thing that can't be automated in Excel is the input of raw data... and even that can sometimes be done. If you are looking to avoid repetitive tasks in your Excel spreadsheet (clearing out data to start a
ExcelGuru.ca is run by Ken Puls, FCPA, FCMA. I'm a Certified Management Accountant, who never remembers life without spreadsheets and computers. Since mid 1999, my career has been spent in the hospitality and tourism industry, in the finance and IT
I was working with some budget stuff today and wanted to forecast that a range of accounts would be written off. I had a forecast that showed the projected transactions monthly, (all zeros as the projects have been discontinued,) and
I love this! If you're running Outlook 2010 and Exchange 2010, you can set up your out of office replies any time during the day, and schedule them to take effect for a certain period. I wish I could do
Back in the days of classic Excel (versions 97 through 2003), I displayed about 10 toolbars, working out to hundreds of commands represented by tiny icons. We recognized them, and were able to have all of our most used commands
In Introduction to the Excel WebApp, we learned how to create, upload and view files in Microsoft's Web Version of Excel, hosted on SkyDrive (a free offering from Windows Live.) It should be noted that thee main reason for creating
In June 2010, Microsoft released the Excel WebApp as part of their Windows Live offerings. This is an interesting product as it allows you to store, read, edit and share your Excel document in the cloud. This means that it
Over the past while we've been building a Dashboard report for our golf course. It's got some historical information in it, but we've also pulled in things like weather forecasts. The intention is that our managers will be able to
Hello everyone, At the last MVP summit I had discussions with a couple of people about something that has been burning away in the back of my mind for quite some time... creating my own Excel forums. I've been absent
Today we began the process of migrating away from VMWare to Microsoft Hyper-V for our server farms. Something I'm sure that Microsoft would be pretty happy to hear. And yet I got burned by an issue in the process that
Copyright © 2022-present Excelguru Consulting Inc. All rights reserved.
