Microsoft Excel 2016 for Beginners

(8 Reviews)

stds522 Students

stds

GET ACCESS TO THIS COURSE ALONG WITH 3000+ ONLINE COURSES FOR A YEAR FOR JUST £49. GET NOW

Description:

Organizations the world over rely on information to make sound decisions regarding all manner of affairs. But with the amount of available data growing on a daily basis, the ability to make sense of all of the data is becoming more and more challenging. By this Microsoft Excel 2016 for Beginners   you will gain the foundational understanding of Microsoft Office Excel 2016 that is necessary to create and work with an electronic spreadsheet. You will learn all novice computer users get up to speed with excel quickly, how to cover some simple scenarios and cover the basics of formatting and much more.

Learning Outcomes:

  • Familiarize the excel user interface, creating basic worksheet and using the help system
  • How to create formulas, reuse them and insert functions in a worksheet
  • Managing cells, columns and rows and ways to manipulate data
  • Utilizing the ‘Search and replace’ data options and spell checking
  • Modifying fonts, adding borders and colours to cells, using number formats, aligning cell contents and applying cell styles
  • Define and refine page layouts for printing options
  • Managing large workbooks through worksheet tab formatting and using different views
  • Options for general customization, language, formula, proofing and saving
  • Customizing Quick Access toolbar, ribbon, advanced and Trust Center options
  • Utilize Excel’s version control features and enabling add-ins

Assessment:

  • At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not.
  • Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam.

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?

Microsoft Excel 2016 for Beginners 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 Microsoft Excel 2016 for Beginners 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.

  • video Identify the Elements of the Excel Interface
    00:30:00
  • video Activity – Identify the Elements of the Excel Interface
    00:05:00
  • video Create a Basic Worksheet
    01:00:00
  • video Activity – Create a Basic Worksheet
    00:05:00
  • video Use the Help System
    00:30:00
  • video Activity – Use the Help System
    00:05:00
  • video Create Formulas in a Worksheet
    01:00:00
  • video Activity – Create Formulas in a Worksheet
    00:05:00
  • video Insert Functions in a Worksheet
    00:30:00
  • video Activity – Insert Functions in a Worksheet
    00:05:00
  • video Reuse Formulas
    00:30:00
  • video Activity – Reuse Formulas
    00:05:00
  • video Manipulate Data
    00:30:00
  • video Activity – Manipulate Data
    00:05:00
  • video Insert, Manipulate, and Delete Cells, Columns, and Rows
    00:30:00
  • video Activity – Insert, Manipulate, and Delete Cells, Columns, and Rows
    00:05:00
  • video Search For and Replace Data
    00:30:00
  • video Activity – Search For and Replace Data
    00:05:00
  • video Spell Check a Worksheet
    00:30:00
  • video Activity – Spell Check a Worksheet
    00:05:00
  • video Modify Fonts
    00:30:00
  • video Activity – Modify Fonts
    00:05:00
  • video Add Borders and Colors to Cells
    01:00:00
  • video Activity – Add Borders and Colors to Cells
    00:05:00
  • video Apply Number Formats
    00:30:00
  • video Activity – Apply Number Formats
    00:05:00
  • video Align Cell Contents
    00:30:00
  • video Activity – Align Cell Contents
    00:05:00
  • video Apply Cell Styles
    00:30:00
  • video Activity – Apply Cell Styles
    00:05:00
  • video Define the Basic Page Layout for a Workbook
    01:00:00
  • video Activity – Define the Basic Page Layout for a Workbook
    00:05:00
  • video Refine the Page Layout and Apply Print Options
    00:30:00
  • video Activity – Refine the Page Layout and Apply Print Options
    00:05:00
  • video Format Worksheet Tabs
    00:30:00
  • video Activity – Format Worksheet Tabs
    00:05:00
  • video Manage Worksheets
    00:30:00
  • video Activity – Manage Worksheets
    00:05:00
  • video Manage the View of Worksheets and Workbooks
    00:30:00
  • video Activity – Manage the View of Worksheets and Workbooks
    00:05:00
  • video Customize General and Language Options
    00:30:00
  • video Activity – Customize General and Language Options
    00:05:00
  • video Customize Formula Options
    00:30:00
  • video Activity – Customize Formula Options
    00:05:00
  • video Customize Proofing and Save Options
    01:00:00
  • video Activity – Customize Proofing and Save Options
    00:05:00
  • video Customize the Ribbon and Quick Access Toolbar
    00:30:00
  • video Activity – Customize the Ribbon and Quick Access Toolbar
    00:05:00
  • video Customize the Functionality of Excel by Enabling Add-Ins
    00:30:00
  • video Activity – Customize the Functionality of Excel by Enabling Add-Ins
    00:05:00
  • video Customize Advanced and Trust Center Options
    00:30:00
  • video Activity – Customize Advanced and Trust Center Options
    00:05:00
  • video Activities and Exercise Files – Microsoft Excel 2016 for Beginners

What Our Students are Saying

 

Other Students Also Bought

No course found
0
    0
    Your Cart
    Your cart is emptyReturn to Shop

    Black Friday Sale – All Courses For Just £49/ year

    ADD OFFER TO CART

    No more than 50 active courses at any one time. Membership renews after 12 months. Cancel anytime from your account. Certain courses are not included. Can't be used in conjunction with any other offer.

      Apply Coupon
      John Academy Demo Certificate Framed