Microsoft Excel Advanced Course
1 Day course
On this Course you will discover some really useful tools to help you understand some of Excel's more advanced functions.
Discover the power of Excel's more advanced functions
Who is this Microsoft Excel Training Course for?
If you are new to Excel or 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
|
