June 1, 2015

MS Excel Tuition

MS Excel tuition for beginners to advance, from students to business people trying to get a better grip with Excel.

Drop us a line and for only £15 / hour per person we can enhance your skills to give you the Excel edge!

Excel Training Selected Topics for Beginners

We specialise in delivering flexible training programmes and course topics taught may vary depending upon your requirements and upon the version of the software.

  1. Navigating the Excel Environment
  2. Deleting and inserting rows and columns in Excel
  3. Formatting worksheets in Excel – merging cells, conditional formatting and manual formatting
  4. Handy shortcut keys for working in Excel
  5. Formatting cells and data in Excel: formatting numbers, borders and shading, background color, fonts, date and time, currencies and decimal points
  6. Adding, editing and deleting Comments in Excel
  7. Working with simple charts – creating charts, modifying charts, moving charts
  8. Handling long text
  9. Automated calculations with AutoSum
  10. Getting started with Excel formulas: equations, calculations and conditionality with =SUM and =IF, averages, COUNT, MIN and MAX.
  11. Differentiating result sets with Conditional Formatting and color coding
  12. Troubleshooting equations in Excel
  13. Working with multiple worksheets in Excel
  14. Working with multiple workbooks in Excel (color coding, naming and moving)
  15. Linking documents, “paste special” and “get external data” in Excel
  16. Sorting and filtering data in Excel
  17. Protecting documents and document security
  18. An Introduction to Data validation
  19. Printing Excel documents – page breaks, page orientation, page margins, headers, footers, page numbers, Print Preview and common printing problems
  20. Using Help and other resources to solve your spreadsheet problems

Intermediate Excel training course topics – workbook features

You can combine Beginners, Intermediate and Advanced Excel topics for a blended training programme .

We specialise in delivering flexible training programmes and course topics taught may vary depending upon your requirements and upon the version of the software.

  • Working with IF() and VLOOKUP()
    1. Introducing the IF() Function in Excel
    2. Multiple If’s – The Lookup Functions
    3. Working with multiple Column lookups in VLOOKUP()
    4. Using the Lookup Wizard
    5. Finishing the Lookup Wizard
    6. Rounding up or down for Calculations
  • Understanding Cell References
    1. Using Absolute Cell Referencing
    2. Using Mixed Cell References
  • Working with Ranges
    1. Applying names to Ranges of Cells
    2. Using Range Labels
    3. Creating Range Names
    4. Creating Multiple Names
    5. Using Range Names
    6. Movement and Selection
    7. Defining Names for your Formulas
    8. Applying Names
    9. Deleting Range Names
  • Working with Spreadsheet Security and Data Integrity
    1. Protecting your Excel Worksheets
    2. Validating data by applying input restrictions
    3. Creating Input Error Messages
    4. Specifying the Error Alert
    5. Protecting Cells
    6. Locking the Excel Worksheet
    7. Unprotecting the Excel Worksheet:
    8. Protecting the Excel Workbook
    9. Hiding Areas of the Worksheet
  • Advanced Spreadsheet Navigation
    1. Controlling the Screen
    2. Clearing Windows
    3. Working with Multiple Windows
    4. Freezing Row/Column Titles
    5. Using the Zooming feature
    6. Creating Custom Views
    7. Showing Views
    8. Deleting Views
    9. Full Screen View

Advanced Excel training selected topics – what if conditional analysis

You can combine Beginners, Intermediate and Advanced Excel topics for a blended training programme.

We specialise in delivering flexible training programmes and course topics taught may vary depending upon your requirements and upon the version of the software.

  • What if? Analysis in Excel and scenario based forecasting.
    1. Working with the IF Function
  • Introducing Goal Seek for Excel
    1. What is Goal Seek?
    2. Using Goal Seek to determine possible starting values
  • Introducing the Solver
    1. What is the Solver?
    2. Solver examples and forecasts
    3. Solving Staff Allocation
    4. Adding Constraints to limit the range of values the Solver can use
    5. Solving the Sheet
    6. Understanding Solver Reports
    7. Refining the Solver Solution
    8. Saving Solver Data
  • Predicting Business Outcomes with the Scenario Manager
    1. What is a Scenario?
    2. Creating a new Scenario
    3. Viewing historic Scenarios
    4. Editing your Scenarios
    5. Scenario Summary
    6. Deleting Scenarios

6 thoughts on “MS Excel Tuition

  • MS Excel tuition for all people in the Romford, Hornchurch, Upminster areas, with services for learning for business, for analysts and for those inbetween

  • If you are student just leaving school or college looking for a job or preparing for Uni and good dose of Excel training will only help when speaking to an interviewer and then being able to display you skills, to impress.

  • From simple reference to complex mathematics MS excel can provide a good solution to most business and technical solutions. Obviously the various version have their own strengths and weaknesses, but this should not be a barrier to trying something, always dip your toe in and see what happens. Agile methodology suggests that a process of continual iteration feeds creativity.

    • Hi,
      Each student varies on ability… which means its hard to answer.
      I would expect 10 session per level to at least cover the content, however this assumes instant retention and no testing or validation.
      I hope this answers your question.
      Kind Regards

Leave a Reply

Your email address will not be published. Required fields are marked *