Microsoft Excel Online Course

Rate this post

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

BOOK NOW

AED59.00

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 [email protected] 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 [email protected]. See the rules that apply to all deals. Download free Groupon app for Android and iOS.