This Microsoft Excel: Getting Started online training course covers the basics on Excel worksheets and will provide learners with a solid foundation in creating, editing, and formatting spreadsheets.
This Microsoft Excel: Getting Started online training course covers the basics on Excel worksheets and will provide learners with a solid foundation in creating, editing, and formatting spreadsheets, using formulas and functions to perform calculations, and analyzing data through charts and graphs.
Course Learning Objectives
By taking this online Microsoft Excel: Getting Started course, the user will learn to:
- Understand the fundamental concepts of spreadsheets and how they can be used to organize, analyze, and present data.
- Become familiar with the Excel interface and be able to navigate the different menus and options.
- Create, edit, and format basic spreadsheets and workbooks, including entering and formatting data, adjusting column and row widths, and applying basic formatting options such as borders and shading.
- Use formulas and functions to perform calculations on data within spreadsheets, such as addition, subtraction, multiplication, division, and more complex calculations like averages and percentages.
- Utilize built-in tools and features to manipulate data, such as sorting and filtering to organize data and find specific information.
- Understand how to create and customize charts and graphs to visualize data concisely.
- Learn techniques for managing multiple worksheets and workbooks, including copying, and pasting data, linking data between worksheets, and organizing data within a workbook.
- Customize the Excel interface to suit individual needs, such as changing the display options or setting up keyboard shortcuts.
- Explore additional features of Excel, such as conditional formatting and XLookup, to expand knowledge and enhance productivity.
- Understand the importance of data security and best practices for protecting and sharing Excel files with others.
Course Outline
This online Microsoft Excel: Getting Started course is made up of the following sections:
- Fundamentals of Excel
- Entering and Formatting Data
- Formulas and Functions
- Built-in Tools and Features
- Charts and Graphs
- Managing Multiple Sheets
- Customization
- Xlookup and Conditional Formatting
- Protecting Your Work in Excel
- Pro Tips
Course Audience
This Microsoft Excel: Getting Started online training course was designed for beginners or intermediate users.
If you have any concerns as to whether this course is appropriate for you or your industry, please browse our full selection of online courses.
