Software Packages

This Microsoft Excel course aims to cover:

• Using multiple worksheets
• Import external data 
• Using the hide and protect options
• Text manipulation functions
• Using the group and outline tools
• Using ‘Lookup’ functions
• Using the ‘IF’ function
• Building advance graphs
• Conditional formatting.

This Microsoft Excel course will help you learn how to:

• Navigate large worksheets effectively by using magnification, frozen panes, and split panes; and control the printing of large worksheets
• Navigate, manage, and print multiple worksheets; link workbooks by using 3-D formulas; and summarise data by using the Consolidate command
• Change the View, General, and Calculation settings of Excel; and customise toolbars and menus
• Add borders and shading; apply special formats; create, apply, and modify styles; and change the orientation of cells
• Sort lists by columns; and filter lists based on complex criteria
• Format data points; create combination charts and trend lines; and add and format graphic elements
• Embed and link objects in a worksheet; and allow several users to work with the same data by sharing, merging, and tracking changes
• Use auditing features; add comments and text boxes; and protect a worksheet or part of a worksheet
• Use the VLOOKUP function to find a value in a worksheet list; use the MATCH function to find the relative position of a value in a range; use the INDEX function to find the value of a cell at a given position within a range
• Use IF functions to determine an outcome based on criteria.