course content

Course Content

Excel Beginner Course

1. Getting Started with Excel

What is Excel?The Excel InterfaceEntering DataFormatting DataUsing Keyboard ShortcutsPrinting Worksheets

2. Working with Formulas and Functions

Creating FormulasUsing FunctionsDifferent Types of FunctionsUnderstanding Excel ErrorsDebugging Formulas

3. Creating and Formatting Charts

Introduction to Data VisualizationDifferent Types of ChartsAdding Data LabelsAdditional Customizations for ChartsCreating and Formatting Sparklines

4. Managing Data

Sorting and Filtering DataCreating and Managing TablesImporting and Exporting DataWorking with Databases

5. Advanced Topics

Using Pivot TablesMacros and VBACreating Custom FunctionsWorking with Large Datasets

Excel Beginner Course

Formatting DataFormatting Data

Formatting data in Excel is a crucial aspect of creating visually appealing and well-organized spreadsheets. It will help you make your data more understandable and presentable. The most important formatting options revolve around cells. Look at the gif below and emulate the actions within your Excel workbook!

  1. Font Formatting
  2. Cell Borders
  3. Cell Fill Color
  4. Alignment and Text Orientation
  5. Number Formatting

Now I would like you to replicate the steps described in the GIF above and answer the following questions.

1. Is Robot medium among the font options?
2. How many options do I have to format a date? (only considering the menu shown in the GIF)

question-icon

Is Robot medium among the font options?

Select the correct answer

question-icon

How many options do I have to format a date? (only considering the menu shown in the GIF)

Select the correct answer

Everything was clear?

Section 1. Chapter 4