Excel Class - Introduction

This Excel course teaches you the foundations of Excel including essential Excel formulas and how to work efficiently and effectively using Excel. You also learn techniques for working with and managing data in Excel, including how to use calculations, apply formatting to content, and how to create charts. The course includes multiple projects that help you practice and apply the skills you learn in this live, hand-on class. This one-day course provides a solid foundation for jobs that require Excel.

In this Excel course you will learn:

• Calculations and Formulas: Discover how to use Excel for calculations including sum, average, and counts as well as how to calculate and tabulate data easily with built-in formulas.
• Efficient Data Entry: Learn how Excel can automatically complete text and numbers, reducing data entry work while improving accuracy.
• Text Functions: Find out how to use functions for formatting and correcting text, including removing unnecessary spaces, changing the case of text, and extracting specific characters.
• Formatting text, numbers, and cells: Understand how to apply formatting and color to text and cells and set the alignment of text and numbers within cells, both vertically and horizontally.
• Format Painter: Discover how to easily copy formatting between cells.
• Conditional Formatting: Learn to create format requirements for cells based on specific criteria. For example, set all positive values to green with negative values set to red.
• Charts and Graphs: Learn the basics of creating charts and graphs for data visualization. Find out how to create charts including pie charts, line graphs, and bar charts.
• Quick Access Toolbar: Discover how to work more efficiently by saving commonly used functions and commands with the Quick Access Toolbar.
• Cell Referencing: Learn to create references to cells, allowing you keep formulas accurate even as cell content changes, and making it possible to copy formulas to other cells.
• Lock values: Learn to lock the values in specific cells so they can be consistently referenced or used in formulas.
• Excel efficiency tips: Learn to work efficiently, having Excel automate your work.