Description
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.
Assessment:
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.
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?
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.
Requirements
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.
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.
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