4.9 (9)
Personal Development

Excel 2016 Introduction

Excel 2016 Training Course teaches you everything on the topic thoroughly from scratch so you can achieve a professional certificate for free to showc...

Img

67 Lesson

Img

3hr 46min

Img

3 students enrolled

Excel 2016 Training Course teaches you everything on the topic thoroughly from scratch so you can achieve a professional certificate for free to showcase your achievement in professional life. This Excel 2016 Course is a comprehensive, instructor-guided course, designed to provide a detailed understanding of the nature of the related sector and your key roles within it. To become successful in your profession, you must have a specific set of skills to succeed in today’s competitive world. In this in-depth training course, you will develop the most in-demand skills to kickstart your career, as well as upgrade your existing knowledge & skills. The training materials of this Excel 2016 Training Course are available online for you to learn at your own pace and fast-track your career with ease.
  • Accredited by CPD
  • Instant e-certificate
  • Fully online, interactive course with Professional voice-over
  • Self paced learning and laptop, tablet, smartphone friendly
  • 24/7 Learning Assistance
  • Discounts on bulk purchases

Sneak Peek of The Excel 2016 Training Course

Who Should Take The Excel 2016 Training Course

Anyone with a knack for learning new skills can take this Excel 2016 Training Course. While this comprehensive training is popular for preparing people for job opportunities in the relevant fields, it also helps to advance your career for promotions.

Certification

Once you’ve successfully completed your Excel 2016 Course, you will immediately be sent a digital certificate. All of our courses are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Accreditation

All of our courses, including this Excel 2016 Training Course, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field.

Assessment

At the end of the Excel 2016 Training Course, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven’t, there’s no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself.

Course Curriculum

Introduction Getting Started with Excel Creating Workbooks and Using Templates Entering Data Excel Formula Basics Data Adjusting a Worksheet Formatting and Aligning Worksheet Data Using Cell Styles and Themes Inserting Objects and Graphics Proofing a Workbook Printing an Excel File Managing Worksheets Navigating and Viewing Excel Files Conclusion
Course Content
67 Lectures 3hr 46min
  • ImgWhat is Excel

  • ImgOpening Excel

  • ImgNavigating the Excel User Interface

  • ImgUsing the Excel Ribbon

  • ImgUnderstanding Excel Work Components

  • ImgUsing the Backstage View

  • ImgCreating a New Workbook

  • ImgCreating Workbooks Using Templates

  • ImgSaving an Excel Workbook

  • ImgUsing Convert and Checking Compatiblity

  • ImgNavigating a Worksheet by Mouse or Keyboard

  • ImgExcel Data Types

  • ImgCell and Range Addressing

  • ImgData Selection Techniques

  • ImgCommon Excel Commands

  • ImgUsing the Autofill Handle

  • ImgWhat are Formulas and Functions

  • ImgComponents of a Formula

  • ImgCalculation Hierarchy Using the Order of Operations_Revise

  • ImgCreating Basic Formulas

  • ImgWorking with Basic Functions and Autosum

  • ImgUsing Cell References

  • ImgUsing the Quick Analysis Tool

  • ImgModifying Columns and Rows

  • ImgHiding and Unhiding Worksheets

  • ImgFormatting and Aligning Data

  • ImgMerging Data

  • ImgWrapping Text Orientation

  • ImgFormatting Numbers

  • ImgUsing Borders and Shading

  • ImgUsing the Format Painter

  • ImgRemoving Formatting Quickly

  • ImgUnderstanding Cell Styles

  • ImgApplying Cell Styles

  • ImgApplying Themes

  • ImgInserting and Formatting Images

  • ImgInserting and Formatting Shapes

  • ImgInserting and Formatting Smart Art

  • ImgInserting Screenshots

  • ImgInserting Hyperlinks

  • ImgInserting Symbols and Equations

  • ImgInserting Word Art Or Text Boxes

  • ImgInserting Other Excel Objects

  • ImgArranging Objects

  • ImgUsing Find and Replace

  • ImgFinding and Replacing Formatting

  • ImgUsing Got to and Go to Special

  • ImgUsing the Spell Checker

  • ImgUsing the Theasaurus and Translation Feature

  • ImgPrinting and Previewing Excel Files

  • ImgCreating Custom Margins and Scaling

  • ImgAdding Headers and Footers

  • ImgFormatting a Page with the Page Layout Tab

  • ImgPrinting Titles and Specific Worksheet Areas

  • ImgExporting to PDF and XPs

  • ImgRenaming and Coloring Worksheet Tabs

  • ImgAdding, Deleting, and Navigating Worksheets

  • ImgMoving and Copying Worksheets

  • ImgHiding and Unhiding Worksheets

  • ImgViewing Workbooks

  • ImgUsing Zoom Tools

  • ImgConfigure Sheet Options

  • ImgUsing Freeze Panes and Split Commands

  • ImgWorking with Window Commands

  • ImgAdjusting Workbook Properties