Sorry, your browser is not supported
To have the best experience using Skillshare, we recommend that you use one of these supported browsers.
Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
25 Videos (3h 33m)
    • Course Introduction

      7:02
    • Hiding Rows and Columns

      9:08
    • Freeze Panes

      8:25
    • Group and Outline

      8:20
    • Arrange All

      6:05
    • Multiple Sheets New Window

      4:30
    • Linking

      13:06
    • Paste Special

      15:31
    • Introduction to VLookup and HLookup

      2:12
    • Range Names

      6:43
    • VLookup Syntax

      8:53
    • Using VLookup

      9:31
    • Using HLookup

      6:12
    • Introduction to IF Statements

      5:27
    • Creating IF Statements

      14:26
    • CountIF

      12:37
    • SumIF

      8:55
    • AverageIF

      6:46
    • Applying Conditional Formatting

      8:31
    • Text, Duplicate and Formula Rules

      11:16
    • Top Bottom Rules

      5:25
    • TODAY NOW and NETWORKDAYS

      9:46
    • YEARFRAC

      5:36
    • TEXT, LOWER, UPPER, PROPER, TRIM

      12:32
    • CONCATENATE

      6:05

About This Class

ac34783b

This course is ideal for those who already use Excel at Introduction level and want to build on the knowledge you know. You will be introduced to a whole range of useful tools, shortcuts and functions. From managing large amounts of data to advanced functions such as VLookup, HLookup and IF Statements. Whatever you use Excel for in your work life, this course will give you the essential skills to take your Excel knowledge to the level expected in the working environment. 

1

Student

--

Projects

0

Reviews (0)

Simon Lambourne

Microsoft Certified Trainer

I have been an IT trainer for over 8 years and have acquired many skills in teaching different software packages to students of all abilities. I aim to build confidence in all attendees of the courses that I teach, for both large and small groups. Through my professional conduct and enthusiasm when working with learners of mixed levels, I am able to create good rapport with students, which forms a high-quality learning environment. I believe it is important to enjoy attending each training co...

See full profile