Course Content
Excel for Beginners
Excel for Beginners
1. Introduction to Excel
2. Working with Worksheets and Workbooks
Add, Delete, Rename, and Rearrange WorksheetsGrouping and Ungrouping WorksheetsUsing the Format PainterInserting and Deleting Columns, Rows, and CellsHiding and Unhiding Columns and RowsSaving WorkbooksOpening and Closing WorkbooksProtecting Workbooks with PasswordsUsing TemplatesQuiz: Managing WorkbooksSummary
6. Entering and Formatting Data
Getting Acquainted with Excel
Excel helps you organize, analyze, and visualize data, from budgets to big data. It's used across industries due to its accessibility, versatility, and power. You can manage budgets, analyze sales figures, track inventory, and even plan events.
Let's explore why you should consider integrating Excel into your everyday workflow:
Excel Workbooks
In this course, you'll engage with specially designed Excel Workbooks that are tailored for your training. Initially, you may find it helpful to use these Workbooks to practice techniques demonstrated in our videos.
You can download the Workbook here and start practicing on your own:
Key Points
- Workbooks are like digital binders containing multiple spreadsheets;
- Each spreadsheet is organized into rows and columns, creating a grid for data entry and manipulation;
- You can add new spreadsheets by clicking the
+
sign at the bottom; - Each cell, identified by its column and row location, serves as the fundamental building block where you enter data;
- Ranges refer to selections of cells used for calculations, formatting, or creating charts.
Everything was clear?
Thanks for your feedback!
Section 1. Chapter 2