Show e-learning-courses.co.uk as: Mobile
Course summary
24 hours
Open / Scheduled
Next available date: Contact for info - Distance
Course Dates
Aberdeen
Contact for info 
Birmingham
Contact for info 
Bishop's Stortford
Contact for info 

Course description

Microsoft Excel Beginner to Intermediate Course by Pitman Training

Get to grips with the world's most popular spreadsheet program with this flexible self-paced Pitman Training course. Whether you're using Microsoft Excel for business or personal budgeting, this course will equip you with the fundamental skills you need to navigate your way around the software with ease. It will also demonstrate to employers that you have proven skills and practical experience in this widely used program.

The course comprises ten self-paced lessons, covering essential areas including:

  • creating worksheets
  • formatting text
  • simple and complex formulas
  • handling rows and columns
  • autocomplete
  • using styles, headers and footers,
  • average, max and min functions
  • using charts

On completion of the course participants will have the confidence to put their enhanced Excel skills into practice.

You can train on Microsoft Office 2010, 2013 or 2016!

Suitability - Who should attend?

This course is suitable for beginner to intermediate level Excel users.

It would suit a wide range of professionals working with Excel, such as those who need to maintain customer data, manage accounts and maintain budgets.

Outcome / Qualification etc.

You will be awarded 24 CPD points upon successful completion of this course.

If you are looking for a qualification, this course is designed to prepare you for the City & Guilds Spreadsheet Processing Techniques Intermediate Exam, MCAS test and ECDL Advanced Spreadsheet exam.

Training Course Content

** Latest Microsoft Office version of Excel, 2016 now available! ** 

The Excel 2010 and 2013 courses are very similar. The lessons in the Excel 2013 course include:

  • Lesson One

    Opening the Excel 2013 program, identifying the elements of the opening screen, creating a worksheet with text and numbers, entering addition formulas, adjusting column widths, using the SUM function in a formula, using the AutoSum feature, editing text and numbers, navigating a workbook and worksheets, saving, naming and closing a workbook, opening an existing workbook, exiting Excel.
  • Lesson Two

    Applying bold, italic and underline formats, changing font type and size, using the mini toolbar, changing the font colour, selecting and formatting cells ranges, selecting columns and rows, aligning cell contents horizontally, using merge and centre, applying number formats, printing the active worksheet, creating a new folder, saving a workbook with a different name and file type, viewing files in the open dialog box, using AutoFill, entering formulas for subtraction, multiplication, division and percentages.
  • Lesson Three

    Inserting and deleting rows and columns, hiding and unhiding rows and columns, minimising the ribbon, modifying column widths and row heights, aligning cell contents vertically, wrapping and indenting text, applying a fill colour, applying borders, undo and redo, moving and copying cell contents using drag and drop, moving and copying cell contents using cut, copy and paste, copying formats using format painter, clearing formats.
  • Lesson Four

    Using AutoComplete, changing text orientation, selecting non-adjacent data, freezing and unfreezing panes horizontally and vertically, using Zoom, page break preview, page layout view, naming a worksheet, inserting and deleting a worksheet, repositioning worksheets, using the count function, saving a workbook as a template, creating a workbook from a template, online templates.
  • Lesson Five

    Using styles to format a worksheet, creating a custom cell style, using themes to format a workbook, creating and saving a custom theme, deleting a custom theme, page orientation, adjusting margins and scaling, centring the sheet horizontally and vertically, print preview and print a worksheet, viewing/hiding gridlines and row and column headings, printing gridlines and row and column headings, setting and clearing a print area, using COUNT, AVERAGE, MAX and MIN functions, using Quick  Analysis, sorting columns in ascending and descending order.
  • Lesson Six

    Inserting and formatting headers and footers, inserting header and footer codes including date, page number and file name,  copying and pasting data between worksheets, grouping and formatting multiple worksheets, switching between workbooks, viewing multiple workbooks, inserting and applying styles to a column, line and pie chart, using recommended charts, changing chart type.
  • Lesson Seven

    Creating more complex formulas, calculating percentages, making a cell reference absolute and knowing when this is needed, displaying all formulas on a worksheet, customising and viewing calculations in the status bar, the insert function dialog box, using the NOW, TODAY and IF functions, the function library, adding, viewing and editing comments, adding and deleting a button on the Quick Access toolbar.
  • Lesson Eight

    Displaying a hidden worksheet, using the PMT and FV functions, recognising errors, using the IFERROR function, creating 3D formulas.
  • Lesson Nine

    Inserting column, line and pie charts, moving a chart to a new worksheet, add, reposition and remove chart elements,  adding and removing a data table, switching chart rows/columns, changing chart layout options, selecting and formatting chart elements , inserting sparklines, inserting moving, resizing and rotating pictures, making picture ‘corrections’ and applying picture styles and effects, aligning multiple objects, inserting and formatting WordArt, inserting and modifying shapes, creating and modifying SmartArt.
  • Lesson Ten

    Using Spell check text in a worksheet, using Filter to display specific data, finding and replacing text and formats within a worksheet, saving a workbook as a web page,  inserting and using hyperlinks in a worksheet, using conditional formatting in a worksheet, customising the ribbon.

Expenses

Contact Pitman Training for pricing information.

About provider

Pitman Training offers a unique combination of benefits to students, giving them a training experience that will boost confidence and enhance skills, whether you are interested in secretarial, Microsoft Office, keyboard skills, book-keeping and accounts or IT training. Sir Isaac Pitman...


Read more and show all courses with this provider

Contact info

Pitman Training Group

Fairfax House, Walkers Court, Audby Lane
LS22 7FD Wetherby

 Show phone number
www.pitman-training.com