Microsoft Excel College Certificate

What is special about this course?

This one day course, for Introduction, Intermediate and Advanced levels, will demonstrate the use of Microsoft Excel application and will have plenty of hands-on experience.

Entry requirements

  • No entry requirement.

EXCEL – Introductory

Course Basics

  • Toolbars
  • File Management

Introduction to Microsoft Excel

  • What is Excel?
  • Excel File Types
  • Excel Environment
  • Toolbars
  • Office Assistant
  • Workbooks and Worksheets
  • Spreadsheet Data
  • Formatting and Customising Data
  • Editing Spreadsheets
  • Formulas and Functions
  • Printing

EXCEL – INTERMEDIATE Level

Course Basics

  • More Formatting Techniques
  • More Formulas and Functions
  • Database and List Management
  • Charts
  • Drawing and Picture Objects
  • Excel and Other Applications

EXCEL – ADVANCED Level

Course Basics

  • Toolbars
  • Importing Data
  • Templates and Styles
  • Analysing Data
  • Macros and Custom Controls
  • Security and Proofing
  • Customising Excel
  • Collaboration and Consolidation
  • Creating and Opening Workbooks
  • Working with Workbooks
  • Working with Worksheets
  • Working with Cells
  • Navigating Within a Cell
  • Navigating the Workbook
  • Entering Data
  • Using Time Saving Features
  • Checking the Spelling
  • Selecting Items in Excel
  • Formatting Text

  • Formatting Numbers
  • Manipulating Data
  • Formatting Columns and Rows
  • Formatting with Colours and Patterns
  • Adding and Editing Borders
  • Using AutoFormat
  • Cutting, Copying and Pasting
  • Inserting and Deleting
  • Using Find and Replace
  • Using Undo and Redo
  • Viewing Worksheets
  • Entering Formulas
  • Entering Functions
  • Using Named Cells and Ranges in Formulas
  • Using Page Setup
  • Margins
  • Headers and Footers
  • Printing a Spreadsheet
  • Toolbars
  • File Management
  • Customising View Options
  • Displaying and Customising Toolbars
  • Hiding Workbooks and Worksheets
  • Freezing Panes
  • Grouping and Ungrouping Worksheets
  • Using Styles
  • Conditional Formatting
  • Using the Format Painter
  • Using Guidelines
  • Hiding and Displaying Cells
  • Using the Series Command
  • Using the Insert Function Wizard
  • Using the Excel Function Categories
  • Correcting Formulas
  • Using the Formula Error Checker
  • Using the Formula Auditing Toolbar
  • Using the Watch Window
  • Using Databases
  • Creating and Editing a Database
  • Sorting a Database
  • Using AutoFilters
  • Advanced Filters
  • Working with Filtered Data
  • Using Data Forms
  • Chart Wizard
  • Chart Toolbar
  • Working with Charts
  • Formatting the Chart
  • Drawing Toolbar
  • Working with AutoShapes
  • Creating Text Boxes
  • Adding Pictures
  • Layering Objects
  • Grouping and Ungrouping Objects
  • Converting Files from Other Applications
  • Copying Data from Another Application
  • Embedding and Linking Objects
  • Hyperlinks
  • Managing Links
  • Importing Data from External Sources
  • Importing Text Files
  • Using Microsoft Query
  • Querying Data from the Web
  • Refreshing Data
  • Working with Templates
  • Working with Styles
  • What-If Analysis
  • Goal Seek
  • Data Tables
  • Scenario Manager
  • Solver
  • Using Pivot Tables
  • Working with Macros
  • Running Macros
  • Adding Custom Controls
  • Security Features
  • Protecting Excel Files
  • Worksheet Protection
  • Working with Digital Signatures
  • Checking Spelling
  • Using Data Validation
  • Using Text to Speech
  • Documentation
  • Configuring Excel Options
  • Customising the Excel Environment
  • Working with Workspaces
  • Sharing Workbooks
  • Sending workbooks
  • Consolidation

How will I study my course?

  • Short course

How long will my course last?


To suit requirements, normally one day for Introductory, Intermediate and Advanced Levels.


Where can I study my course?

    • Thurso
    • Alness
    • Dornoch

Start date

By negotiation - as required.

Contact Admissions for more information on start dates.

Fees

For the latest information on fees please see our fees policy.

What can I do on completion of my course?

  • Other relevant courses.

Is there more information available online?

QR Code - scan to visit course page

You can use the above QR code to connect directly to the course details.

Apply for Microsoft Excel College Certificate

I want to start in 2018/19
I want to start in 2019/20

We are delighted that you are thinking about studying at North Highland College UHI. North Highland College operates a fair and open admissions system committed to equality of opportunity and non-discrimination. We consider all applications on merit and on the basis of ability to achieve, without discrimination on grounds of age, disability, gender identity, marriage and civil partnership, pregnancy and maternity status, race, religion and/or belief, sex, sexual orientation or socio-economic background. We welcome applications from all prospective students and aim to provide appropriate and efficient services to students with disabilities.

Search again