Microsoft Excel Consultant

Give your business the Edge!

Increase productivity and analyse your business data more effectively.

Excel Consultant and customsied training for the following;

Use Excel to produce reports, lists, budgets and analyse figures using formulas and spreadsheet formatting including;

  • Creating and modifying formulas
  • Formatting headings
  • Sort and filter lists of data
  • Creating charts
  • Printing Excel Spreadsheets
  • Linking worksheets
  • Relative and absolute cell referencing
  • Named ranges
  • Protecting data including formula cells and worksheets
  • Data Validation including drop down lists for data entry
  • Advanced functions such as IF, VLOOKUP, ROUND, COUNTIF, SUMIF, TRIM, CONCATENATE, IFERROR
  • Analysing lists using Pivot Tables
Enquire

Excel VBA and Macros

Need instructions on Visual Basic programming to produce Excel Macros to automate tasks in spreadsheets. We can advise on;

  • Record a Macro
  • Running a Macro from the toolbar or a button
  • VBA Programming
  • Debugging a Macro
  • Running a Macro when a spreadsheets opens or closes