Excel 2013 Training
Brief Description: You will create and edit basic Microsoft Office Excel 2013 worksheets and workbooks.
Duration: 1 day
Who Should Attend:
Delegates who are not familiar with Excel and would like to learn the basic functions of the package.
Description:
This Excel 2013 level 1 (or introduction) course covers all the basics you need to start entering your data and building organised workbooks.
Participants will:
- Get started with Excel 2013
- Create a basic worksheet
- Modify a workbook
- Use formulas and functions
- Format an Excel worksheet
- Manage worksheets and workbooks
- Set up printing options
Course Content:
Module 1: Getting Started with Excel 2013
- Excel and the Excel Environment
- Navigate and Select in Worksheets
- Create a Basic Workbook
- Open, Save and Close Workbooks
- Use Microsoft Help
Module 2: Modifying a Workbook
- Cut, Copy and Paste Commands
- Flash Fill
- AutoFill Options
- Find and Replace
- Spelling
- Undo and Redo
- Insert and Delete Options
- Column Width and Row Height
- Hide and Unhide Options
Module 3: Using Formulas and Functions
- Create Relative Formulas
- Mixed Cell References
- AutoCalculate
- Insert Functions
- Use AutoSum
- Copy Formulas
- Create Absolute Formulas
Module 4: Formatting an Excel Worksheet
- Font Group
- Add Borders and Fill Colours
- Cell Alignment
- Number Formatting
- Cell Styles and Galleries
Module 5: Managing Worksheets and Workbooks
- Manage Worksheets
- View Worksheets and Workbooks
Module 6: Printing Options
- Print Pane
- Print Worksheets and Workbooks
- Page Setup
- Print Layout View
Pre-requisites
Delegates will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should be comfortable in the Windows environment, and be able to use Windows to manage information on their computers. Specific tasks the students should be able to perform include: launching and closing applications, navigating basic file structures, and managing files and folders.