Microsoft Excel Intro

by Media Training Claim Listing

For complete beginners who need to understand the functionality of Excel. Learn to work efficiently, producing factual and well formatted spreadsheets.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Media Training Logo

img Duration

1 Day

Course Details

What Will I Learn?

  •  Create a spreadsheet from scratch

  •  Format text & numbers

  •  Learn shortcuts to work efficiently

  •  Perform basic calculations

  •  Present data visually using charts

  •  Free digital course assets

  •  Free post-course helpdesk support

 

Getting to Grips with the Basics

• The Excel Interface

• Using Backstage View

• Understanding the Ribbon

• Using & customising the Quick Access toolbar

 

Effectively Organise Your Workbooks

• Creating, saving & opening a new Workbook

• Entering numbers, text & dates in a Workbook

• Deleting Cell Contents

• Quickly sorting data

• Adding, deleting & naming sheets

 

Controlling the Layout of Spreadsheets Effortlessly

• Inserting Columns & Rows

• Deleting Columns & Rows

• AutoFill

• Using Cut, Copy & Paste

• Using Undo & Redo

 

Uncomplicate Tasks by Defining & Creating Calculations

• Writing a basic formula

• Understanding the order of BODMAS

• The Sum function & AutoSum

• Creating statistical functions (Average, Max and Min)

• Working with Relative References when Copying Formulas

 

Beautifully Presenting Your Data

• Font formatting

• Borders & Shading

• Number formatting (currency etc)

• Alignment options

• Clearing formats

 

Fine-Tuning Your Page Layout before Printing Worksheets

• Setting page margins & page orientation

• Creating a Header & Footer

• Printing all or part of a worksheet

• Setting Print Titles for large Worksheets

 

Visual Representations of Your Data

• Creating a chart

• Changing the Chart Type

• Basic Formatting of Charts

  • London Branch

    36 Shad Thames, London

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy