This course introduces you to Excel spreadsheets and how they are used in business. You will learn to create, edit, format and print professional looking spreadsheets using simple formulas.
Course Outline
- Duration: 1 day
- Target Audience: This course will suit you if you are a beginner and are just getting started with Excel.
- Prerequisites: Successful completion of Nom@d Learning Computer Fundamentals course or equivalent knowledge and skills are required to participate in this course.
- Versions: This course is suitable for users of Excel 2010, 2013, 2016.
Learning Outcomes:
- Start and explore Excel
- Navigate around the workbook
- Enter and edit data
- Use simple formulas
- Manipulate data
- Format data
- Preview and print data
Getting to know Excel
- The Excel screen
- Using short cut menus
- Launching Dialog Boxes
Creating a new workbook
- Typing text, numbers, dates and formulas
- Making basic changes
Working with workbooks
- Navigating using the keyboard
- Using Go To
Editing in a workbook
- Editing formulas
- Clearing and deleting data in a cell
- Using Undo and Redo
Selecting ranges
- Selecting contiguous and noncontiguous ranges
- Using special selection techniques
- Selecting larger ranges
Copying data
- Using Fill for quick copying
- Copying from one range to another
- Copying to another worksheet
Filling data
- Filling a series
- Filling using options
- Creating a custom Fill list
Formulas and Functions
- Creating formulas that add and subtract
- Creating formulas that multiply and divide
- Using the Sum Function to add
- Finding an average
- Finding a maximum and a minimum value
- Common error messages
Font formatting
- Changing fonts
- Making text bold, italicised and underlined
- Changing font colours
- Using the Format Painter
Cell alignment
- Aligning left, right and centre
- Rotating, indenting, wrapping and merging text
Row and column formatting
- Setting columns widths and row heights
- Hiding rows and columns
Number formatting
- Formatting as currency
- Formatting percentages
- Increasing and decreasing decimals
Printing
- Previewing and printing a range
- Printing an entire workbook
Applying borders
- Applying a border to a range
- Removing borders
Working with a worksheet
- Worksheet zooming
- Inserting, deleting, moving, copying and renaming a worksheets
- Switching between worksheets
Worksheet techniques
- Inserting, deleting, moving, copying and renaming a worksheet
- Grouping worksheets
- Freezing rows and columns
Page Setup
- Page breaks
- Settings rows as repeating print titles
- Scaling to a percentage
Getting Help
- Browsing for help
Cost
AUD$ 350 per person (in groups of three) at your premises.
AUD$ 600 (one-to-one) at your premises.
For details and next available dates, leave a message below or contact me at my LinkedIn page.
Leave a Reply