Intermediate 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 give delegates a greater understanding of MS Excel 2013.
Facilities
Location
Start date
Start date
About this course
On completion of the course delegates will have improved their skills in using Microsoft Excel 2013. They will be able to:
Manipulate worksheets
Apply conditional formatting
Use various functions, including financial, logical and date/time functions
Manage Excel tables
Customise charts
Use Excel in conjunction with other applications
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
- MS Excel
- Excel
- Microsoft excel training
- Microsoft Excel
- Structured references
- Sorting
- Worksheets
- Table quick styles
- Excel table
- Nested functions
- Database functions
- Lookup functions
- Financial functions
- Statistical functions
- Mathematical Functions
- Formula AutoComplete
Course programme
Data - naming cell ranges in a worksheet, the Name Manager, importing text files, using Paste Special options
Formatting - applying formatting to a cell range by the use of styles, creating custom number formats, using conditional formatting options
Display - inserting a new worksheet, renaming a worksheet, deleting a worksheet, adding colour to worksheet tabs, formatting worksheet backgrounds, freezing row and/or column titles, splitting worksheet window into panes, freezing panes, hiding/unhiding rows and columns, hiding/unhiding worksheets, grouping and ungrouping worksheets
Using subtotalling features
Linking - Linking data within a worksheet, between worksheets and between workbooks, link charts within a worksheet, between worksheets and between workbooks, linking to a word-processing documents, consolidating data in adjacent worksheets using a 3D sum function
Charts and graphs - Changing angle of pie chart slices, formatting chart axes numbers or text, re-positioning title, legend or data labels in a chart, 'exploding' all the segments in a pie chart, adding or deleting a data series in a chart, modifying the chart type for a defined data series, widening the gap between columns or bars in a 2D chart, inserting an image in a 2D chart
Functions
Resizing the Formula Bar, Formula AutoComplete
Using date and time functions: TODAY, DAY, MONTH, YEAR
Using mathematical functions: SUMIF, SUMIFS, ROUND
Using statistical functions: COUNT, COUNT, COUNTBLANK, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS
Using text functions: PROPER, UPPER, LOWER, CONCATENATE
Converting text to columns
Using financial functions: FV, NPV, PMT, PV, RATE
Using lookup functions: IF, AND, OR, ISERROR
Using available database functions: DSUM, DMIN, DMAX and DCOUNT
Using nested functions
Excel tables
Creating an Excel table
Editing an Excel table
Table quick styles
Inserting and deleting rows and columns in tables
Sorting
Using the AutoFilter with tables
Totals
Removing duplicate rows from worksheets
Creating a dropdown list for table entry
Structured references
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
Intermediate Microsoft Excel 2013 Training Courses