Skip Main Navigation
Page Content

Save This Event

Event Saved

Microsoft Excel Intermediate

G Com Solutions Limited

Monday, 6 November 2017 from 09:30 to 16:30 (GMT)

Microsoft Excel Intermediate
Available Dates

Ticket Information

Ticket Type Sales End Price Fee VAT Quantity
Microsoft Excel Intermediate 6 Nov 2017 £187.93 £7.07 £39.00

Who's Going

Loading your connections...

Share Microsoft Excel Intermediate

Event Details

This course is suitable for those with prior experience of usng Microsoft Excel 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.

The Excel Intermediate course is held in Peterborough at the following address:

Pinnacle House
4-5 Newark Rd
Peterborough
PE1 5WS.

Our training centre is a short taxi ride from Peterborough station; and we will be happy to reimburse your taxi fares; or, if you prefer to travel by car, we have plenty of free parking available at our training centre. And, naturally, we provide lunch and refreshments to all delegates attending our courses.

Course Outline

This course is suitable for those with prior experience and covers: working with tables;

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

Do you have questions about Microsoft Excel Intermediate? Contact G Com Solutions Limited

Save This Event

Event Saved

When & Where


Peterborough
Pinnacle House
4-5 Newark Rd
PE1 5WS Peterborough
United Kingdom

Monday, 6 November 2017 from 09:30 to 16:30 (GMT)


  Add to my calendar

Organiser

G Com Solutions Limited

G Com Solutions specialise in providing Microsoft Power BI training, as well as IT training on a variety of web technologies and computer software packages, especially those by Microsoft and Adobe. These software environments have become the standard for business, web and multimedia development since they empower companies to develop web solutions more quickly than ever.

Whether you need IT training as an IT specialist or as one of the many people who need computer training to improve their skills for career advancement, G Com Solutions courses can help you. 

  Contact the Organiser

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.