- Tutor is available to students
Microsoft Excel 3 Course Bundle – Basic, Intermediate & Advanced Courses - Only £22
Excel Beginner, Excel Intermediate and Excel Advanced Course,
Oplex Careers
Summary
Overview
The online Microsoft Excel Beginner, Intermediate & Advanced course will provide learners with a core understanding of how to effectively operate and use the Excel spreadsheet software. Whether you need to learn the skills for work, want to fill the gaps in your CV or simply fancy learning something new, this Excel beginner course is perfect to do so.
CPD
Course media
Description
The online Microsoft Excel Beginner, Intermediate & Advanced course will provide learners with a core understanding of how to effectively operate and use the Excel spreadsheet software at an advanced level. Whether you need to learn the skills for work, fill the gaps in your CV or simply fancy learning something new, this Excel Advanced course is perfect.
Course Syllabus
Basic Level:
- 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
Intermediate Level:
- 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
Advanced Level:
- 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
- Microsoft Excel Software
This course relates to Microsoft 2013 software. In order to complete the course, learners should have their own copy of Microsoft Excel 2013. If learner does not own a copy of the software, Microsoft provide a free trial version of Microsoft Excel 2013.
Assessment
To assess the learners ability and knowledge to effectively understand the topics contained within the Microsoft Excel Basic, Intermediate & Advanced course, the course features a number of end of module interactive quiz questions.
Additionally, at the end of the course learners will also take an online multiple choice assessment test. This online multiple choice test is marked automatically so you will receive an instant grade and know whether you have passed the course.
Certificate
On successful completion of this Microsoft Excel Basic, Intermediate & Advanced course learners will receive a CPD Certificate of Achievement award from Oplex Careers.
This certificate will be produced in PDF format, hard copies of the certificate will be available at an additional fee of £9.99.
Course Format
This course is delivered online through eLearning. Learners of the course will receive instant access to our interactive student learning portal, which offers 24/7 access to the Microsoft Excel Basic, Intermediate & Advanced course.
Course Duration
The online Microsoft Excel Basic, Intermediate & Advanced course requires 120 hours to complete the course in full. This is only a guide to the learning hours required and it depends on how quickly an individual can absorb the information. The learning is online so it can be spread out over multiple sessions or done in one session.
Learners will have access to this course for up to 12 months from the date of joining. There is no time limit to complete the course during this period.
Tutor Support
When you are studying a course it is always useful to know that you have the help and support of tutors that want you to succeed in your studies.
As part of the Microsoft Excel Basic, Intermediate & Advanced course you will receive access to our dedicated tutor support service. The academic tutors will be able to provide you with unlimited online email support to help answer any questions that you may have whilst you are studying the course.
Course Compatibility
Our Microsoft Excel Advanced course is fully compatible with PC’s, Mac’s, Laptop, Tablet and Smartphone devices.
We know that more and more people are using the web whilst they are on the move, so we have designed this Microsoft Excel Advanced course to be fully compatible across tablet and smartphone devices. You will be able to access the same content from the course, just over a 3G or 4G network whilst on the move.
Questions and answers
hello - is this really 3 courses in one - beginner, intermediate and advanced? I have some skills but unsure if I am intermediate or advanced.
Answer:Hi, Thanks for getting in touch. Yes this is a bundle offer for all three courses with a better saving than if you ordered individually. There are three levels, and one final assessment for each level. When you complete each test you will receive each certificate. Once you have registered onto your course, our team receive your order then send over your login details to get started right away. Hope this helps.
This was helpful.Is this a one off payment of £22 and can anyone do it or do you need to be registered with Reed.
Answer:Yes the course is a one off payment of just £22 to enrol. Everyone is welcome to enrol on this course. I hope that helps.
This was helpful.approx how many hours to complete course?
Answer:The course has a guided learning hours of around 90 hours, although you can complete within this time and will still receive your certificate from our team. Thanks
This was helpful.
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.
FAQs
Interest free credit agreements provided by Zopa Bank Limited trading as DivideBuy are not regulated by the Financial Conduct Authority and do not fall under the jurisdiction of the Financial Ombudsman Service. Zopa Bank Limited trading as DivideBuy is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority, and entered on the Financial Services Register (800542). Zopa Bank Limited (10627575) is incorporated in England & Wales and has its registered office at: 1st Floor, Cottons Centre, Tooley Street, London, SE1 2QG. VAT Number 281765280. DivideBuy's trading address is First Floor, Brunswick Court, Brunswick Street, Newcastle-under-Lyme, ST5 1HH. © Zopa Bank Limited 2024. All rights reserved.