Diary | Excel Expertise

Follow Excel Expertise on Twitter

Finished developing a dynamic dashboard for my client at one of the largest Chocolate Manufacturers in the World.

Finishing off the outstanding smaller jobs this week ready to automate a spreadsheet for a Company in the financial industry next week.

Busy working on a Recruitment KPI Dashboard for a Consultancy Firm.

Just downloaded some free vector graphics from freevectorsdaily.com (via @GraphicsDaily)/

Using VBA in Word to open and run a macro in Excel, gather and update data in Excel, pull the data back into Word for the next procedure.

Used VBA Arrays to perform complex calculation of vehicle accident forecasts over a three year period, for an Insurance Company.

I love Dropbox because It's free and versitile for personal and business use. It's awesome! db.tt/pItbQDSG

Presented two Excel Intermediate training courses yesterday at Ryvita.

Writing a macro to automatically size position and add staff photos to restaurant chain's Excel spreadsheet. Photos display based on name.

Booked to provide two sessions of Intermediate Excel Training for Line Managers at Ryvita, end of March.

Finished a macro for engineers to analyse measurements for engine manufacture.

It's a mixed bag this week - Order Forms for Virgin Media Business, formulas for a recruitment firm & adding staff photos for a restaurant.

Developed a Recruitment Package, for use in preparing interview packages, for one of the world's largest chocolate manufacturers.

Finished creating Dental Record sheet for Equine Dentist to complete at stables and save to .pdf, email & save to Dropbox.

Received a recommendation on LinkedIn - Lorraine instantly grasped our requirements and provided a solution that fits our business perfectly

Helping a customer to modify an Excel Calendar which updates events in the Scheduler. He couldn't get the formulas to work.

Developing a Client Sheet for my Equestrian Dentist to pre-populate and modify stable/horse details, to update back to the master in Excel.

Partnering with Harbour and Associates Chartered Accountants in South Africa, in order to support their clientele's Excel Spreadsheet needs.

Automating a Quotation spreadsheet for a printing Company. The user selects products from subset of prices and quickly create a quotation.