Intermediate Excel Training

COURSE DETAILS

  • Lifetime Access $ 87
Course Level: 
Intermediate
Trainer: 
barnaby.waights
Duration: 
9 hr 56 min 19 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
- Excel as a Database
Introduction to Databases
  • 00:05:51
Filtering Data
  • 00:07:28
Removing Duplicates
  • 00:05:38
"Text to Columns" & Using Flash Fill
  • 00:06:17
Tables
  • 00:07:12
Querying the Web
  • 00:06:21
Pivot Tables
  • 00:11:14
Pivot Tables contd.
  • 00:08:13
- Expressing Data Graphically
Creating Charts
  • 00:09:29
Customising Charts
  • 00:05:22
Charts as a Sheet
  • 00:02:08
Chart Types
  • 00:05:45
Chart Styles & Formatting
  • 00:05:24
Adding Trendlines
  • 00:03:57
- Advanced Formulas
Using the "IF" Function
  • 00:10:12
Text Formulas
  • 00:15:37
Date Functions
  • 00:14:30
SUMIF & COUNTIF Functions
  • 00:06:21
SUMIFS & COUNTIFS Formulas
  • 00:12:47
Using SUMIF to create Summary Tables
  • 00:07:05
Ranking Formulas
  • 00:06:18
The VLOOKUP Formula
  • 00:18:12
Formula Auditing Tools
  • 00:08:47
- Excel Web Functionality
Office Web Applications
  • 00:07:05
Microsoft OneDrive
  • 00:06:05
- Conclusion
Conclusion
  • 00:02:23

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 foundation course incorporates all of the essential knowledge of Excel covering how to navigate through the different areas of Excel down to using Excel formulas and a variety of data tools including those two critical CV building skills. VLOOKUP and PivotTables.

This course is aimed a Excel beginners and Intermediate users. Watching this course student gain value from the in-depth coverage of Excel Security Features, Office Apps (Excel 2013) and Conditional formatting, in addition to more advance formulas including IF, SUMIF and VLOOKUP. The course also examines critical excel tools such as Formula Auditing and Charting features.

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

OTHER COURSES

FREE
FREE
FREE
FREE