Tags » Excel

Excel 2013 For Dummies

The bestselling Excel book – completely updated for Excel 2013! As the world’s leading spreadsheet application, Excel has an enormous user base. The release of Office… 62 more words


Entering the world of Macro Coding

I love writing Macro codes – it’s a guilty pleasure. But it can be a bit daunting, frustrating and soul destroying.

I learnt the skill of writing a macro code quite recently in my final year of Unviersity. 686 more words

Microsoft Excel & Access ~Summer Term 2017

Course title: Microsoft Excel & Access
Course reference: C2336915
Tutor(s): Peter Goodwin
Venue: Vernon Community College, Vernon House, 18 Friar Lane, NG1 6DQ
TEL: 01159 414967… 78 more words


Pixelated Fairy

Day 16 – Pixelated Fairy

I had a brainwave of making a pixelated image of a fairy in full colour. After a considerable amount of time researching pixelated images and playing around with Microsoft Excel (after adjusting the cells to perfect little squares), I came up with this little lady. 34 more words

Glitter Peach 365

Unique Array from a column - VBA / Excel

How many times we need a loop to run on unique values in a column.

Report 1. 248 more words


Find a column by name - VBA Excel

Note: This is for someone with little VBA knowledge.

How many times we have a need in VBA automation to find a column by name and not the number. 385 more words


Excel Tables (Continued)...

I could not finish with Excel Tables in my previous post. Today, I am going to talk about a couple of more functions that we can use in excel tables. 101 more words