• LOGIN
  • No products in the basket.

What Will I Learn?

Learn to create simple worksheets

Understand calculation hierarchy and the Order of Operations

Format and align worksheet data

Proof and print a workbook

Use Functions in formulas

Add columns and rows

Use cell styles and themes

Manage Worksheets

Course Overview

This course will introduce you to the basics of Excel 2016. By completing this Excel 2016 Introduction course, you will have skills to stand out from the crowd.

You will learn how to create and manage spreadsheets in Excel. You will learn how to use cells and themes in Excel.

In this Excel 2016 Introduction course, you will be able to confidently add columns and rows to spreadsheets. This course will teach you how to use specific features such as calculation hierarchy. Learn how to easily modify worksheets, insert objects and enter data easily by taking this course. You can also practice what you learn throughout the course.

Excel 2016 Introduction is a best selling course developed by industry experts and already helped tons of students like you. It is suitable for anyone who wants to improve their knowledge and skills in the or relevant sector. 
This course is accredited by CPD, so you will get a career boost upon completing this course. Our Excel 2016 Introduction is packed with 67 modules and 3 hours, 46 minutes of study. You will be awarded with a certificate of completion, the proof of your expertise in this field. If you want to get a job or looking for professional skills to excel in this field, a certificate from this course will help you appear as a strong candidate. You can also validate your certification from our website.
It doesn’t matter if you are willing to study full-time or part-time. This course is designed for any type of student and you can even complete it at your own pace. The materials are accessible from anyplace, any device and anytime. 
Besides that, our experienced tutors will help you throughout the comprehensive syllabus of this course and answer all your queries through email.

Preview

Certification

Course-Cloud-Certificate

After completing the course, you will be able to get the UK and internationally recognised certificate to share your achievement with potential employers or to include it in your CV. You can obtain a physical version of your certificate for £12, or you can get a PDF format certificate for only £4(processing fee).

Course Curriculum

Introduction
Introduction FREE 00:01:00
Getting Started with Excel
What is Excel 00:02:00
Opening Excel 00:04:00
Navigating the Excel User Interface 00:08:00
Using the Excel Ribbon 00:03:00
Understanding Excel Work Components 00:04:00
Using the Backstage View 00:03:00
Creating Workbooks and Using Templates
Creating a New Workbook 00:03:00
Creating Workbooks Using Templates 00:03:00
Saving an Excel Workbook 00:05:00
Using Convert and Checking Compatiblity 00:02:00
Entering Data
Navigating a Worksheet by Mouse or Keyboard 00:05:00
Excel Data Types 00:03:00
Cell and Range Addressing 00:02:00
Data Selection Techniques 00:05:00
Common Excel Commands 00:07:00
Using the Autofill Handle 00:03:00
Excel Formula Basics Data
What are Formulas and Functions 00:02:00
Components of a Formula 00:06:00
Calculation Hierarchy Using the Order of Operations_Revise 00:02:00
Creating Basic Formulas 00:08:00
Working with Basic Functions and Autosum 00:04:00
Using Cell References 00:04:00
Using the Quick Analysis Tool 00:01:00
Adjusting a Worksheet
Modifying Columns and Rows 00:06:00
Hiding and Unhiding Worksheets 00:02:00
Formatting and Aligning Worksheet Data
Formatting and Aligning Data 00:06:00
Merging Data 00:04:00
Wrapping Text Orientation 00:02:00
Formatting Numbers 00:03:00
Using Borders and Shading 00:03:00
Using the Format Painter 00:01:00
Removing Formatting Quickly 00:01:00
Using Cell Styles and Themes
Understanding Cell Styles 00:02:00
Applying Cell Styles 00:04:00
Applying Themes 00:03:00
Inserting Objects and Graphics
Inserting and Formatting Images 00:03:00
Inserting and Formatting Shapes 00:04:00
Inserting and Formatting Smart Art 00:04:00
Inserting Screenshots 00:02:00
Inserting Hyperlinks 00:03:00
Inserting Symbols and Equations 00:03:00
Inserting Word Art Or Text Boxes 00:04:00
Inserting Other Excel Objects 00:04:00
Arranging Objects 00:04:00
Proofing a Workbook
Using Find and Replace 00:04:00
Finding and Replacing Formatting 00:01:00
Using Got to and Go to Special 00:02:00
Using the Spell Checker 00:03:00
Using the Theasaurus and Translation Feature 00:03:00
Printing an Excel File
Printing and Previewing Excel Files 00:03:00
Creating Custom Margins and Scaling 00:05:00
Adding Headers and Footers 00:04:00
Formatting a Page with the Page Layout Tab 00:03:00
Printing Titles and Specific Worksheet Areas 00:05:00
Exporting to PDF and XPs 00:02:00
Managing Worksheets
Renaming and Coloring Worksheet Tabs 00:03:00
Adding, Deleting, and Navigating Worksheets 00:03:00
Moving and Copying Worksheets 00:04:00
Hiding and Unhiding Worksheets 00:02:00
Navigating and Viewing Excel Files
Viewing Workbooks 00:03:00
Using Zoom Tools 00:02:00
Configure Sheet Options 00:02:00
Using Freeze Panes and Split Commands 00:05:00
Working with Window Commands 00:04:00
Adjusting Workbook Properties 00:03:00
Conclusion
Course Recap 00:02:00
Review

COURSE REVIEWS

Course Reviews

5

5
7 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

CONTACT

  • 1 Coldbath Square, Farringdon, London, EC1R 5HL
  • 02037432362

IMPORTANT LINKS

Course Cloud is an online learning platform that provides one of the best e-learning experience. With a large variety of training courses to choose from, you are bound to find something to suit you.

top
© Copyright Course Cloud