Microsoft Excel – Introduction: Spreadsheets Made Easy

Loading Events

« All Events

  • This event has passed.

Microsoft Excel – Introduction: Spreadsheets Made Easy

July 1 @ 9:30 am - 5:00 pm

|Recurring Event (See all)

One event on 11th March 2020 at 9:30am

One event on 13th May 2020 at 9:30am

One event on 10th June 2020 at 9:30am

One event on 1st July 2020 at 9:30am

One event on 22nd July 2020 at 9:30am

One event on 5th August 2020 at 9:30am

One event on 24th August 2020 at 9:30am

One event on 1st September 2020 at 9:30am

One event on 16th September 2020 at 9:30am

One event on 28th September 2020 at 9:30am

Member price – £120.00 + VAT
Non-member price – £160.00 + VAT

Duration – 1 Day

 

One of the hardest problems users face in Excel is Percentages (finding, adding and deducting). This introduction course shows some simple steps of how to conquer this problem allowing users to create more complicated spreadsheets that they can trust and use effectively. In addition, linking spreadsheets is one of the easiest ways to improve your readable data with the introduction of some new formulas i.e. Today, Median, Mode and Absolute Cell Referencing. Delegate’s confidence will quickly grow allowing them to start learning filtering and subtotal functions.

  • Keyboard – Function Keys / Shortcuts
  • Screen Layout – Terminology / Toolbars / Shortcut / Cursors / Navigation
  • Formatting – Open / Close / Saving / Text / Columns & Rows / Borders
  • Editing – Planning / Autofill / Copy / Cut / Paste / Paste Special
  • Printing – Selection / Entire Workbook / Worksheet / Page Setup
  • Basic Graphs – Bar / Area / Pie
  • Basic Formulas – + – ÷ X / Basic Percentages / Absolute References / Averages / Dates
  • BODMAS – 2+2*2=6
  • Average / Median / Mode Formulas
  • Count / CountA / CountBlank / CountIF Formulas
  • Min / Max Formulas
  • Today Formula
  • Problem Solving Workshop
  • Question and Answers

Details

Date:
July 1
Time:
9:30 am - 5:00 pm
Event Categories:
, , , ,

Venue

Sheffield
South YorkshireUnited Kingdom

Organiser

Chamber Skills Solutions
Phone:
01709 386200
Email:
training@brchamber.co.uk

Other

Enquiry Only
Is Inquirable

Book this training course