Microsoft Excel Courses in Cardiff & Bridgend

Begin your journey toward becoming proficient in creating professional spreadsheets in Excel. Our one day introduction, intermediate and advanced Microsoft Excel courses give you the ability to create a worksheet, add and edit data and images, and save for printing in various formats. Discover the various built-in math, financial, and text related functions that Excel provides. These courses are aimed at users who would like to develop more of an understanding of the more technically challenging components of Excel.


Microsoft Excel

Microsoft Excel - Course Dates 2017-2018

Dec: 14, 18, 20, 22
Jan: 5, 10, 12, 15, 18, 19, 23, 25, 30, 31
Feb: 1, 2, 6, 9, 12, 14

Microsoft Excel - Beginner Course

EnquireEnquire CardiffFurther Info BridgendFurther Info Download PDFDownload PDF

Price: £175.00 | Duration: 1 Day | Ref: ME1 | Venue: Cardiff & Bridgend


What is this course about?

Excel is a powerful piece of software within the office suite, and this course will show you how to get the most out of it. You will learn how to navigate the ribbon and tab interface. The course covers the difference between text data, numerical data, and formulas and functions. Learn to set-up your own spreadsheets and develop your skills to present your work clearly by making the most of Excel's features. You will develop your skills to present your work clearly by learning how to create purchase orders, bank statements and compile sales figures. You will learn the knowledge to manipulate data by inserting rows, columns and sheets as well as how to move, copy and delete data.


Microsoft Excel - Course Content

  • Learn to set up spreadsheets from new

  • Learn how to enter data, basic formulas and functions

  • Managing printing and spreadsheet layouts

  • Explore the various user interface elements

  • Getting going with formulas and functions

  • Use the Excel galleries

  • Customise the interface

  • Creating, opening and saving a workbook

  • Creating forms with Excel

  • Utilising Excel help

  • Replicate formulas & functions

  • Create an absolute reference

  • Range names and how they are applied

  • Setting up data for printing

  • Recording the current date and time on the printed spreadsheet

  • Turning your figures in to charts

  • Formatting charts


Who is this course for?

This course is suitable for beginners who needs to understand the way Excel works or those who have some self-taught knowledge but want to know how to use Excel more efficiently for day-to-day tasks.


Microsoft Excel - Intermediate Course

EnquireEnquire CardiffFurther Info BridgendFurther Info

Price: £175.00 | Duration: 1 Day | Ref: ME2 | Venue: Cardiff & Bridgend


What is this course about?

This course follows on from our Introduction to Excel course and will guide you through all the new features. It covers more complex formulas and functions, such as the improved conditional formatting features, lookup functions and new filtering options.


Microsoft Excel - Course Content

  • Absolute cell references

  • Naming cells and ranges

  • Referring to named cells and ranges in formulae

  • Editing named cells and ranges

  • Setting up entire workbooks with group editing

  • Using VLOOKUP & HLOOKUP statements to retrieve data

  • Editing lookups and ensuring accuracy in returned data

  • Linking spreadsheets and workbooks together with formulas and functions

  • Utilising If statements to assist decision making

  • If statements and calculations

  • Analysing data with the all new conditional formatting features

  • Databases in Excel understanding fields and records

  • Sorting data numerically and alphabetically

  • Filtering data for range and precision analysis

  • Setting up data validation to ensure integrity of the data

  • Attaching security to a spreadsheet

  • Selective protection i.e. protecting formulas while allowing data entry

  • Setting up and utilising templates

  • Creating and formatting charts

  • Adding trend lines to the chart

  • Utilising custom chart types


Who is this course for?

This intermediate course is designed for users who have attended an introductory level course or are already confident in the basic features of Microsoft Excel.


Microsoft Excel - Advanced Course

EnquireEnquire CardiffFurther Info BridgendFurther Info

Price: £175.00 | Duration: 1 Day | Ref: ME3 | Venue: Cardiff & Bridgend


What is this course about?

This course focuses on the more advanced functions within Microsoft Excel is focused on manipulating and analysing data. This course covers in detail how to normalise data and analyse it with Pivot Table, importing data using queries, preparing and analysing data with What If functions and scenario building. You will learn how to record and run your own macros in order to automate tasks within Excel, together with the skills to import data, prepare it and set up pivot tables to analyse it. You will learn the knowledge to record macros and create icons on the toolbars to run them. Finally you will learn the ability to use analysis tools to forecast figures based on a range of scenarios.


Microsoft Excel - Course Content

  • Text functions in Excel

  • Count functions

  • Advanced 'If' statements

  • Create a pivot table reports from new

  • Analysing data with pivot tables

  • Manipulating pivot tables

  • Formatting pivot tables

  • Creating pivot charts

  • Trace cell precedents & cell dependents

  • Goal seek to reverse calculate a formula

  • Creating single input data tables

  • Setting up and manipulating scenarios for What-If? analysis

  • Consolidating data by position

  • Group and outline features

  • Importing text files

  • Setting up database queries

  • Recording macros

  • Editing macros

  • Creating buttons to run macros

  • Customising access to Excel commands

  • Adding icons to the toolbars

  • Creating a custom tab

  • Adding options to menus to run macros


Who is this course for?

This course is aimed at learners who have a good grounding in Excel either from experience or attending our Intermediate Microsoft Excel training course. If your job involves manipulating and analysing data in Excel, you will find this course very useful. You will also find it helpful if you spend most of your working day using Excel and would like to fill in gaps in your knowledge.


Client List

Have a Question?

If you have any questions regarding our training courses then please feel free to call us on 01656 737349 from Monday to Friday from 8.30am to 4:30pm. Or complete the contact form.


ContactArrow

Faqs

Customised Content

We will work with you to develop the material to ensure it reaches the knowledge and expertise your staff require. We can tailor learning objectives so you get exactly the right course delivered for you.


Learn moreArrow

Training Brochure 2017

Training Brochure 2017

Download our latest training brochure for 2017. Includes our Wellbeing, Core Skills, ICT and Technical courses.


DownloadArrow

One-2-One

One-2-One Training

We provide one-2-one training for a number of our courses. This training is easy to arrange and can be tailored to meet your exact requirements. All of our training is conducted in a relaxed learning atmosphere.


Learn moreArrow

In-house training

In-House Training

If several people in your organisation need this Microsoft Excel course then an in-house programme is likely to be the most effective training option. Our in-house programmes are simple to arrange and training can be run from your own premises or we will help you select a suitable venue offsite. With all our training courses there are no hidden costs.


Get quotesArrow

PayPal Acceptance Mark