Office Skills Accelerator:
Office-courses

During this lesson, you'll learn Excel's basic skills for entering and editing data. Through practical exercises, you'll learn how to input, modify, and delete data in Excel, as well as handle different data types.

Additionally, you'll learn about number formatting and get practical tips, such as how to enter phone numbers or postal codes as text.

1. Entering, editing, and deleting data from cells
2. Understanding data types in Excel
3. Undo and redo functions in Excel
4. Modifying and replacing existing data
5. Entering text into cells
6. Entering data starting with zero or special characters
7. Formatting values as postal codes
8. Accessibility and Excel

In the previous lesson, you learned to edit individual cells. In this lesson, you'll learn to work with larger cell groups. You'll start by learning to select multiple cells and entire columns and rows. You'll also learn to modify their size to improve readability. When working with larger datasets, it's important to know how to add and remove rows and columns.

This lesson gives you a deeper understanding of how data is organized in Excel.

1. Selecting cells, columns, or rows
2. Changing row height and column width
3. Adjusting row or column size based on content
4. Fixing the ##### error message
5. Deleting rows and columns

In this lesson, we focus on modifying the appearance of data in Excel. You will start by formatting individual cells, such as setting the percentage format, and then move toward formatting entire tables with predefined styles. You'll also learn to modify fonts, align text, and use various number formats to improve the appearance of your tables.

After this lesson, you'll be able to create Excel tables that are both readable and professional.

1. Formatting fonts (size, bold, italic, underline, color change)
2. Text alignment
3. Number formatting
4. Adding and removing decimals
5. Percentage formatting
6. Predefined cell styles
7. Removing formatting: deleting content and formatting
8. Removing formatting: deleting only formatting
9. Removing formatting: deleting content without removing formatting

In this lesson, we'll delve into Excel's core functionality: calculations. You'll learn to create formulas and use basic mathematical operations like addition, subtraction, multiplication, and division. You'll also get acquainted with the basic structure of Excel formulas.

You'll also get an introduction to Excel functions, which are pre-built calculation tools. You'll learn to use functions to quickly calculate sums, averages, and other key statistical measures.

1. Cell references
2. Basic arithmetic operations: addition, subtraction, multiplication, and division
3. Using the = sign to start a formula
4. Copying formulas: changing references according to the copy direction
5. Predefined functions
6. Sigma menu
7. Calculating sums
8. Calculating row and column totals at once
9. Calculating the sum of sums
10. Calculating averages, maximum, and minimum values

This lesson deepens your previous knowledge related to formulas, especially cell referencing in Excel. The focus is on absolute references, denoted by the $ symbol. Absolute references allow you to copy formulas while keeping the references unchanged, such as when calculating discount percentages.

If this seems complex, this lesson will help you understand it in practice.

1. Introduction to relative and absolute references
2. Default relative references in formulas
3. Changing relative references according to the copy direction
4. Absolute references and their practical use
5. Denoting absolute references with the $ symbol
6. Adding absolute references with the F4 key or manually

This lesson focuses on presenting the results of your calculations using charts. You'll learn to modify the appearance of charts and select the appropriate chart type for different types of data. We specifically cover stacked column charts and pie charts, including how to add data points and other important information.

By mastering the use of these basic chart types, you'll be able to present information clearly and professionally.

1. Basics of Excel charts
2. Usage possibilities of different chart types
3. Adding a column chart
4. Moving and scaling a chart
5. Adding a title to the chart
6. Changing the chart type
7. Adding and formatting data points in the chart
8. Filtering data from the chart
9. Adding and formatting a pie chart

In the final lesson, you'll learn to print Excel tables and charts and edit printouts so they look professional. This lesson equips you with the skills to ensure your printouts match the high quality of your presentations.

1. Printing a table
2. Printing a chart
3. Modifying print settings
4. Defining and editing the print area
5. Removing the print area