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 68 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
After successfully completing the course, you will be able to get the UK and internationally accepted certificate to share your achievement with potential employers or include it in your CV. The PDF Certificate + Transcript is available at £6.99 (Special Offer - 50% OFF). In addition, you can get a hard copy of your certificate for £12 (Shipping cost inside the UK is free, and outside the UK is £9.99).
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 | ||
| Resources | |||
| Resources – Excel 2016 Introduction | 00:00:00 | ||
COURSE REVIEWS
Course Reviews
No Reviews found for this course.
