Microsoft Excel

Microsoft Excel is the most widely used software suite in business and office environments. Emp...

£400

Courses
You are here: / / / Microsoft Excel

Microsoft Excel is the most widely used software suite in business and office environments. Employers and offices across the world use this intuitive range of programmes to manage their office requirements on a day-to-day basis. These skills are specifically sought out on CVs and MooreHouse Training  Academy provides a comprehensive range of Microsoft Office training courses which are respected by employers.

There are no prerequisites to this course. New starters are welcome

This course runs for two days of intensive training and practical classroom exercises

DAY 1- Beginner

Introduction
  • Getting Started with Microsoft Excel
  • Data Entering
  • Creating Formulas and Functions
  • Formatting
  • Worksheet Views, Multiple Worksheets and Workbooks
  • IF, VLOOKUP, and Power Functions, Security & Sharing
  • Data Management, Data Analysis Tools
  • PivotTables & Macros
 Formula and Functions
  • Advance Formula and Functions
  • Values and Formulas
  • Operations in Formulas
  • IF, AND, OR and NOT Functions
  • VLOOKUP and HLOOKUP
 Day 2 - Intermediate
 
 Formula and Functions
  • Tabulating Data and Multiple Criteria
  • Median, Mode and Ranking Data
  • Date, Time and Functions
  • Array Formulas and Frequency Functions
  • OFFSET and INDIRECT Function
  • Different TEXT & Information Functions
Formatting & Techniques
  • Introduction to Excel Advance Formatting & Techniques
  • Adjust Fonts, Font Sizes & Font Colours
  • Adjust Cells and Tools
  • Work with Formulas & Tables
  • Adjust Row, Columns and Sheets
  • Different Formatting Styles and Set up Data for Outlines
  • Formatting Picture Styles
  • Formatting Techniques – Restore Missing Data in a Column
 

Possessing top level Microsoft Office skill could lead to a more technical career in IT support or a supervisory/Office Manager/senior administration type position.

  • TITLE
    Microsoft Excel
  • DURATION
    This course runs for 2 days
  • TYPE
    This course is offered in class
  • PRICE
    £400.00

UPCOMING SESSIONS

No Sessions found.

ENROLL NOW £400

ENROLL

Payment will allow you book an upcoming Batch.

Related products

Data Analysis Microsoft PowerPoint