Categories
Microsoft Excel

Excel functions you need to know for CAT

The following table lists all the functions that you will learn in your three years of CAT.

Categories
Microsoft Word

Page numbering in Word

Word’s automatic page numbering feature can become quite complicated very quickly! The complexity results from the various options available combined with the possible existence of Sections in your document. Your saving grace is that Word neatly labels the Headers and Footers on each page giving you all the information you need. Page numbering is inserted […]

Categories
Microsoft Office

Shortcuts for marking CAT practical assessments

I find the following shortcuts invaluable when marking practical assessment files (Word documents, Excel workbooks, etc.). I also teach my Learners these shortcuts as I believe it gives them a huge advantage. Microsoft Word SHIFT+F1This shortcut displays the “Reveal Formatting” panel. ALT + ←When you test a hyperlink that has its target in the same […]

Categories
HTML

Prevent Pinterest pinning

If you have the Pinterest plug-in enabled in your browser as I do, the image below will display the bright red Pinterest “Save” button in the top-left hand corner. As a web developer / designer, you may not want this bright red button ruining your “aesthetic”. If you want to turn off Pinning on a […]

Categories
MySQL

ODBC MySQL Data connection in Excel

After swatting up on connecting QlikView to a MySQL database, I used the knowledge gained to create a similar set-up, this time with Microsoft Excel. This is how to dynamically connect to and query a MySQL database table directly from MS Excel on a local development machine. I did this using Microsoft Office Professional 2013. Download […]

Categories
VBA

Hello World! Excel VBA

I find Visual Basic for Applications most useful in Excel. I have created many small enhancements to make my larger spreadsheets easier to use. Here follows a simple “Hello World!” introduction to VBA for Excel. In this exercise, we are simply going to have a pop-up message appear when we first open an Excel Workbook. […]

Categories
General

Microsoft Excel CSV export options

I am busy with a data migration where I need to export Microsoft Excel workbook data to CSV so that I can import it into MySQL. I was extremely surprised that there are no options from within Excel to change delimiters and so forth. The solution is cumbersome and involves changing Windows operating system settings which […]

Categories
PHP

Read a Word doc using COM

So I managed to write a script to read a Microsoft Word document using PHP CLI and the COM object pretty easily, but then battled to get it working in the browser. In your php.ini: ; allow Distributed-COM calls; http://php.net/com.allow-dcomcom.allow_dcom = true On your Windows PC: Run “dcomcnfg” (right-click Windows icon and select Run) to open […]

Categories
VBA

Display the full pathname of a Word document in the Title Bar

I have to have multiple Microsoft Word documents open when I am marking CAT practical assessment papers. As I have the Learner’s file, the original file, as well as the solution file open and they all, have the same name, it becomes difficult to know which one I am viewing. As constantly clicking on File […]

Categories
Microsoft Word

Lorem Ipsum – the Dummies Guide to Dummy Text

If you work in design or printing (or with designers or printers) you will often see some pretty weird-looking text in documents, advertisements, posters and other design work: “Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation […]