Excel Intermediate Training
Training
In London
Description
-
Type
Training
-
Level
Intermediate
-
Location
London
-
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
Reviews
Subjects
- Excel
- Graphics
- Layout
- Financial
- Financial Training
- MS Excel
- Filtering
- Deleting Rows
- Totaling Data
- Chart Text
Course programme
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 ChartsCreating 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 GraphicsAdding 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 CollaborationE-Mailing A Workbook, Web Page Preview, Converting Worksheets Into Web Pages, Inserting Hyperlinks, Viewing And Editing Comments
Financial & Logical FunctionsUsing The If Function, Using Nested Functions, Using The Pmt Function, Using The Fv Function, Using Autocalculate
Date And Time FunctionsUnderstanding Date/Time Functions, Adding A Date And A Date Interval, Subtracting Dates, Calculating Time Intervals
Managing WorkbooksCreating 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
Excel Intermediate Training