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.
Course Curriculum
| Getting Started | |||
| Spreadsheet Terminology | 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 | ||
Certificate of Achievement
CPD Accredited Certification
Certification is available –
- In PDF for £2.99
- Hard copy for £8.99
Course Reviews
No Reviews found for this course.
- PRIVATE
- 1 year
- Beginner
- Number of Units31
- Number of Quizzes2
- 4 hours, 49 minutes