0(0)

Excel for Beginners

Description

Excel is a spreadsheet program, which contains a number of columns and rows, where each intersection of a column and a row is a “cell.” It is a powerful program for data analysis and documentation. By the end of this module, you will be able to:

work with formulae and functions
work with graphs
arrange data
organise sheets and workbooks
e.t.c.

Topics for this course

39 Lessons

MICROSOFT EXCEL

Solving Real-Life Problems in Excel 00:04:18

Getting Started 00:04:0012

Creating and Opening Workbooks 00:02:34

Saving and Sharing 00:02:42

Cell Basics 00:04:27

Modifying Columns, Rows and Cells 00:04:47

Formatting Cells 00:04:46

Understanding Number Formats 00:05:43

Working with Multiple Worksheets 00:03:54

Using Find and Replace 00:01:54

Page Layout and Printing 00:05:36

Intro to Formulas 00:03:39

Creating more Complex Formulas 00:05:10

Relative and Absolute Cells References 00:05:24

Functions 00:05:15

Freeze Panes and View Options 00:04:21

Sorting Data 00:04:30

Filtering Data 00:04:46

Groups and Subtotals 00:04:23

Tables 00:03:19

Charts 00:04:30

Conditional Formatting 00:03:49

Comments and Co-authoring 00:04:13

Inspecting and Protecting Workbooks 00:03:13

Intro to Pivot Tables 00:04:34

Doing more with Pivot tables 00:03:28

What if Analysis 00:03:27

Add the Current Date to a Cell 00:00:53

A Faster Way to Use the Fill Handle 00:00:53

Two Ways to Use the Format Painter 00:01:33

A Short Cut to Auto Sum 00:01:15

Quick Access Toolbar Shortcuts 00:01:26

How to Quickly Duplicate a Sheet 00:00:51

Jump to Any Sheet with a Shortcut 00:00:57

Select an Empire Row or Column 00:01:27

Find a Sum without Using a Formula 00:01:10

Why You Should Avoid Merging Cells 00:02:31

Using Quick Analysis Tool 00:01:32

How to Make Charts Auto Update 00:01:32