Microsoft Excel Course for Beginners (1 day)

This 1 day Microsft Excel course is designed for those that have little or no experience with Microsoft Excel. The course covers training in the basics of formatting, navigation, data entry and calculations. Make sure you are comfortable with course content before you move on to the intermediate level course. The outline is only a suggestion and can be tailored to your business needs.

To accompany the instructor lead training, each delegate will receive manuals and practice, step-by-step exercises. This will provide an excellent source of information and on-going self study once the training has been completed.

For pricing click here

To return to the application overview page click here

• Basic calculations
• SUM, MIN, MAX, AVERAGE,COUNT, COUNTA
• Copying formulae
• Absolute referencing
• Mixed referencing
• Naming cells and ranges
• Introduction to IF statements
• Performing calculations with dates and times

• The chart wizard
• Formatting chart elements
• Changing the source data
• Creating a secondary axis
• Saving a custom chart
• Setting a default chart

• Changing column widths and row heights
• Formatting cells for different data types
• Using autoformat for tables
• Format painter
• Styles
• Condtional formatting based on cell values

• Setting a print area
• Getting data to fit the page
• Headers and footers
• Printing rows and/or column headers on every page
• Printing gridlines

• Sorting on multiple columns
• Hiding columns
• Changing column order
• Freezing rows and columns
• Introduction to filters