Excel 2013 Intermediate
Training
In Aberdeen
Description
-
Type
Training
-
Location
Aberdeen (Scotland)
-
Duration
1 Day
Microsoft Excel is a spreadsheet application that incorporates tools for assisting in the recording and analysis of numerical data and which has the ability of turning numerical data into charts. This functionality, combined with many powerful and sophisticated features allow the creation, manipulation, editing, printing and storage of workbooks.
Facilities
Location
Start date
Start date
About this course
Excel Intermediate will allow you to gain the skills necessary to:
Create functions to analyse and manage your data
Sort and filter to find and organise data
Format your data to present or track your data
Protect your workbooks
Create charts to present your data.
Delegates wishing to attend this course should have completed our MS Excel 2013 Foundation Course or Work regularly with MS Excel 2013 and be able to insert, delete, resize columns and rows, copy and paste, write basic formulas (add, subtract, divide and multiply) and format worksheets.
Reviews
Subjects
- Excel
- MS Excel
- Excel 2013
- Date Functions
- Criteria
- Vlookup
- Flash fill
- Columns
- Freezing Rows
- Protection
- Intermediate
Course programme
1-Day Instructor-led classroom based training.
COURSE OUTLINE
- Module 1: Working with Date Functions
- Module 2: Counting and Summing based on Criteria
- Module 3: Defined Names
- Module 4: Vlookup
- Module 5: Flash Fill
- Module 6: Freezing Rows and Columns
- Module 7: Conditional Formatting
- Module 8: Sorting and Filtering
- Module 9: Protection
- Module 10: Charts
- Module 11: Chart Elements and Formatting
- Module 12: Quick Analysis
Knowledge of Windows and experience with a PC is presumed, therefore, it is advisable to register participants on our “Introduction to Computing” or “Microsoft Windows” course prior to attending, should this experience be lacking.
Excel 2013 Intermediate