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 Equipment: Pens and note paper will be available. Lunch provided: For full day training courses a lunch with sandwich or salad,  crisps and cake or fruit will be provided. Refreshments will be available throughout the duration of this course. Course Content: 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 Course costs £109 per person. For more details please contact us at [email protected] or on 01603 788950. Link to book – www.southnorfolkandbroadland.gov.uk/training