Requirements:
-Knowledge of PC fundamentals
-Experience in working within the Microsoft Windows environment
-A reasonable degree of keyboard proficiency and mouse proficiencyNo previous experience in using Excel or any other spreadsheet program is required in this introductory programme. It is assumed, however, that you have:
Course objectives:
On completion of this programme you will be able to:
-Open, save, close, create and print a worksheet
-Perform basic worksheet editing operations
-Perform basic worksheet formatting operations
-Use basic Excel functions, such as SUM, AVERAGE, MAX, MIN and COUNT
-Change relative cell references to absolute cell references
-Represent worksheet data in an Excel chart
-Modify the worksheet display
Course content:
Navigating within the Excel environment
-Opening and closing
-Exploring the Excel application window
-Working with Excel toolbars
-Displaying help information
Creating and modifying worksheets and workbooks
-Creating, saving and closing workbooks
-Renaming an existing workbook
-Adding a password to open/modify workbooks
-Inserting and deleting cells, columns and rows
-Selecting using the keyboard and mouse
Editing a worksheet
-Adding/editing data to a worksheet
-Using Auto correct and spell checker
-Working in edit mode
-Reversing an edit operation
-Using drag-and-drop editing
-Copying/moving/deleting cell entries
-Finding and replacing specific entries in a worksheet
-Inserting cell comments
Working with sheet tabs
-Inserting and deleting sheet tabs
-Moving and duplicating sheet tabs
-Renaming and changing the tab colours
Formatting a worksheet
-Adjusting column and ro- size
-Cell alignment options, wrap text, orientation and merge cells
-Formatting font style, size and colour
-Applying borders, patterns and AutoFormats
Enhancing a worksheet printout
-Selecting the worksheet area to print
-Setting the print area
-Printing and previewing worksheets
-Applying additional print optionsGetting started with Excel formulas
-Entering a simple formula into the worksheet
-Formula operators
-Extending the formula over the data range
-Using AutoSum
-The correct use of brackets in formulas
-Understanding BODMAS (order of operation)
Excel functions
-What are functions?
-Using Excel Statistical functions
Additional formulas topics
-Using absolute and relative addressing
-Defining a range name
-Using a range name in a formula
Creating a chart
-Creating charts using the chart wizard
-Formatting the chart
-Adding additional data to the chart
-Including non-contiguous data ranges
-Previewing and printing a chart
Controlling the worksheet display
-Freezing and unfreezing rows and columns
-Applying splits the worksheet
-Views and zooming
-Hiding rows and columns
Introduction to Excel's database tools
-Guidelines on creating a database in Excel
-Sorting a database
-Using AutoFilter
Revie- of Programme
Other Recommended Programmes
-Microsoft Excel Level 2
-Financial Modelling with Microsoft Excel
-Accounting Budgeting and Forecasting
