
Here students will learn all there is to know about the Excel Interface covering all the elements so that they are familiar with them and can recongnise each and be comfortable working with them.
Students will learn to create their first workbook in Excel.
Saving a workbook is Vital and necessary in all computer learning.
Students will learn to access the Help facility.
Basic Formulas are necessary as part of a good Excel foundation.
Students will learn Relative Cell Referencing.
Students will learn further statistical functions for ease of working in Excel
Students will make use of Autosum to Total Rows and Columns
Students will work with Relative Cell Referencing.
Here students will learn to work with Statistical Formulas to enhance their journey.
Students will learn the basics of creating basic formulas in Excel
Students will learn to insert rows and columns on a spreadsheet
Using text formats to further enhance spreadsheets.
Transforming your workbook with themes for easy styling.
Adding borders and shading for printing purposes.
Learn the art of printing.
Setting up Page layout for the purpose of margin setting, page orientation.
Further your page layout skills in Excel.
Adding headers and footers to workbooks as an extra printing dynamic.
Creating custom views for workbook and printing control.
Adding charts for visual effect in Excel.
Here students can practice all the skills taught to them in this course.
Course Description
Overview:
Excel is a software program that can help you organize, calculate, analyze, revise, update, and present your data in ways that will help the decision makers in your organization steer you in the right direction. It will also make these tasks much easier for you to accomplish, and in much less time, than if you used traditional pen-and-paper methods or non-specialized software.
This course is intended for students who wish to gain the foundational understanding of Microsoft Office Excel which is necessary to create and work with electronic spreadsheets. Students will go on to learn Excel Intermediate, (Level 2) and Excel Advanced (Level 3).
Target Student:
This course is intended for students who wish to gain the foundational understanding of Microsoft Office Excel which is necessary to create and work with electronic spreadsheets.
To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows® 10.
Prerequisites:
To ensure success, students will need to be familiar with using personal computers and should have experience using a keyboard and mouse. Students should also be comfortable working in the Windows® 10.
Course Content
Getting Started with Microsoft Office Excel
Performing Calculations
Modifying a Worksheet
Formatting a Worksheet
Printing Workbooks
Managing Workbook
We would like to wish you every success on your educational journey.