Introduction to Microsoft Excel

The course runs from 09:30-16:30 and covers the following:

 Using Help:  Teaches users how to utilize Excel’s built-in help features to find information and assistance when encountering difficulties or questions while using the software.

 Editing Techniques: Participants learn various editing techniques, including how to cut, copy, paste, and manipulate data within Excel.

 Saving Your Work: Understanding how to save Excel workbooks and files is crucial to ensure that data is preserved and can be accessed in the future.

 Formulas: The basics of creating and working with formulas in Excel, which are essential for performing calculations and data manipulation.

 Writing Formula: Users learn how to write and structure formulas to perform specific calculations, such as addition, subtraction, multiplication, and division.

 Using Functions: Functions are predefined formulas in Excel. Participants learn about commonly used functions like SUM, AVERAGE, MAX, and MIN, and how to use them in calculations.

 Copying Data: This section covers techniques for copying and pasting data within Excel worksheets and between worksheets or workbooks.

 Auto Fill: Participants learn how to use Excel’s auto-fill feature to quickly fill cells with a series of data, dates, or patterns.

 Formatting: Formatting is crucial for making Excel worksheets visually appealing and easy to read. Learn about cell formatting, font formatting, and other formatting options.

 Spell Checker: Teaches users how to use it to check and correct spelling errors.

 Find And Replace: How to search for specific data within a worksheet and replace it with other values or text.

 Printing: Understanding how to configure and print Excel worksheets is important for creating physical copies or reports.

 Absolute Cell References: Learn the concept of absolute cell references in Excel formulas, which allow for precise referencing of specific cells.

 Named Ranges: Named ranges make formulas more readable and manageable. This section teaches users how to define and use named ranges.

 Naming A Formula: Participants learn how to assign names to formulas for easier reference and reuse.

 Linking Workbooks: How to establish links or references between different Excel workbooks, which can be useful for data consolidation.

 Creating Charts: Learn how to create various types of charts and graphs to visualize data effectively.

 Chart Options: Delve into customizing charts by adjusting their appearance, labels, and other settings.

 Changing The Size Of Embedded Charts: Learn how to resize and manipulate charts when they are embedded within a worksheet.

This course provides a strong foundation in Excel skills, particularly for those who are new to the software or looking to enhance their basic proficiency.

Learning Outcomes:

 Enter and Edit Data within a Worksheet: Users will gain proficiency in entering data into Excel spreadsheets and making necessary edits to ensure data accuracy.

 Manipulate Data Using Formulas and Functions: Participants will learn how to create and apply formulas and functions to perform calculations and manipulate data efficiently.

 Professionally Format the Worksheet:  Users will be able to format their worksheets to improve visual appeal and readability, which is essential for creating professional-looking documents.

 Copy and Move Data: Users will learn how to copy and move data within and between worksheets, enabling efficient data management and organization.

 Automatically Fill Cells: Understanding how to use Excel’s auto-fill feature can help users quickly populate cells with sequences or patterns of data.

 Print Worksheets: This skill is important for producing hard copies of worksheets or reports for documentation and sharing purposes.

 Name Ranges for Use in Formulas: Users will be able to define and use named ranges, making formulas more understandable and less error-prone.

 Create Relative and Absolute Cell References: Understanding the difference between relative and absolute cell references is crucial for building complex formulas that adapt correctly when copied or moved.

 Manage Links Between Sheets and Workbooks: Users will learn how to create and manage links or references between different sheets and workbooks, which is essential for data consolidation and analysis.

 Create Charts: Users will gain the ability to create various types of charts and graphs to visually represent and analyse data, a valuable skill for reporting and presenting information effectively.