0118 324 3000
Basket
DID YOU KNOW? You can attend any of our instructor-led courses from home. No Travel required!
For more information contact us today:
Call: 0118 324 3000
Email:request@systematix.co.uk
Course Information
Overview
This course will provide you with the foundational Excel knowledge and skills necessary for business today. As you apply the robust functionality that's part of Excel to your organization's raw data, you will be able to gain a level of insight into that data that would have been almost impossible years ago. Excel helps you organize, calculate, analyze, revise, amend, and present your data in ways that will help you and the decision makers in your organization steer forward in the right direction
Course Requirements
Learners must be confident using a mouse and keyboards
What will you learn
In particular you will be able to:
- Get working with Microsoft Excel efficiently and effectively
- Optimize your worksheets by creating and using formulas
- Modify worksheets to manipulate and edit data
- Format and style worksheets to get more impact from data
- Produce printed workbooks
Outline
- Starting Excel
- Selecting the Blank Worksheet Template
- The Excel Cell Referencing System
- Entering Numbers and Text
- Default Text and Number Alignment
- Summing a Column of Numbers
- Entering a Date
- Worksheets and Workbooks
- Saving a Workbook to Your Hard Disk
- Closing a Workbook
- Creating a New Workbook
- Opening a Workbook
- Opening a Recently Used Workbook
- Pinning Files and Folders
- Switching between Workbooks
- Saving a Workbook Using another Name
- Saving a Workbook Using a Different File Type
- Getting Help within Excel
- Searching For Help
- The Help 'Table of Contents'
- Printing a Help Topic
- Alt Key Help
- Using Other Excel Templates
- Why Are Selection Techniques Important?
- Selecting a Cell
- Selecting a Range of Connecting Cells
- Selecting a Range of Non-Connecting Cells
- Selecting the Entire Worksheet
- Selecting a Row
- Selecting a Range of Connecting Rows
- Selecting a Range of Non-ConnectedRows
- Selecting a Column
- Selecting a Range of Connecting Columns
- Selecting a Range of Non-Connecting Columns
- Recommended Techniques When Creating or Editing Lists
- Inserting Rows into a Worksheet
- Inserting Columns into a Worksheet
- Deleting Rows within a Worksheet
- Deleting Columns within a Worksheet
- Modifying Column Widths
- Modifying Column Widths Using 'Drag and Drop'
- Automatically Resizing the Column Width to Fit Contents
- Modifying Row Heights
- Copying a Cell or Range Contents within a Workbook
- Deleting Cell Contents
- Moving the Contents of a Cell or Range within a Workbook
- Editing Cell Content
- Undo and Redo
- Copying Data between Worksheets (Within the Same Workbook)
- Moving Data between Worksheets (Within the Same Workbook)
- Moving Data Worksheets (Between Different Workbooks)
- Copying Data between Worksheets (In Different Workbooks)
- AutoFill
- Copying a Data Range Using AutoFill
- Sorting a Cell Range
- Searching and Replacing Data
- Switching between Worksheets
- Renaming a Worksheet
- Recommended Techniques with Naming Worksheets
- Inserting a New Worksheet
- Deleting a Worksheet
- Copying a Worksheet within a Workbook
- Moving a Worksheet within a Workbook
- Copying or Moving Worksheets between Workbooks
- Font Formatting Options
- Font Type
- Font Size
- Bold, Italic, Underline Formatting
- Cell Border Formatting
- Formatting the Background Colour
- Formatting the Font Colour
- Horizontally Aligning Contents in a Cell Range
- Centring a Title over a Cell Range
- Cell Orientation
- Text Wrapping within a Cell
- Aligning Cell Contents Vertically
- Format Painter
- Number Formatting
- Decimal Point Display
- Applying and Removing Comma Style
- Formatting (To Indicate Thousands)
- Currency Symbol
- Date Styles
- Percentages
- Freezing Row and Column Titles
- Creating Formulas
- The Easy Way to Create Formulas
- Copying Formulas
- Operators
- Using Operators in Formulas
- Formula Error Messages
- Relative Cell Referencing within Formulas
- Absolute Cell Referencing within Formulas
- What Are Functions?
- Common Functions
- Sum Function
- Average Function
- Max Function
- Min Function
- Count Function
- The Count a Function
- The Count blank Function
- What Are 'If Functions'?
- Using the If Function
- Inserting a Column Chart
- Inserting a Line Chart
- Inserting a Bar Chart
- Inserting a Pie Chart
- Resizing a Chart
- Deleting a Chart
- Chart Title or Labels
- Changing the Column, Bar, Line or Pie Slice Colours in a Chart
- Modifying the Legend Fill Colour
- Changing the Chart Type
- Modifying Charts Using the Layout Tab
- Copying and Moving Charts within a Worksheet
- Copying and Moving Charts between Worksheets
- Copying and Moving Charts between Workbooks
- Modifying Basic Excel Options
1 Day
Related Course
Testimonials
Noel was an excellent tutor. He did check all of the group was able to keep up and if there were any problems or questions of the attendants, he was always willing to help.
Marianne Seager-WincantonThis was a really good training, nicely paced, very useful and well presented. Thank you, Stuart!
Joris Latinne-Oracle
Copyright 2019 – Systematix Limited.
Registered England and Wales: 11477692 VAT Number: GB 312 3317 52
All trademarks are owned by their respective owners. Click here for details.