Description

Description:

This Microsoft Office 2010 Excel Beginners - Complete Video Course will teach you the basic functions and features of Excel 2010. After an introduction to spreadsheet terminology and Excel's window components, you will learn how to use the Help system and navigate worksheets and workbooks. Then you will enter and edit text, values, formulas, and pictures, and you will save workbooks in various formats. You will also move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course is designed to introduce you to using Microsoft Excel if you're unfamiliar with any major aspect of it. The series will lead you through the fundamentals of creating and working with Excel spreadsheets. Today's Excel spreadsheet isn't just for financial professionals. Microsoft Excel offers intuitive tools that make it easy to access, connect, and analyze critical data-regardless of your profession.

Assessment:

At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not.

Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam.

Certification:

After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement.

Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.

Who is this Course for?

Microsoft Office 2010 Excel Beginners - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills.

As there is no experience and qualification required for this course, it is available for all students from any academic background.

Requirements

Our Microsoft Office 2010 Excel Beginners - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.

Career Path

After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.

Getting Started
	Spreadsheet Terminology	FREE	00:02:00
	The Excel Environment		00:05:00
	Getting Help		00:03:00
	Navigating a Worksheet		00:06:00
Entering and Editing Data
	Entering and Editing Text and Values		00:09:00
	Entering and Editing Formulas		00:09:00
	Working with Pictures		00:03:00
	Saving and Updating Workbooks		00:07:00
Modifying a Worksheet
	Moving and Copying Data		00:13:00
	Moving and Copying Formulas		00:07:00
	Absolute and Relative References		00:06:00
	Inserting and Deleting Ranges, Rows, and Columns		00:07:00
Functions
	Entering Functions		00:15:00
	AutoSum		00:04:00
	Other Common Functions		00:11:00
Formatting
	Text Formatting		00:06:00
	Column Formatting		00:12:00
	Number Formatting		00:06:00
	Conditional Formatting		00:10:00
	Additional Formatting Options		00:12:00
Printing
	Preparing to Print		00:09:00
	Page Setup Options		00:14:00
	Printing Worksheets		00:04:00
Charts
	Chart Basics		00:11:00
	Formatting Charts		00:05:00
Managing Large Workbooks
	Viewing Large Worksheets		00:14:00
	Working with Multiple Worksheets		00:12:00
	Printing Large Worksheets		00:08:00
Graphics and Screenshots
	Conditional Formatting with Graphics		00:09:00
	SmartArt Graphics		00:05:00
	Screenshots		00:05:00
Mock Exam
	Mock Exam- Microsoft Office 2010 Excel Beginners - Complete Video Course		00:20:00
Final Exam
	Final Exam- Microsoft Office 2010 Excel Beginners - Complete Video Course		00:20:00
Order Your Certificate and Transcript
	Order Your Certificates and Transcripts		00:00:00

Course Images

Microsoft Office 2010 Excel Beginners - Complete Video Course

By John Academy

Booking options

Highlights

Description

About The Provider

Tags

Reviews