Not only do spreadsheets excel at calculating numbers, they can also calculate dates too. Imagine that you have taken out a 6-month loan and you want to know when it will be paid off (assuming that it is 6 calendar months from the loan start date) or maybe you have been assigned a project which [...]
I’ve not yet "upgraded" my 17 inch MacBook Pro (my "main machine" as I call it) to Lion. There’s a number of reasons for this – too many to go into here, but I think it’s probably a case of if it ain’t broke then don’t fix it. I know I’m going to have to [...]
Earlier this week a colleague came to me with a problem with his iPhone. When he arrived at work that morning his battery was fully charged. By lunchtime it had dropped to 30%. He’d only made one call and has the data turned off. I asked him if he ever closes the apps and he [...]
As regular listeners to MacBites and readers of this blog will know, I’ve been chasing the holy grail of having my work calendar available on my iDevices for quite some time. I’ve tried a number of solutions with limited success.
This week at work I was asked how to create a calendar shortcut icon within an outlook message. The lady in question wanted to send an email to a group of users explaining there was a seminar happening and to wanted users to be able to double click the icon to add the appointment to [...]
Almost all of the training courses that I deliver involve PowerPoint. Let me be clear, I don’t mean that I solely deliver PointPoint training, rather, most of the courses require the use of PowerPoint. I have a few introductory slides (with not a single bullet point in sight!), I have a slide with contact details [...]
Whilst building a Graphical Dashboard for a client I discovered that the Excel 2007 macro recorder doesn’t record actions that involve placing and manipulating the drawing tools/shapes.
At work, our team has recently started to offer eLearning courses. These courses are “bite-sized” (typically 15-20 minutes) modules, covering topics such as File Management, Excel formulae and setting mailbox permissions in Outlook.
Excel allows you to assign a name to an individual cell or a range of cells. That name can be used in a formula and can help to make the formula easier to understand. Names can also make it easier to navigate around a large spreadsheet. In Excel 2007 and 2010, names have a scope [...]
The Save As PDF command in MS Office 2007 allows you to create a PDF from a Microsoft Office document even if you haven’t got Adobe Acrobat installed. However, if the Office document contains images (and the images have been inserted using the Insert > Image command rather than copy and paste), the image in [...]