Microsoft Excel For Beginners
- Description
- Curriculum
- FAQ
- Reviews
In this course, you will learn the important fundamentals of Microsoft Excel, as well as how charts work and how to use them.
Microsoft Excel is one of the most widely used programs for organizing information and data using spreadsheets. This is due not only to the ease of learning and use of the program, but also to the wide range of customization options that it offers.
Excel is used around the world in both professional and private environments, and during this course you will understand why Excel is still one of the most popular and powerful applications.
I use short lectures during the course, giving you the ability to stay focussed and really remember what was taught in each lecture at the end of the lecture.
By taking this course, you will be learning the following aspects of Microsoft Excel:
- What is Microsoft Excel
- Understanding Workbooks
- How to type text and numbers into a worksheet
- How to use simple formulas in a worksheet
- Filling a series
- Inserting and deleting worksheets
- Copying a worksheet
- Renaming a worksheet
- Moving or copying a worksheet to another workbook
- Worksheet formatting
- How to freeze rows and columns
- How to select ranges, rows and columns
- How to use general formatting
- Wrapping and merging text
- Quick Formatting
- Quick Charting
- Quick Totals
- Quick Tables
- Quick Sparklines
- Finalizing Workbooks
- A free bonus lesson for completing the course
I hope you enjoy and happy learning 🙂
-
4
Microsoft Excel WorkbooksWhat are workbooks in Microsoft Excel
-
5
How to navigate in a file
How to navigate inside an Excel Workbook and Worksheet
-
6
Typing in a Microsoft Excel Worksheet
In this lesson I will teach you how to type in an Excel Worksheet
-
7
How to use simple formulas in a worksheet
In this lesson I will teach you how to create a simple formula in Excel
-
8
Filling A Series
In this lesson I will teach you how to fill a series in Excel
-
9
Inserting And Deleting Worksheets
In this lesson I will show you how to insert and delete worksheets in Excel
-
10
Copying A Worksheet
In this lesson I will show you how to copy a worksheet in Excel
-
11
Renaming A Worksheet
In this lesson I will show you how to rename a worksheet in Excel
-
12
Changing Worksheet Tab Colours
In this lesson I will show you how to change to colours of the worksheet tabs
-
13
Freezing Rows And Columns
In this lesson I will show you how to use the Freeze Panes tools to freeze rows and columns
-
14
Selecting Ranges, Rows and Columns
In this lesson I will show you how to select ranges, rows and columns
-
15
Understanding Formatting
In this lesson I will explain what formatting is in Excel
-
16
Applying General Formatting
In this lesson I will teach you how to apply general formatting in Excel
-
17
Changing Fonts and Font Sizes
In this lesson I will show you how to apply formatting to fonts in your Excel worksheets
-
18
Borders
In this lesson I will teach you more about borders as a tool for formatting in Excel
-
19
Wrapping And Merging Text
In this lesson I will show you how you can merge cells and wrap text or data within a cell
