Excel for Beginners

COURSE DETAILS

  • Lifetime Access $ 10
Course Level: 
Beginner
Trainer: 
barnaby.waights
Duration: 
6 hr 30 min 38 sec

No votes yet

Trainer: 
  • DURATION
  • VIEWED
- Introduction
- Overview of Excel 2013
Navigating the Workbook
  • 00:11:54
Quick Access Toolbar & Customizing It
  • 00:03:58
The Ribbon
  • 00:07:27
- Working with Excel Workbook Files
Working with Excel Workbook Files
  • 00:14:18
- Entering Data
Processing Text & Numbers
  • 00:15:16
Copy & Paste
  • 00:13:34
Paste Special
  • 00:08:13
Clearing Cells
  • 00:04:43
Undo & Redo
  • 00:08:09
Inserting Cells, Columns & Rows
  • 00:10:32
Deleting Cells, Columns & Rows
  • 00:04:24
Changing Columns Width & Row Height
  • 00:06:01
Hide/Unhide Columns
  • 00:03:18
Grouping Rows & Columns
  • 00:04:55
Find & Replace
  • 00:14:29
- Managing Workbook Elements
Renaming, Moving Sheets & Changing Tab Colour
  • 00:06:34
Inserting, Deleting, Copying & Hiding Workbooks
  • 00:04:00
Multiple Workbooks, New Windows & Hiding Sheets
  • 00:06:01
- Printing & Page Setup
Print Areas
  • 00:11:10
Page Margins
  • 00:01:38
Header, Footer & Print Titles
  • 00:03:45
Workbook Views
  • 00:04:22
Exporting
  • 00:04:38
- Worksheet Formatting
Font Style & Colour
  • 00:11:20
Merging Cells
  • 00:05:34
Formatting Numbers
  • 00:08:58
The Format Painter
  • 00:05:05
Combining Formatting Techniques
  • 00:07:58
- Carrying out Calculations
Addition, Subtraction & General Formula Notation
  • 00:05:54
Multiplication & Division
  • 00:06:04
Order of Operations
  • 00:03:18
Introduction to Functions
  • 00:11:54
Useful Functions
  • 00:11:13
Relative & Absolute Referencing
  • 00:11:22
Formulas across Worksheets
  • 00:03:37
3D Referencing
  • 00:07:35
Named Ranges
  • 00:10:21
Basic Formula Auditing
  • 00:06:40
- Advanced Formatting
Formatting as a Table
  • 00:06:44
Using Themes
  • 00:02:48
Using Cell Styles & Custom Styles
  • 00:05:42
Data Validation
  • 00:12:30
Working with Comments
  • 00:02:23
- Conditional Formatting
Introduction to Conditional Formatting
  • 00:08:09
Highlighting Duplicate Values
  • 00:01:57
Data Bars
  • 00:04:40
Colour Scales
  • 00:03:20
Icon Sets
  • 00:03:59
Basic Formulas
  • 00:05:23
- Security
Protecting an Excel File
  • 00:05:31
Protecting a Worksheet
  • 00:02:42
Protecting Part of a Worksheet
  • 00:06:18
Protecting a Workbook
  • 00:02:02
- Graphical Objects
Inserting & Modifying Images
  • 00:05:22
Office Apps
  • 00:02:47
Adding a Background
  • 00:02:31
Adjusting Formatting
  • 00:04:50

Microsoft Excel is an an essential tool for almost anyone working in an office environment with an estimated 500 million active users worldwide. Excel allow you to create anything from a simple shopping list to a complex reporting tool.

This introductory course incorporates all of the foundation knowledge of Excel covering how to navigate through the different areas of Excel down to using Excel formulas and a variety of formatting tool.

This course is aimed a Excel beginners, but intermediate users may gain value from the in-depth coverage in this course including Excel Security Features, Office Apps (Excel 2013) and Conditional formatting.

This course does not contain any course materials.
Login to Post Review

OTHER COURSES

$ 10.00
Beijing city
$ 10.00
$ 10.00
FREE