Excel for Beginners

COURSE DETAILS

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

No votes yet

Trainer: 
  • DURATION
  • VIEWED
- Introduction
Introduction
  • 00:04:17
- 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

man with his chakras highlighted
FREE
chinese superman
FREE
FREE
FREE

Please sign up to view our
FREE video courses

Or log in with...

By signing up, you agree to our Terms and Privacy Policy