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

Ebook

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

WEA

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

Excel

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

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

#learningproject