Getting to Know Excel
This lesson introduces the fundamentals of Excel, including navigating its interface, understanding workbooks and worksheets, and mastering basic data entry. You'll learn how to input labels, numeric data, and fractions, move efficiently within a worksheet, and save your work in various formats, ensuring your files are well-organized and accessible.
Modifying a Worksheet's Structure
In this lesson, you'll explore how to modify the structure of a worksheet by selecting, moving, and copying data. Topics include inserting and deleting rows, columns, and cells, merging cells, and using shortcuts to streamline tasks. These skills will enable you to organize and manipulate data effectively.
Using Formulas and Functions
This lesson focuses on creating and using formulas and functions to perform calculations in Excel. You'll learn about simple formulas, essential aggregate functions like SUM and AVERAGE, and time-saving tools like AutoFill and Flash Fill. These techniques will help you automate calculations and save time.
Formatting Cells and Their Content
Learn how to format cells, rows, and columns to enhance the readability and appearance of your data. This lesson covers text alignment, cell borders, fill colors, number formatting, and custom cell styles. These formatting techniques will give your spreadsheets a polished and professional look.
Formatting and Printing a Worksheet
This lesson covers preparing your worksheet for presentation and printing. Topics include modifying page setup, applying headers and footers, using themes, and printing to PDF or other formats. You'll learn to optimize your worksheets for both digital and physical distribution.
Referring to Cells, Ranges, and Formulas
In this lesson, you'll explore cell references, including relative, absolute, and mixed references, and learn to name ranges for clarity and ease of use. You'll also practice resolving formula errors and using tools to display and troubleshoot formulas effectively.
Using Multiple Sheets and Workbooks
This lesson focuses on managing and linking data across multiple sheets and workbooks. You'll learn to add, delete, and group sheets, reference data across worksheets, and link content to other applications, expanding your ability to manage complex projects.
Working with Tables
This lesson introduces Excel tables, showing you how to create, format, and manage table data. You'll explore sorting, filtering, adding totals, and using table styles to make your data more organized and interactive.
Charting Data
This lesson teaches you to visualize data with charts. You'll create and modify various chart types, format chart elements, and apply styles to make your data presentations clear and impactful. Topics include pie charts, bar charts, and advanced chart customizations.
Using Aggregate, Statistical, and Financial Functions
This lesson explores several types of powerful functions. We start with a review of aggregate functions, and then turn our attention to statistical functions like AVERAGE and standard deviation, as well as financial functions such as PMT and PV to calculate loan values and payments.
Creating Business Forms
This lesson explores using Excel to create professional business forms, including calendars, invoices, and purchase orders. You'll learn to design layouts, apply formatting, and incorporate formulas to create functional and visually appealing forms.
Working with Templates
In the final lesson, you'll learn to create and use templates to save time and ensure consistency across projects. Topics include using Excel's built-in templates, designing custom templates, and creating chart templates for reuse. This lesson helps streamline your workflow and maintain professional standards.