Microsoft Excel Course

For You
For Business

Microsoft Excel Course

Original price was: £425.Current price is: £29. ex Vat

Take This Course

*Certification Fee Applicable

1 Year Access
Intermediate
58 Students
10 hours, 28 minutes

Gift this course

Share Link on

£25.00 /Unit Price

£500

Quantity:

Add to Cart

Looking for a more personalised package?

Overview of Microsoft Excel Course

Microsoft Excel Course offers a transformative opportunity to elevate your skills and unlock the potential of this powerful tool. Our online Excel course UK is designed to turn beginners into confident users, providing engaging content that guides you through navigating Excel 2016, performing calculations, formatting worksheets, and managing workbooks with ease.

The Excel course includes in-depth modules on working with functions, analysing data, and creating visually stunning charts. You will master essential skills such as using PivotTables and PivotCharts, automating workbook functionality, and forecasting data trends. By the end of this training, you will be adept at managing multiple worksheets and employing lookup functions for enhanced data analysis.

Experience the difference that quality Excel training can make in your professional and personal projects. This comprehensive Excel education programme equips you with the tools and knowledge necessary for success. Enrol today and start transforming your data skills!

How is the course assessed?

To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion.

Will I receive a certificate of completion?

Upon successful completion, you will qualify for the UK and internationally-recognised certificate and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15.

Why study this course?

Whether you’re an existing practitioner or aspiring professional, this course will enhance your expertise and boost your CV with key skills and an accredited qualification attesting to your knowledge.

Who is This course for?

This Microsoft Excel Course is suitable for anyone interested in working in this sector or who simply wants to learn more about the topic. If you’re an individual looking to excel within this field then Microsoft Excel Course is for you.

Requirements of Microsoft Excel Course

The Microsoft Excel Course is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16.

Course Curriculum

Getting Started with Microsoft Office Excel 2016
	Navigate the Excel User Interface	00:28:00
	Use Excel Commands	00:10:00
	Create and Save a Basic Workbook	00:19:00
	Enter Cell Data	00:12:00
	Use Excel Help	00:05:00
Performing Calculations
	Create Worksheet Formulas	00:15:00
	Insert Functions	00:17:00
	Reuse Formulas and Functions	00:17:00
Modifying a Worksheet
	Insert, Delete, and Adjust Cells, Columns, and Rows	00:10:00
	Search for and Replace Data	00:09:00
	Use Proofing and Research Tools	00:07:00
Formatting a Worksheet
	Apply Text Formats	00:16:00
	Apply Number Format	00:08:00
	Align Cell Contents	00:09:00
	Apply Styles and Themes	00:12:00
	Apply Basic Conditional Formatting	00:11:00
	Create and Use Templates	00:08:00
Printing Workbooks
	Preview and Print a Workbook	00:10:00
	Set Up the Page Layout	00:09:00
	Configure Headers and Footers	00:07:00
Managing Workbooks
	Manage Worksheets	00:05:00
	Manage Workbook and Worksheet Views	00:07:00
	Manage Workbook Properties	00:06:00
Working with Functions
	Work with Ranges	00:18:00
	Use Specialized Functions	00:11:00
	Work with Logical Functions	00:23:00
	Work with Date & Time Functions	00:08:00
	Work with Text Functions	00:11:00
Working with Lists
	Sort Data	00:10:00
	Filter Data	00:10:00
	Query Data with Database Functions	00:09:00
	Outline and Subtotal Data	00:09:00
Analyzing Data
	Create and Modify Tables	00:16:00
	Apply Intermediate Conditional Formatting	00:07:00
	Apply Advanced Conditional Formatting	00:05:00
Visualizing Data with Charts
	Create Charts	00:13:00
	Modify and Format Charts	00:12:00
	Use Advanced Chart Features	00:12:00
Using PivotTables and PivotCharts
	Create a PivotTable	00:13:00
	Analyze PivotTable Data	00:12:00
	Present Data with PivotCharts	00:07:00
	Filter Data by Using Timelines and Slicers	00:11:00
Working with Multiple Worksheets and Workbooks
	Use Links and External References	00:12:00
	Use 3-D References	00:06:00
	Consolidate Data	00:05:00
Using Lookup Functions and Formula Auditing
	Use Lookup Functions	00:12:00
	Trace Cells	00:09:00
	Watch and Evaluate Formulas	00:08:00
Sharing and Protecting Workbooks
	Collaborate on a Workbook	00:19:00
	Protect Worksheets and Workbooks	00:08:00
Automating Workbook Functionality
	Apply Data Validation	00:13:00
	Search for Invalid Data and Formulas with Errors	00:04:00
	Work with Macros	00:18:00
Creating Sparklines and Mapping Data
	Create Sparklines	00:07:00
	MapData	00:07:00
Forecasting Data
	Determine Potential Outcomes Using Data Tables	00:08:00
	Determine Potential Outcomes Using Scenarios	00:09:00
	Use the Goal Seek Feature	00:04:00
	Forecasting Data Trends	00:05:00
Resources
	Resources – Spreadsheet Specialist Training	00:00:00
Order Your Certificate
	Order Your Certificate Now	00:00:00