/
/
/
/

Microsoft Excel – Beginner, Intermediate & Advanced

(3.4)13 reviews
Recent reviews of this course provider

CBT

Really very good I recommend it...more

See all reviews
Add to shortlistShortlisted by 14 people

https://www.hotcourses.com/courses-by-subject/Microsoft-Excel-–-Beginner-Intermediate-Advanced-courses/56270136/

Course description

Microsoft Excel – Beginner, Intermediate & Advanced:

The Microsoft Excel 2013 Beginner course is split into the following modules:

Introduction to Spreadsheets
Understanding Microsoft Excel
Excel Workbook Windows
Basic Spreadsheet Skills
Excel Help System
Opening and Closing Workbooks
Understanding Workbook File Formats
Creating New Workbooks
Selecting Cells
Auto Sum and Auto Fill Function
Cell Referencing and Request
Formatting Cells
Formatting Numbers
Placing Cell Alignment
Cell, Rows and Columns
Understanding Worksheets
Editing, Copying and Moving Cells
Page Layouts in Excel
Proofing Workbooks
Basic Options, Ribbons and Toolbar
Final Assessment

The Microsoft Excel 2013 Intermediate course is split into the following modules:

Introduction to Excel Spreadsheet Intermediate Level
Defining Names in Excel
Sorting Data
Using Excel Tables
Filtering Data in Excel
Understand Charts
Chart Design Options and Tools
Chart Format Tools
Combo Charts
Functions within Excel
Understanding Date Function
Information Functions
Logical Functions
Financial Functions
Find and Replace
Headers and Footers
Adding Comments
Conditional Formatting
Final Assessment

The Microsoft Excel 2013 Advanced course is split into the following modules:

Introduction to Excel Advanced
Using Text to Columns
The Paste Special Function
Data Validation
Subtotals and Grouping
Consolidating Data
Scenario Analysis
Data Tables in Scenario Analysis
What-if Analysis
Mats and Trig Functions
Text Functions in Excel
Using Lookup Functions
Vlookups
HLookups
Using Statistical Functions
Databse Functions
Formaula Auditing and Error Tracing
Hyperlinks in Excel
Linking Data
Understanding Pivot Tables
Using Pivot Charts
Workbook Properties
Protecting and Sharing Worksheets
Data Encrypting and Finalising Workbooks
Understanding to Macros
Custom Number Formats in Excel
Using Custom Lists
Working with Templates
Tracking Changes in Excel
Merging and Compare Excel Workbooks
Final Assessment

Additional entry requirements

The are no previous entry requirements

Course info
111 views

Qualification:

Certificate of Attendance

UK

UK qualification

This course is offered to anyone in the world, but its qualification is only relevant in this country.

Study Hours:

Variable - to suit the learner

Level:

Beginner Intermediate Advanced

Virtual help:

No attendance for this course

Course type:

Online course

£599.97 ( 93% off )

£39
per course

Other Microsoft Excel courses

Microsoft Excel Beginner Course

Oplex Careers

Duration: Variable - to suit the learner

Beginner

Certificate of Attendance

Microsoft Excel Intermediate Course

Oplex Careers

Duration: Variable - to suit the learner

Intermediate

Certificate of Attendance

View 3 courses

Summary of all course reviews for Oplex Careers

13 reviews

(54%)
(8%)
(38%)

Average student ranking

Reviews of other courses at Oplex Careers

oplex-careers

CBT
5 5
Hotcourses
January 2018

Really very good I recommend it

Was this review helpful? Yes No
8 Hotcourses user(s) found the following review helpful.

oplex-careers

Pet Bereavement Counselling
5 5
Hotcourses
November 2017

I found that it was convenience and easy to assess to study online. The materials were rich and cover all the topics that I want to know. It was good that there were a little test in every session which made me more understand and remember what I had learned. Thank you so much.

Was this review helpful? Yes No
15 Hotcourses user(s) found the following review helpful.
MORE REVIEWS

Please note reviews of Pet Bereavement Counselling are the subjective opinions of Hotcourses members and not of Hotcourses Ltd.

Course reviews

This course currently has no reviews.

Write a review

Ask a question

Get course info