Excel Intermediate
-
The instructor had a lot of knowledge on the subject matter. The rest of the course characteristics were accomplished, such as meeting the objectives, structuring the course, givinf examples, etc.
← | →
-
I recommend this course as the instructor who gives the training is amazing: he knows a lot about the subject matter and his presentation skills are very good.
← | →
-
Overall the course was very good. You could ask the tutor anything and he would give good examples and explanations. The course material was well structured and I avhieved all expectationes I had thought about before starting this course.
← | →
Course
Inhouse
Description
-
Type
Course
-
Level
Advanced
-
Methodology
Inhouse
-
Duration
1 Day
-
Start date
Different dates available
This course is suitable for those with prior experience and covers: working with tables; working with charts; working with graphics; workgroup collaboration; financial & logical functions; financial and logical functions; date and time functions; and managing workbooks.
Facilities
Location
Start date
Start date
About this course
This course is suitable for those with prior experience and covers: working with tables; working with charts; working with graphics; workgroup collaboration; financial & logical functions; financial and logical functions; date and time functions; and managing workbooks.
Reviews
-
The instructor had a lot of knowledge on the subject matter. The rest of the course characteristics were accomplished, such as meeting the objectives, structuring the course, givinf examples, etc.
← | →
-
I recommend this course as the instructor who gives the training is amazing: he knows a lot about the subject matter and his presentation skills are very good.
← | →
-
Overall the course was very good. You could ask the tutor anything and he would give good examples and explanations. The course material was well structured and I avhieved all expectationes I had thought about before starting this course.
← | →
Course rating
Recommended
Centre rating
Anonymous
Anonymous
Ben Fraser
Susan Bodth
Stacey Booth
Sally McDonald
Subjects
- Excel
- IT
- Graphics
- Financial
- Financial Training
- MS Excel
- Excel Intermediate on-site training
- Excel Intermediate in-house training
- Excel Intermediate training
Course programme
This course is suitable for those with prior experience and covers: working with tables; working with charts; working with graphics; workgroup collaboration; financial & logical functions; financial and logical functions; date and time functions; and managing workbooks.
Working With Tables
Creating A Table, Enter Data Into A Table, Deleting Rows And Columns, Formatting A Table, Totaling Data In A Table, Sorting Data In A Table, Sorting Multiple Columns, Filtering Data Using Autofilter, Creating Custom FiltersOn Your Own
Working With Charts
Creating A Chart, Moving A Chart, Resizing A Chart, Changing The Layout And Style, Labeling Chart Elements, Formatting Chart Text, Formatting Chart Elements, Changing The Chart Type, Showing Or Hiding Gridlines, Customizing Axes, Creating A Pie Chart, Changing A Chart€™S Source Data, Moving A Chart To A Different Worksheet, Saving A Chart Template, Filtering Chart Data, Using Sparklines, Customizing Sparklines
Working With Graphics
Adding Clip Art, Adding Pictures, Adding Shapes, Formatting Drawing Objects, Inserting Wordart, Inserting Smartart, Inserting An Organization Chart, Modifying An Organizational Chart, Taking A Screenshot
Workgroup Collaboration
E-Mailing A Workbook, Web Page Preview, Converting Worksheets Into Web Pages, Inserting Hyperlinks, Viewing And Editing Comments
Financial & Logical Functions
Using The If Function, Using Nested Functions, Using The Pmt Function, Using The Fv Function, Using Autocalculate
Date And Time Functions
Understanding Date/Time Functions, Adding A Date And A Date Interval, Subtracting Dates, Calculating Time Intervals
Managing Workbooks
Creating A Workbook Using A Template, Creating A New Template, Editing A Template, Showing Or Hiding Workbook Elements, Creating A Workspace, Comparing Two Workbooks Side By Side, Saving A Workbook In A Different File Format, Using Data Consolidation
Additional information
£450 for one-to-one training
£550 for groups of up to 6 people
£650 for groups of up to 12 people
Excel Intermediate