Microsoft Office Training

Course Information

  • Course Code: BC925
  • Times: -
  • Delivery Type: PT

Start Dates

  • Start Date: Start Anytime

Book Now Print

Overview

Our brand new Microsoft Office Training courses have just been released.  Courses will be delivered on Office 2013 but are also suitable for Office 2010 users. 

Most of our courses (other than Outlook level 1) are delivered over a full day at our business suite for groups between 8 and 10 people at a cost per day, per application of £99.00. 

Dates have been released for Excel at all levels and can be booked on our website or by contacting us for an application pack.  If you are interested in Word, Powerpoint or Outlook, please speak to us on 01254 292500 and we’ll add your name to our waiting list in readiness for release of dates.

Bespoke Requirements:  We also offer all of the below courses on a bespoke basis for businesses at dates and times mutually convenient, if this would be of interest please contact us on 01254 292500 or business@blackburn.ac.uk to discuss further and we’ll organise a quotation based on your requirements.

What will I study?

Microsoft Excel

Excel Introduction:  This 1-day course is best suited to those who are new to Microsoft Excel and need an introduction to basic functions and usability of the application:

  • Tour the window, entering and editing data, range names, autocomplete and autofill, undo and redo, getting help
  • Save a workbook, password protection, working with sheets, columns and rows, copy and move data
  • text and number formatting, borders and cell styles, functions and formulas, relevant referencing, BODMAS, graphs and charts
  • Spell check, headers and footers, page setup, print preview, printing options

 

Excel Intermediate:  So, you’ve mastered basic excel but you want to learn more about the application and delve a little deeper into its functionality:

  • Customise quick access toolbar, database rules, Sort a database, multiple sorting, find and replace data
  • Using the dataform, autofilter, conditional criteria, top 10fFilters, advanced filters
  • Text to columns, merge cell data, database functions, formula and command linking, linking workbooks, hyperlinking
  • Protect sheets, protect cells, protect workbook, freeze panes, working with comments

 

Excel Advanced:  For those students who are conversant with the above modules (or who have already completed the intermediate course), please see below:

  • Scenario manager, IF Functions, IF/OR Functions, IF/AND Functions, Nested IF
  • AND Function, OR Function, NOT Function, COUNT/IF Function, SUM/IF Function, NOW/TODAY Function
  • Pivot tables, HLookup, VLookup, Data list, Conditional formatting, Data validation
  • Record a macro, assign a macro, edit a macro (vba), advanced macro, create a macro button

 

Microsoft Word

Foundation Word:  New to Word or just not 100% sure about some of the functionality of the application?  This is the course for you:

  • Tour the window, using the keyboard, create a document, undo and redo, save a document, getting help               
  • Selecting text, formatting text, formatting paragraphs, bullets and numbers, using tabs
  • AutoCorrect options, cut, copy and paste, insert clipart, modify clipart, insert wordart
  • Spelling and grammar, headers and footers, page setup, print preview, printing options

 

Intermediate Word:  You know the basics but need to master Word a little better to help you both personally and in your business?

  • Create a custom toolbar, autotext options, use special symbols, find and replace, use a wildcard         
  • Newsletter style columns, modify columns, create tables, format a table, table autoformat, insert an excel chart
  • Footnotes and endnotes, add a bookmark, insert hyperlinks, create a cross reference, table of contents               
  • Sort records, locate records, mail merge, create labels, create envelopes

            

Advanced Word:  Find out how to master the functions of Word on this course.

  • Working with styles, change the default normal style, create a style, creating and using templates, standard documents using templates  
  • Using outline view, promoting and demoting, collapsing and expanding, numbering sections, track changes, view document statistics         
  • Creating forms, using forms, inserting and updating fields, viewing results and field codes, editing, formatting and locking fields    
  • Creating a macro, replaying a macro, editing a macro, creating a macro to open a document, modifying a macro button, deleting macros

 

PowerPoint

Foundation PowerPoint:  Have you been asked to do a presentation at work or for an interview possibly but you’re not really conversant with the PowerPoint?  Why not attend this course then you’re prepared for next time?

  • Create using a blank presentation, tour the window, use design templates, getting help, inserting slides/change layout     
  • Save a presentation, format text, format paragraphs, bullets and numbers, use a table slide, use a chart slide
  • Insert ClipArt, Insert WordArt, Insert SmartArt, cut, copy and paste, create a master slide
  • Spell check, headers and footers, page setup, print preview, printing options

 

Advanced PowerPoint:  We’ve all heard the phase ‘Death by Powerpoint’, attend this course to learn how to make your presentation just that little bit more interesting

  • Create a presentation, use the outline view, apply colour schemes, use slide sorter view, create notes
  • Create an organisation chart, use the drawing toolbar, change drawing attributes, group and ungroup, manipulate and format objects
  • Use the style checker, send a presentation to word, insert excel database, insert excel chart, create hyperlinks, action buttons
  • Insert a movie, add transitions and sound, use custom animation, create a summery slide, create a macro, create a macro button

  

Our Outlook courses are delivered on 2010 version, as follows:

 

Level 1 Outlook 2010 (Half Day)

  • Tour the window, create a message, reply to a message, insert an attachment, forward a message, importance/sensitivity

 

Level 2 Outlook 2010 (Full Day)

  • Use voting buttons, request receipts, delivery options, flagging a message, insert a signature
  • Create a distribution list, create personal folders, rules and alerts, categorise, the out of office assistant, deleting items efficiently
  • Use the calendar view, create events and appointments, create recurring, Appointments, schedule a meeting, change appointment, event or meeting
  • Create a contact, create a task, assign a task, sharing calendar, contacts and tasks, the notes view

 

Your course tutor will review your progress throughout the sessions for all applications.

 

Most of our courses (other than Outlook level 1) are delivered over a full day at our business suite for groups between 8 and 10 people at a cost per day, per application of £99.00.   Dates have been released for Excel at all levels and can be booked on our website or by contacting us for an application pack.  If you are interested in Word, Powerpoint or Outlook, please speak to us on 01254 292500 and we’ll add your name to our waiting list in readiness for release of dates.

Entry Requirements

It is the responsibility of the student to ensure that they are booking onto the correct level of course based on their current level of understanding of the application.  We would ask that students have basic computer skills and have a good command of English.   Please also note that you will need access (on a desktop computer) to your personal email address during the course so please ensure you have your password with you.

How will I be assessed?

There is no formal assessment however students will receive feedback from their course tutor on the day.

What can I do next?

Contact us on 01252 292500 or email business@blackburn.ac.uk for more information or book and pay online for one of our Excel courses!

For more information

For more information about this course, contact our specialist team on 01254 29 25 00 or email business@blackburn.ac.uk

Book Now Print