>

Excel Intermediate Training Course

Excel Training

Excel Intermediate Training Course –  £295 London all Inclusive

  •  1 day Instructor-led
  • Courses never cancelled
  • Restaurant lunch

 

 Who is this course for?

Perfect for users that have become reasonably proficient with the basic functions of excel, this Excel intermediate course provides you with further knowledge of the application and enables you to use advanced tools.

Our Microsoft Excel  Intermediate course is suitable for those with a basic working knowledge of Excel. Recent attendees have included; Finance Manager, Strategist – Client Development, Business Manager, Credit Manager…

This course is designed for delegates who have used Excel before and want to expand their knowledge. Improving formatting, organising data, highlighting key information and creating formulas/links between sheets.

Prerequisites

A working knowledge of creating/formatting simple spreadsheets, basic formulas and functions e.g. AutoSum. Or our Excel Introduction course.

Benefits

  • Quickly summarise multiple tabs of data
  • Turn long lists and reports into easy to read tables
  • Formulas & formatting to show you cells that pass or fail your business rules
  • Save time by converting your frequently used workbooks into templates
  • Connect spreadsheets so that one updates another
  • Get information at a glance with conditional formatting
  • Reduce human error with conditional formulas

Course Syllabus

Working with Large Worksheets

Viewing options
– Adjusting zoom
– Using Freeze Panes
– Using Split Window
Hiding and displaying data
– Hiding rows and columns
– Creating an outline
Printing large worksheets
– Page Break preview
– Working with page breaks
– Printing multiple sheets

Working with Multiple Worksheets and Workbooks

Using multiple worksheets
– Navigating between sheets
– Moving and copying sheets
Linking worksheets
– Creating 3-D formulas
– Consolidating data
Linking workbooks
– Creating a formula to link workbooks
– Using the Paste Link option
– Maintaining links

Working with dates

Entering date functions
– TODAY function
– NOW function
Date and time formats
Using dates in formulas

Conditional formulas and formatting

The IF function
Conditional formatting
– Based on a cell value
– Based on a formula
– Identifying cells with conditional formatting
– Copying conditional formats

List Management

Working with lists
– Structure of a list
Sorting and filtering lists
– Simple sorting
– Sorting by multiple columns
– Using AutoFilter
Advanced filtering
– Using custom filter
– Using Advanced Filter
Adding subtotals to a list

Documenting and Auditing

Comments
– Viewing, adding, editing and deleting comments
Auditing features
– Tracing formula errors
Protection
– Protecting a worksheet
– Protecting cell ranges

Using Templates

Built-in templates
– Accessing and using Excel’s templates
Creating and managing templates
– Creating, using and modifying a custom template file

Please call to check availability 0843 289 1713 or submit an enquiry to book your preferred dates

What you get for just £295

Training roomTraining is held in our modern, comfortable, air-conditioned suitesModern-spec IT, fully networked with internet access

Contact us now and talk to one of our advisers to ask any question you may have about our training.Blue Find Out More

“What do I get on the day?”

Learning tools

Breaks and TimingsBreaks and timing

Courses start at 9:30am.
Please aim to be with us for 9:15am.
Joining information (how to get to our venues)

In-course handbookIn-course handbook

Contains unit objectives, exercises and space to write notes

RefreshmentsRefreshments

Available throughout the day:

  • Hot beverages
  • Clean, filtered water
  • Biscuits
Reference materialReference material

Available online. 100+ pages with step-by-step instructions

LunchLunch

Lunch is provided at a local restaurant or pub. Browse the sample menus:

24 months forum access24 months access to Microsoft trainers

Your questions answered by Microsoft qualified trainers online.

X
X

Send this to a friend