This course is intended for people who want to gain the foundational understanding of Microsoft Office Excel 2013 that is necessary to create and develop worksheets.
In this course, you will learn how to create reports on data, perform calculations, store and share your workbook using Microsoft® Office Excel® 2013.
To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should be comfortable in the Windows® 8 environment, and be able to use Windows 8 to manage information on their computers. Specific tasks the students should be able to perform include: launching and closing applications, navigating basic file structures, and managing files and folders.
This course is proudly accredited through MICT SETA
Lesson 1: Getting Started with Microsoft® Excel® 2013
Topic A: Identify the Elements of the Excel Interface
Topic B: Create a Basic Worksheet
Topic C: Use the Help System
Lesson 2: Performing Calculations
Topic A: Create Formulas in a Worksheet
Topic B: Insert Functions in a Worksheet
Topic C: Reuse Formulas
Lesson 3: Modifying a Worksheet
Topic A: Insert, Manipulate, and Delete Cells, Columns, and Rows
Topic B: Search for and Replace Data
Topic C: Spell Check a Worksheet
Lesson 4: Formatting a Worksheet
Topic A: Modify Fonts
Topic B: Add Borders and Colors to Worksheets
Topic C: Apply Number Formats
Topic D: Align Cell Contents
Topic E: Apply Styles and Themes
Topic F: Apply Basic Conditional Formatting
Topic G: Create and Use Templates
Lesson 5: Printing Workbook Contents
Topic A: Define the Basic Page Layout for a Workbook
Topic B: Refine the Page Layout and Apply Print Options
Lesson 6: Managing Large Workbooks
Topic A: Format Worksheet Tabs
Topic B: Manage Worksheets
Topic C: Manage the View of Worksheets and Workbooks
Appendix A: Microsoft Office Excel 2013 Exam 77-420
Appendix B: Microsoft Office Excel 2013 Expert Exams 77–427 and 77-428
Appendix C: Microsoft Excel 2013 Common Keyboard Shortcuts
Privacy & Cookies Policy
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.