Member Training: Intermediate Excel

Location: Carrowbreck House, 7 Carrowbreck Road, Hellesdon, Norwich, NR6 5FA. 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. Duration: One-day course (9:30am – 4:00pm approximately) Equipment: 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. Refreshments will be available throughout the duration of this course. 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 Course price: From £74.00 For more details or any enquiries, please do contact us on 01603 788950, or email [email protected]