Microsoft Excel - Basic to Intermediate

Excel is a comprehensive tool to help businesses create, analyse and share information using spreadsheets. This course is designed for those who have a basic knowledge of Excel but wish to learn some of the more intermediate functions in order to more effectively use spreadsheets.

Key Objectives

After attending this course delegates will understand:

• Toolbar command functions
• Shortcut menus and keystrokes
• Editing spreadsheets
• The different types of data used in spreadsheets
• Creating basic formulas
• File mangement and housekeeping for business efficiency
• Managing existing formuale
• Improve the presenttion of spreadsheets through formatting techniques
• Create charts and graphs
• Work with multiple spreadsheets
• An introduction to Excel functions
• Printing a workbook or selected sheets
• Learning techniques to enable practical use of Microsoft Excel back in the workplace

Course Outline

• Data types
• Creating formulae
• Order of precedence (BODMAS)
• Copying formulae
• Absolute and Relative references
• Excel functions including Average, MAx, Min, Count, Formatting
• Bar Charts, Pie Charts, Line Charts
• Print Set up and Printing
• Linking worksheets

Key Benefits

• Efficiency savings and increased productivity
• Presenting information in such a format to aid business decision making
• Logical structured approach to reporting information
• Efficient use of Excel functionality to enhance functionality
• Improved techniques for communicating and evaluating data
• Consistent and reliable approaches to data collection