Member Training: Intermediate Excel

This course develops many of the features of Microsoft Excel. We will look at the most useful elements, including formulas and functions, using Excel as a database and sharing text and data with other applications. Everything will be explained in straightforward terms. It is also an opportunity to iron out any bad habits that you may have picked up.

No equipment is necessary for you to bring to the course. Pens and note paper will be available.

Lunch provided: For full day training courses a sandwich lunch with crisps and cakes will be provided. Hot drinks and bottle water will be provided but please bring snacks with you at present.

COVID-19 information: Please do let us know at the earliest opportunity if you or anyone in your household develops any symptoms. We are still operating social distancing between delegates and asking delegates to where masks whilst walking around the building but these can be taken off once seated.

Course Content:

• Review
• Brief review of general Excel principles:
• Arithmetic formulas Looking at +, -, * & /
• Brackets
• BODMAS
• Advanced AutoSum
• Unusual ranges
• Auto-Average/Max/Min/Count
• AutoFill
• Building Functions
• Using the Paste Function dialog
• Basic functions
• Functions with one argument:
• Statistical functions
• Absolutes
• When/how to use absolute references
• Formulas and Functions between Sheets and Workbooks
• Summarising data from multiple sheets
• Linking workbooks
• Advanced Functions
• Functions with more than one argument e.g. the IF Function
• Named Ranges
• Naming ranges
• Navigating using named ranges
• Using named ranges in formulas
• Natural language formulas
• Excel as a Database
• Sorting your data
• Filtering a list
• Useful database features
• Good Working Practice
• Copy and Paste
• Using the Windows clipboard
• Paste-Special
• Linking to other files and applications.
• Replacing formulas with data
• The Drawing Tools
• Auto shapes
• Layers
• Rotation
• Alignment
• Grouping
• An explanation of different versions

For more details or any enquiries, please do leave a message on 01603 788950, or email [email protected]