Microsoft Excel Online Course – Beginner, Intermerdiate and Advanced Levels from Harley Oxford (96% Off)

Customers who wish to master Microsoft Excel can take part in this online course to learn helpful spreadsheet tips and tricks

• What’s included: Microsoft Excel online course – beginner, intermediate and advanced levels

Syllabus:

• Microsoft excel beginners
  • What is a spreadsheet program?
  • Getting started with Microsoft Excel
  • Workbook windows and views
  • Basic spreadsheet skills
  • Using the help system
  • Workbook file formats
  • Creating new workbooks
  • Selecting cells
  • Cell referencing
  • Auto sum and auto fill
  • Formatting numbers
  • Formatting cells
  • Cells, rows and columns
  • Working with worksheets
  • Edit, copy and move cells
  • Proofing workbooks
  • Printing and previewing worksheets
  • Basic options
  • E-mailing workbooks
• Microsoft excel intermediate
  • Defined names
  • Sort data and remove duplicates
  • Chart basics
  • Chart design
  • Chart layout
  • Chart format
  • More about charts
  • Date functions
  • Logical functions
  • Information functions
  • Financial functions
  • Headers and footers
  • Adding comments
  • Conditional formatting
• Microsoft excel advanced
  • Text to columns
  • Paste special
  • Data validation
  • Consolidate data
  • What-if analysis – data tables
  • What-if analysis – scenarios
  • Text functions
  • Lookup functions
  • Maths and trig functions
  • Statistical functions
  • Database functions
  • Linking data
  • Hyperlinks
  • Getting external data
  • Pivot tables and pivot charts
  • Protecting and sharing worksheets and workbooks
  • Workbook properties and inspection
  • Encrypting and finalising workbooks
  • An introduction to macros
  • Illustrations, text boxes and WordArt
  • Custom number formats
  • Custom lists
  • Working with template

Find out more

 

Deal Location: Abu Dhabi (24.467,54.365)

The Fine Print:
Validity: Must redeem by 31 Mar 2021. Course content available for 12 months from registration date.
Purchase: Limit 5 per person. May buy 5 additional as gifts.
Restrictions: Register via email, contact info@harleyoxford.com with a copy of the voucher. No refunds or cancellation once redeemed. Groupon prices are inclusive of VAT where applicable. Internet connection required. Course content compatible with PCs, Macs, laptops, tablets, smartphones and smart devices. No additional fees required. Customer support available, contact info@harleyoxford.com. See the rules that apply to all deals. Download free Groupon app for Android and iOS.

Merchant: Harley Oxford
http://harleyoxford.com/

Redemption Location(s):

Get Microsoft Excel Online Course Now