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.
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.
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
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.
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.
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 [course_title] 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.
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 |
Membership renews after 12 months. You can cancel anytime from your account.