HOME
 

Excel Intermediate

G Com Solutions
Course summary
1 day
Nationwide
Next available date: Variable depending on group number - United Kingdom
Corporate Training for Teams

Course description

In-house computer training courses

GCom Solutions  - On-Site Computer Training Courses in the UK - One-to-one and group training

This course is designed for beginners and covers: digital Publishing Suite (dps) essential concepts; getting started; folio basics; article basics; working with buttons; working with audio and video; working with animation; working with HTML and web content; working with image-based overlays; working with scrolling content; working with slideshows; linking and navigation; and beyond the basics.

Suitability - Who should attend?

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.

Outcome / Qualification etc.

A G Com Solutions Certificate of Attendance is issued on course completion.

Training Course Content

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

Expenses

£450 for one-to-one training

£550 for groups of up to 6 people

£650 for groups of up to 12 people

About provider

G Com On-Site Computer Training in the UK

G Com Solutions Limited

G Com Solutions design customised and effective training solutions in partnership with our clients; which equip their people with the computer skills necessary to work more productively and effectively. By delivering our training on-site, we are able to save our...


Read more and show all courses with this provider

Contact info

G Com Solutions

Kemp House, City Road
EC1V 2NX London

 Show phone number

U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's first annual U.K. L&D Report!

UK L&D Report

Learn more

 
Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

 
Find more courses here