Blake Mcnaughton - Articles

Filtering data based on font, colour and format criteria, down rows or across columns in a Microsoft Excel spreadsheet

When Microsoft Excel is used to manipulate, store and analyse data it can become extremely difficult to manage, let alone efficiently work to produce any meaningful insights. This is because with data sets large and small, the data must be meaningful, logical, structured, internally consistent and clean. This holds true regardless of whether the data has been imported into excel from another system or manually entered. Read

By: Blake Mcnaughton | 12/04/2009 | Software

Navigating Through Formulas In Large And Complex Microsoft Excel Spreadsheets

When Microsoft Excel is used to construct large and complex spreadsheets containing multiple worksheets, it can become extremely difficult for someone to navigate, let alone track or trace numbers through the spreadsheet with all of the values and formulas............. Read

By: Blake Mcnaughton | 21/02/2009 | Software

Management Consulting Interview – Beyond the Case Interview

Whilst case interviews are considered the more challenging side of the consulting interview, it is important to be aware of other types of interview questions that you will inevitably face when interviewing with a top management consulting firm such as Mckinsey, Boston Consulting Group (BCG)................ Read

By: Blake Mcnaughton | 02/08/2008 | Interviews