MS Office 2016 Excel for Beginners

MS Office 2016 Excel for Beginners

get Access To All 3500+ One Education Courses For Just £49/Year!
Claim Offer

Gain mastery of the industry-standard spreadsheet software with this comprehensive beginners Excel course. Through easy-to-understand video tutorials you learn everything from the basics of creating worksheets to developing formulas and functions, installing macros and using templates. The Microsoft Office 2016 Excel Beginners online course goes through every feature of the program step-by-step, ensuring each individual lesson is accessible, informative, and user-friendly.

Course description

Microsoft Excel 2016 is used throughout all areas of industry, including finance and accounting, business management and office administration roles. Studying the Microsoft Office 2016 Excel Beginners – Complete Video Course gives you the knowledge to operate confidently and effectively in careers across all business areas, or for your own personal needs. You learn in your own time through videos, online study materials, PDF handouts and multiple-choice assessments accessible anytime, anywhere through our innovative e-learning platform.

Course design

The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.

You are taught through a combination of

  • Video lessons
  • Online study materials
  • Mock exams
  • Multiple-choice assessment

How is the course assessed?

To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion.

Will I receive a certificate of completion?

Upon successful completion you will qualify for the UK and internationally-recognised certificate and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15.

Why study this course

Whether you’re an existing practitioner or aspiring professional, this course will enhance your expertise and boost your CV with key skills and an accredited qualification attesting to your knowledge.

The MS Office 2016 Excel for Beginners is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16.

Course Curriculum

Getting Started with Microsoft Office Excel 2016
Navigate the Excel User Interface 00:28:00
Use Excel Commands 00:10:00
Create and Save a Basic Workbook 00:19:00
Enter Cell Data 00:12:00
Use Excel Help 00:05:00
Performing Calculations
Create Worksheet Formulas 00:15:00
Insert Functions 00:17:00
Reuse Formulas and Functions 00:17:00
Modifying a Worksheet
Insert, Delete, and Adjust Cells, Columns, and Rows 00:10:00
Search for and Replace Data 00:09:00
Use Proofing and Research Tools 00:07:00
Formatting a Worksheet
Apply Text Formats 00:16:00
Apply Number Format 00:08:00
Align Cell Contents 00:09:00
Apply Styles and Themes 00:12:00
Apply Basic Conditional Formatting 00:11:00
Create and Use Templates 00:08:00
Printing Workbooks
Preview and Print a Workbook 00:10:00
Set Up the Page Layout 00:09:00
Configure Headers and Footers 00:07:00
Managing Workbooks
Manage Worksheets 00:05:00
Manage Workbook and Worksheet Views 00:07:00
Manage Workbook Properties 00:06:00
Mock Exam
Mock Exam- MS Office 2016 Excel for Beginners 00:20:00
Final Exam
Final Exam- MS Office 2016 Excel for Beginners 00:20:00
sidemoneyBack

COPYRIGHT © 2022 One Education

Home Search Cart
0
    0
    Your Cart
    Your cart is emptyBrowse Courses

    Upgrade to get UNLIMITED ACCESS to ALL COURSES for only £49/year

    Claim Offer & Upgrade

    Membership renews after 12 months. You can cancel anytime from your account.

    Other Students Also Buy
      Apply Coupon