Excel at Excel - Excel Tips, Excel Tricks, Excel Hacks

Learn the Best Kept Excel Secrets - Excel at Excel, Become an Excel Superstar and Save Time
0.0 (0 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
7 students enrolled
$19
$20
5% off
Take This Course
  • Lectures 24
  • Length 2 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 3/2016 English

Course Description

Learn Microsoft Excel Tips, Tricks and Hacks that I have learned over the past 12 years using Microsoft Excel.

Become the superstar at your organization and impress your colleagues and managers.

I used these Excel tips and tricks to propel myself into the Microsoft Excel expert at my work. This prestige created confidence in my work with my supervisors and lead to increasing roles within the organization.

On top of being known as the Excel expert, you will gain efficiencies that save you time. The more efficient you are with Excel the less time you need to spend using Excel. This means you can spend more time on the truly important parts to climb the corporate ladder.

The course contains over 1 hour and 45 minutes of valuable Microsoft Excel content. You will learn about Paste Special, Keyboard Shortcuts, Formatting, Re-sizing, and so much more.

The course is structured into 5 sections. Each section can be done on its own at your own pace. There is no order to the sections so you can start at any point and you won't be lost.

You should take this course to improve your Microsoft Excel skills. The Tips, Tricks & Hacks will take your Microsoft Excel skills to the next level.

What are the requirements?

  • Basic knowledge of Microsoft Excel.
  • The desire to increase your skills using Microsoft Excel.

What am I going to get from this course?

  • Learn Excel tips, tricks and Hacks that they can apply on the job.
  • Utilize these tips, tricks and hacks to impress colleagues and get ahead.
  • Over 1 hour and 45 minutes of content.
  • Increased confidence and ability with Excel.
  • Become an Excel Master and the "go-to" person at your job.

What is the target audience?

  • Anyone looking to improve their Microsoft Excel skills.
  • Anybody from Novice to Expert can benefit from this collection of Excel Tips, Tricks & Hacks
  • Ideal for all users of Microsoft Excel (Managers, Employees, Students, Consultants, Entrepreneurs, etc.)

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Paste Special Tips, Tricks & Hacks
01:17

In this section you will learn several useful Paste Special Tips, Tricks and Hacks.

04:28

In this lecture you will learn how to use the Paste Special options as well as handy shortcuts for each.

04:53

In this lecture you will learn about Paste Special Operations and how to apply them in your Excel tasks.

03:34

In this lecture you will learn how to setup a shortcut to Paste Special Values quickly.

03:12

In this lecture you will learn how to setup a shortcut to Paste Special Formulas quickly.

03:40

In this lecture you will learn a shortcut that allows you to paste to non-consecutive rows in a spreadsheet.

Section 2: Keyboard Shortcuts
01:06

In this section you will learn many different Keyboard Shortcuts.

05:58

In this lecture we will cover the basic Keyboard Shortcuts that you need to know.

05:25

In this lecture we will cover Keyboard Shortcuts that will save you time when working in Microsoft Excel.

05:43

In this lecture we will cover several useful Keyboard Shortcuts that make it easier to move around a spreadsheet or select data.

03:14

In this lecture we will cover several other useful Keyboard Shortcuts.

Section 3: Excel Formatting Tips, Tricks & Hacks
01:00

In this section we will cover Excel Formatting Tips, Tricks and Hacks.

04:34

In this lecture we will cover useful Worksheet Formatting Tips.

03:01

In this lecture you will learn about the Format Painter Tool.

11:13

In this lecture you will learn about Conditional Formatting.

Section 4: Re-sizing Tools
00:55

In this section you will learn about various Re-sizing Tools available.

04:18

In this lecture you will learn several useful column width tips and tricks.

03:19

In this lecture you will learn how to re-size the scrollbar.

Section 5: Useful Excel Functions
01:10

In this section you will learn several Useful Excel Functions.

06:57

In this lecture you will learn how to use Excel's Left, Right and Mid functions.

06:17

This lecture covers the VLOOKUP and HLOOKUP functions.

08:17

In this lecture you will learn to use the Index and Match functions.

05:20

In this lecture you will learn several useful Date functions.

07:41

In this lecture you will learn several other useful Excel functions.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Clayton Zaluski, Excel Expert, Online Instructor, Entrepreneur, Actuary

I have been involved with Online Training for the past year and have taught students from around the world. I am dedicated to teaching the skills that I have gained over the years and want my students to succeed. I started this process because I wanted to pass my knowledge on to others and help them succeed in their respective careers. I am a fully qualified Actuary practicing in Canada. I have a Bachelor of Commerce degree from the University of Manitoba, Canada.

Ready to start learning?
Take This Course