Microsoft Excel - Beginners, Intermediate & Advanced Levels

• Location: Online course
  • Certification: Included
  • Course Access : 12 Months
  • Exam Included : Yes
  • Entry Requirements : None
  • Compatibility: All major devices

Searching for an Excel course for beginners to experts? This online course has something for everybody, covering beginner, intermediate and advanced aspects in Excel.

In this Excel training online, you will discover the fundamental techniques including how to utilise mathematics, statistical, logic and text functions, arrange data by sorting and filtering, efficiently present your information in a number of chart formats and more. You will also discover intermediate and advanced techniques such as how to find a value with VLOOKUP, create and format PivotTables, record basic Macros and more.

Whether you use Excel for work or study, these modules will start you on your journey to becoming an Excel expert! Discover more about how a Harley Oxford Excel certification can boost your career.

As soon as you have enrolled, our friendly support staff and tutors are here to assist with any course-related queries.

Microsoft Excel – Beginners, Intermediate & Advanced Levels

This detailed course has been designed for anyone who wants to drive their career forward. The course covers a large variety of topics spanning over a number of detailed modules.

During the Microsoft Excel course, you will learn the fundamental techniques including how to utilise mathematics, statistical, logic and text functions.

In addition to this, you can learn how to arrange data by sorting and filtering, efficiently present your data in a number of chart formats and much more.

The great thing about this course is that there are no entry requirements. You don’t need any specific education or work experience, just the desire to learn, enhance your knowledge and skills and succeed in your desired career moving forward.

Once you select the Microsoft Excel course and your payment is received, you can start learning straight away. Everyone can study flexibly at different paces, which is why this course is such a great opportunity, enabling you to work and study in your available time. On completion of the course, you will need to complete a multiple-choice test and on passing, you will be issued a certificate that you can download and print which is recognised by industry professionals.

What you will learn in the Microsoft Excel Course

The Microsoft Excel beginners, intermediate & advanced levels comprise of a number often detailed modules for you to learn and gain knowledge from. In total the modules should take around thirty hours to complete, bearing in mind that everyone studies at different paces and some people will have more time to study than others.

The essential modules in this course include:

• Create your first Excel file, enter data and create a table.
• Format cells by selecting fonts and colour fill to make information more attractive.
• Utilise the keyboard or mouse to select cells and ranges in a spreadsheet.

Benefits of the Microsoft Excel Course

The Microsoft Excel course will provide you with a host of skills and knowledge you will be able to use on a daily basis. There are a number of benefits to completing the Microsoft Excel course:

• Learn at your own pace
• Unlimited tests and exams
• Get a certified qualification
• Mobile (learn on-the-go)

Course Modules/Units

Microsoft Excel Beginners

• Before You Start
• 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 AutoFill
• 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

• Before You Start
• 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

• Before You Start
• 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, TextBoxes and WordArt
• Custom Number Formats
• Custom Lists
• Working with Template

We offer every student essential skills & qualifications. Harley Oxford is a world-renowned course provider with over 40,000 students who have achieved crucial knowledge and qualifications by studying a course with us. Our mission is what propels us to do everything possible to develop human potential. We achieve this by constructing a groundbreaking digital training environment, making a course more flexible, building an imaginative and diverse team, and making a positive impact in the communities where we work and live.

With over 40,000 students across the globe and over 1000 courses, Harley Oxford is one of the largest online learning communities to date. Interested in learning a new course, or gaining a skill or hobby, our courses are accessible from anywhere in the world and are compatible with computers, tablets, and smartphones. Each course comes with tutor support, access to FREE cv support, and job tips. Study a course at your own pace, from the comfort of your own home, and work towards industry awards that will add power to your CV. Harley Oxford has the tools you need to progress as an expert in your chosen profession. Guided by our persistence we continuously strive to implement the critical initiatives required to accomplish our vision. In doing so, our school will convey operational excellence in every corner of the organization and meet or surpass our commitments to the many students we serve. All of our long-standing strategies and short-term actions will be shaped by a selection of core values that are shared by our learners and team.