Microsoft Word Advanced Course
1 Day course
On this course you will discover the essential skills needed to create and edit spreadsheets with Microsoft Word.
You will learn to enter and edit data, create simple formulas, format data, and create graphs (charts).
Discover easy ways to get started in Word!
Who is this Microsoft Word Training Course for?
If you are new to Wordor only to formalise the following basic skills: Entering Date, Formatting Data, Basic Formulas, Creating Graphs.
Course Prerequisites
You should have basic knowledge of Microsoft Windows and be able to start an application, get help, and open, close, and save files.
Course Outline - 1 Day
|
|
Screen Familiarity in Excel
- Workbook principles
- Screen layout
Working with Cells in Excel
- Use Undo and Redo
- Selecting cells
- Go to a specific cell
- Find & Replace
- Cut, copy, paste, and move cells
Inserting & Deleting in Excel
- Insert and delete rows and columns
Autofill
- Copying cells
- Work with series (AutoFill)
Simple Formulas and Functions in Excel
- Mathematical Operators (+. -, *, /)
- BODMAS
- Simple formulas
- Use AutoSum
- Use basic functions (AVERAGE, SUM, COUNT, MIN, and MAX)
- Relative and Absolute cell referencing
|
Formatting Worksheets in Excel
- Apply font styles
- Apply predefined number formats
- Modify row and column size
- Modify alignment of cell content
- Use the Format Painter
- Apply cell borders and shading
- Merge cells
- Wrap text
Creating Charts in Excel
- Types of chart
- Column, Line & Pie Charts
- Use the Chart Wizard to create a chart
- Preview and print charts
- Simple Formatting
- Chart Options
Printing in Excel
- Preview and print a selection, worksheets, workbooks
- Change page orientation and scaling
- Set page margins and centering
- Insert and remove a page break
- Set print, and clear a print area
- Set up headers and footers
- Set print titles and options
|
