Conscious Mind

Spreadsheets: Microsoft Excel


Base Module: Spreadsheets


View / Download Syllabus  View Course Fees Course Schedule & Bookings

This module allows candidates to understand the concept of spreadsheets and to demonstrate an ability to use a spreadsheet to produce accurate work outputs.

On completion of this module the candidate will be able to:

Benefits of this module:


Category Skill Set
Using the Application
  • Working with Spreadsheets
  • Enhancing Productivity
Cells
  • Insert, Select
  • Edit, Sort
  • Copy, Move, Delete
Managing Worksheets
  • Rows and Columns
  • Worksheets
File Management
  • Arithmetic Formulas
  • Functions
Formatting
  • Numbers/Dates
  • Contents
  • Alignment, Border Effects
Charts
  • Create
  • Edit
Prepare Outputs
  • Setup
  • Check & Print


Advanced Module: Advanced Spreadsheets


View / Download Syllabus  View Course Fees Course Schedule & Bookings

This module is a high-level certification programme which presents candidates with the opportunity to bring their spreadsheet skills to an expert level. Completion of this module will enable candidates to master the more advanced functions of spreadsheet applications, enabling them to produce more sophisticated reports, and to perform complex mathematical and statistical calculations, thus saving time and improving productivity in the completion of tasks.

On completion of this module the candidate will be able to:

Benefits of this module:


Category Skill Set
Formatting
  • Worksheets
Functions and Formulas
  • Using Functions and Formulas
Charts
  • Creating Charts
  • Formatting Charts
Analysis
  • Using Tables
  • Sorting and Filtering
  • Scenarios
Validating and Auditing
  • Validating
  • Auditing
Enhancing Productivity
  • Naming Cells
  • Paste Special
  • Templates
  • Linking, Embedding and Importing
  • Automation
Collaborative Editing
  • Tracking and Reviewing
  • Security

View / Download Syllabus  View Course Fees Course Schedule & Bookings

This website uses cookies as per our Privacy Policy. You can manage cookies for your browser in your browser settings.