Booking options
£25
£25
On-Demand course
3 hours 45 minutes
All levels
MS Excel introduces multi-dimensional activities through its various feature. Do you want to be the first to look at the MS Excel 2016 Introduction course to learn its vivid use? Don't be late. Look at the MS Excel 2016 Introduction course and justify its authentic knowing its various fields.
The course designs in such a way that helps you to know the basic functions of MS Excel and various use of Excel for making calculation, producing charts, and recording data of all kind of business. It teaches you how to create Excel data, simple PivotTable and charts, vivid use of IF, SUM, TOTAL, and AVERAGE. It enables the students to understand how Excel is used in business to analyze the existing data. It also teaches the functions of range, and cell to do different types of activities.
This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work.
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.
MS Excel 2016 Introduction 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.
Our MS Excel 2016 Introduction 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.
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.
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:07: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 Columns and Rows | 00:03:00 | ||
Formatting and Aligning Worksheet Data | |||
Formatting and Aligning Data | 00:06:00 | ||
Merging Data | 00:03: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 | ||
Certificate and Transcript | |||
Order Your Certificates and Transcripts | 00:00:00 |