Microsoft Excel Essentials
This course aims to efficiently familiarize novice computer users with Excel.
Welcome to the first level of our Microsoft Excel training. Excel is a robust and user-friendly spreadsheet program developed by Microsoft. It offers a wide range of tools to efficiently organize, analyze, present, and store data.
The majority of features found in Office 2019 are already available in Office 365. For individuals seeking Office 2019 training, Office 365 serves as an excellent solution.
Our professional instructors can tailor the contents of the course to fit your version of Excel.
per person
Level
Duration
Training Delivery Format
Face-to-face / Virtual Class
per person
Level
Duration
Training Delivery Format
Face-to-face (F2F) / Virtual Class
Class types
Public Class
Private Class
In-House Training
Bespoke
About this course
The Microsoft Excel course is designed to help users create, format, enhance and print simple spreadsheets. The course provides step-by-step guidance, enabling users to navigate the interface, format and edit data, build formulas and functions, and present data in an appealing way.
The course is beneficial for students and professionals looking to improve their data management skills. Experienced instructors lead practical exercises and real-world examples that offer valuable knowledge and skills applicable to everyday work. The course promises to turn users into Excel pros, empowering them with the ability to streamline their data management process.
Who should attend?
This course provides students with the foundational understanding of Microsoft Office Excel, necessary for creating and working with electronic spreadsheets.
Learning Outcome
You will learn;
- Modifying a Worksheet
- Formatting a Worksheet
- Performing Calculations
- Basic Charts
- Printing Workbook Contents
- Refine the Page Layout and Apply Print Options
- Customizing the Excel Environment
Prerequisites
It is recommended that students have either completed an introductory course to Windows or possess a strong working knowledge of the Windows operating system.
Course Content
Module 1: Getting Started with Microsoft Excel
- Identity the Elements of Excel Interface
- Create a Basic Worksheet
- Use the Help System
Module 2: Modifying a Worksheet
- Manipulate Data
- Search for the Replace Data
- Spell Check a Worksheet
Module 3: Formatting a Worksheet
- Modify Fonts
- Add Borders and Colors to Cells
- Apply Number Formats
- Align Cell Contents
- Apple Styles
Module 4: Performing Calculations
- Create Formulas in a worksheet
- Insert Functions in a Worksheet
- Reuse Formulas
Module 5: Visualizing Data with Charts
- Create Charts
- Modify and Format Charts
Module 6: Printing Workbook Contents
- Refine the Page Layout and Apply Print Options
Module 7: Refine the Page Layout and Apply Print Options
- Format Worksheet Tabs
- Manage Worksheets
- Manage the View of Worksheets and Workbooks
Module 8: Customizing the Excel Environment
- Customize Proofing and Save Options
- Customize the Ribbon and Quick Access Toolbar
- Customize the Advanced and Trust Center Options
Classroom Live Labs
- Formatting Rows and Columns
- Search and Replace
- Borders and Colors
- Align Contents
- Functions
- Format Tabs
- Manage Multiple Workbooks
- Custom the Excel Environment
At this time, this course is available for private class and in-house training only. Please contact us for any inquiries.