Projects. James Hall Business Solutions : Freelance Business Consulting, Providing Analysis, Recommendations, and Implementation.

"Enabling companies to improve their performance through high quality analysis"

Excellence with Excel:

Excel Focused Projects

For many clients Excel is the tool used to for individuals to store data and perform analysis. When used correctly Excel spreadsheet computing is an exceptionally powerful tool.

As an Excel power user (20+ years spreadsheet experience with all versions of Excel) I can quickly create spreadsheets to analyse data and present it in a meaningful fashion.

I have first hand of building executive information systems which have enabled managers to interpret data leading to £ millions extra profitability for their company.

Experience includes:

- Pivot table expert, working with pivot tables based on 700,000+ lines of data
- Formula expert, vlookups, index match, concatenation, sumif, logic functions etc.
- Graphical expert, building charts that illuminate value adding perspectives
- End user friendliness, utilisation of click buttons and pull down menus
- Training for end users
- Macros & VBA
- Developing solutions quickly from mass data storage repositories (SQL, Access) with millions of lines (eg building executive information systems to summarise sales or costs by varying time scales for companys with hundreds of retail outlet via their EPOS systems)
- Devising operating strategies to support corporate strategy and providing the metrics upon which to monitor/assess the operating strategy

If you have a project that requires analysis in Excel then please get in touch.

Excel Tution / Lectures

Almost all businesses utilise Excel in some shape or form.

Having worked with many people from varying departments across large and small organisations it has become apparent how basic most employees knowledge is when using Excel.

I am surprised to see how many employees spend time struggling to summarise their data to provide insightful reports on which to make business decisions.

If only they were competent to use a vlookup or a pivot table they could save hours in getting to the information summary they require.

This is costing their employer huge sums of money both in time and potentially sub optimal decision making.

James Hall Business Solutions can provide lessons for either large or small groups of employees within your organisation.

Lessons will be pre-prepared in advance using the data the attendes use on a daily basis so the skills they learn are directly applicable to the organisation.

Lessons can be held at your work place for convenience.

Your employee's productivity and confidence with Excel will improve massively.

For an example of tuition slides (and link within Powerpoint to Excel file) on how to complete a vlookup please click here.