Introductory Microsoft Excel 2013 Training Courses
Short course
In Twickenham
Description
-
Type
Short course
-
Location
Twickenham
-
Duration
1 Day
-
Start date
Different dates available
This course aims to introduce delegates with little or no understanding of the Microsoft Excel software to the basic features of the package.
Facilities
Location
Start date
Start date
About this course
On completion of the course delegates should understand and be able to accomplish basic operations associated with developing, formatting and using a spreadsheet. They should also be able to accomplish standard mathematical and logical operations using basic formulae and functions. They should also be able to use some of the more advanced Microsoft Excel applications such as importing objects, and creating graphs and charts.
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 14 years
Subjects
- Excel
- MS Excel
- Microsoft excel training
- Microsoft Excel
- Spreadsheet
- Printing
- Formatting
- Cells
- Text size
- Bold
- Italic
- Font type
- Font colour
- Text orientation
- Sorting Data
- Inserting Data
- Selecting Data
- Columns<br />
Course programme
•First Steps with Microsoft Excel - opening, creating a new spreadsheet, saving, closing, using Help functions, converting documents, compatibility checker, switching between open worksheets and workbooks
•Adjusting Basic Settings - changing spreadsheet view mode, using the zoom tool, Quick Access toolbar, freezing and unfreezing row and/or column titles, modifying basic operations in Excel such as username and the default directories for opening and saving workbooks
Cells
•Inserting Data – entering a number, date, text in a cell
•Selecting Data - cells, range of adjacent or non-adjacent cells, rows, columns
•Copying, Moving, Deleting
•Editing Data – Inserting additional cell content, replacing existing cell content, using the undo and redo buttons
•Finding and Replacing
•Rows and Columns - inserting rows and columns, modifying row height and cell width, deleting rows and columns
•Sorting Data
Worksheets
•Handling worksheets – inserting a new worksheet, renaming a worksheet, deleting a worksheet, copying worksheets, moving worksheets
Formulae and Functions
•Arithmetic and Logical Formulae - addition, subtraction, multiplication, division, standard error messages
•Cell referencing - relative cell referencing, absolute cell referencing, mixed cell referencing
•Working with Functions - sum, average, minimum, maximum, count, if
•Formula AutoComplete
Formatting
•Formatting Numbers and Dates - number of decimal places, commas to indicate thousands, number of zeros after the decimal point, date styles, currency, percentages
•Formatting Cells - text size, bold, italic, font type, underline, double underline, font colour, text orientation, cell background colour, format painter
•Formatting Cell Ranges - centring and aligning cell contents, centring a title over a cell range, adding border effects
•Cell styles
•Applying table formats
Charts and Graphs
•Using charts/graphs – producing different types of graphs and charts to analyse data, editing or modifying charts or graphs, changing chart type, moving and deleting charts or graphs
Preparing Outputs
•Worksheet Setup – modifying worksheet margin settings, adjusting worksheet setup to fit one page, adding a header and footer, changing document orientation, page size, etc.
•Spelling
•Print Preview and Print Break Preview
•Applying automatic title rows printing on every page of a worksheet
•Printing Simple Worksheets – using print options, previewing a spreadsheet, printing a spreadsheet or a worksheet, printing part of a worksheet or a pre-defined cell range
Additional information
1 to 1 training £295
2 to 4 delegates £455
5 to 8 delegates £595
Prices are PER DAY, and NOT per-person! E.g. if there’s 5 people on the course, you pay £595. All prices exclude VAT
Introductory Microsoft Excel 2013 Training Courses