Ultimate Microsoft Excel For Business Bootcamp

Overview Learn new skills and develop your professional knowledge with the Ultimate Microsoft Excel For Business Bootcamp and learn from …

Ultimate Microsoft Excel For Business Bootcamp

£25 ex VAT

Exclusive Deal! 94% Off, Today Only!

TAKE THIS COURSE

1 Year Access
31 Students
10 hours, 39 minutes

Buy 1 or more contact sale

£25 ex VAT
1 year
Number of Units73
Number of Quizzes0
10 hours, 39 minutes

Gift this course

14-Day Money-Back Guarantee

Overview

Learn new skills and develop your professional knowledge with the Ultimate Microsoft Excel For Business Bootcamp and learn from home at a pace that suits you. The Ultimate Microsoft Excel For Business Bootcamp has been expertly designed for you to complete through distance e-learning and achieve a professional qualification all without leaving your own home!

Successful completion of the Ultimate Microsoft Excel For Business Bootcamp will see you achieve a CPD certified qualification which will add significant weight to your CV and impress potential employers when applying for new jobs.

Once you enrol on the Ultimate Microsoft Excel For Business Bootcamp, you will have full course access for one year, meaning you are free to complete the Ultimate Microsoft Excel For Business Bootcamp at a pace that suits you. Enrol on the Ultimate Microsoft Excel For Business Bootcamp now and start studying using any internet-enabled device including computers, tablets, and smartphones.

With 24/7 student support offered to you on the Ultimate Microsoft Excel For Business Bootcamp, you can be sure of quick and comprehensive assistance whenever you need it.

Enrol now on the Ultimate Microsoft Excel For Business Bootcamp and get access to top-quality training modules which will cover the essential topics you need to excel in your chosen field and help push you towards your dream job!

Why Choose Ultimate Microsoft Excel For Business Bootcamp?

Get full tutor support and learning assistance
Complete the Ultimate Microsoft Excel For Business Bootcamp at a pace that suits you
Gain a professional certified qualification
Great value, high-quality training course

Showcase Your Accomplishment of New Skills: Get a Certification of Completion

Upon passing the course, you will receive proper certification that is accredited by CPD and universally accepted. You can order your certificate at a cost of £10 for PDF and £29 for hardcopy certificate or both for £39.

Who Is This Course For?

The Ultimate Microsoft Excel For Business Bootcamp has been professionally-designed for motivated learners who are looking to add a new skill to their CV and stand head and shoulders above the competition. Learn the latest industry-specific information with the Ultimate Microsoft Excel For Business Bootcamp.

Enrol on the Ultimate Microsoft Excel For Business Bootcamp and learn a new professional skill from anywhere, at any time!

Requirements

Enrol on the Ultimate Microsoft Excel For Business Bootcamp with no formal entry requirements! If you have a passion for knowledge and want to learn something new, register on the Ultimate Microsoft Excel For Business Bootcamp without any delay.

We only ask that all students have a passion for learning and literacy, and be over the age of 16.

Complete the Ultimate Microsoft Excel For Business Bootcamp online from your computer, tablet, or smartphone, and learn in a way that suits you.

Course Curriculum

Microsoft Excel 2019 New Features
	Introduction to Microsoft Excel 2019 New Features	00:07:00
	CONCAT	00:02:00
	IFS	00:01:00
	MAXIFS	00:01:00
	MINIFS	00:01:00
	SWITCH	00:02:00
	TEXTJOIN	00:01:00
	Map Chart	00:02:00
	Funnel Chart	00:01:00
	Better Visuals	00:06:00
	Pivot Table Enhancements	00:02:00
	Power Pivot Updates	00:01:00
Getting Started with Microsoft Office Excel
	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
	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
Excel Templates
	Excel Templates	00:00:00
Resources
	Ultimate Microsoft Excel For Business Bootcamp	00:00:00
Certificate
	Order Your Certificate	00:00:00