Spreadsheets – Microsoft Excel

Course duration : 6 to 9 hrs

Microsoft excel is a spreadsheet software programme that allows you to input and manage numerical and other types of data. Data can be used to carry out automated calculations and analyses ranging from simple sums to complex mathematical formulae. Learn how to present the results in many different formats.
Efficient use of MS Excel is a must for any business.
This Microsoft Excel course provides students with additional skills in the use of the many features and functions of this software, making students more efficient and effective when using the package.

The course starts by refreshing students on the fundamental features of Excel but again advances quickly to give an understanding of areas such as working with multiple worksheets, conditional formatting, linking cells, worksheets and workbooks, linking to other applications such as Microsoft Powerpoint and Microsoft Word, using Financial and Logical functions, creating charts with linking and updating to other applications for presentations.
Courses availiable from beginner to advanced users.

BEGINNERS

• Getting started
• Moving around the screen
• Entering text, numbers & formulae
• Editing cell contents
• Copy & move cell contents
• Open & save worksheet files
• Changing column widths & row heights
• Changing the alignment of cells
• Number formats
• Freezing panes
• Views & toolbars
• Naming cell ranges
• Spreadsheet mathematics
• Building formulae
• Cell references in formulae
• Inserting & deleting rows & columns
• Formatting cells
• Adding borders
• Copying cell formats
• Printing a worksheet
• Print preview

INTERMEDIATE & ADVANCED

• Overview of the new fundamental features of Excel XP
• Creating Workbooks
• Selecting a range of cells
• Entering dates in a worksheet
• Moving between worksheets
• Building formula – order of precedence
• Formatting numbers
• Inserting rows and columns
• Adjusting column width and row height
• Merge and Centre feature
• Paste and Paste Special
• Page Setup
• Adding Custom Headers and Footers
• Changing margins and centring a worksheet horizontally and vertically on page
• Scaling a worksheet
• Page Break Preview – Adding and deleting page breaks
• Setting and Clearing Print area
• Using Gridlines
• Comments
• Editing and deleting comments
• Hiding & unhiding Rows and Columns
• Freezing and Unfreezing Rows and Columns
• Adding and Deleting & Renaming worksheets in a Workbook
• Conditional Formatting
• Sortingdata
• Single, Multiple and Custom Sort orders
• Linking
• Linking Cells, Worksheets and Workbooks
• Linking and updating worksheets to Microsoft Powerpoint and Word.
• Importing word documents into Excel.
• Using Absolute and Relative Cell References
• Using the Formula Palette
• Using Statistical and Logical Functions
• If Functions
• PMT Function
• Count Function, Counta, Countblank, Countif
• Macros
• Creating Macros
• Editing Macros
• Using Charts
• Create charts – Column, Line, Bar and Pie
• Format Charts
• Linking Charts to Microsoft Powerpoint for Presentations
• Updating links.