Udemy

Most Useful Excel Tips and Tricks - Be the Excel Expert

Enroll Now
  • 2,164 Students
  • Updated 11/2024
4.8
(102 Ratings)
CTgoodjobs selects quality courses to enhance professionals' competitiveness. By purchasing courses through links on our site, we may receive an affiliate commission.

Course Information

Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
6 Hour(s) 40 Minute(s)
Language
English
Taught by
Michael Bouwer
Rating
4.8
(102 Ratings)
1 views

Course Overview

Most Useful Excel Tips and Tricks - Be the Excel Expert

Tips, Tricks and Shortcuts for Microsoft Excel That Will Increase Your Output by 200%

Michael Bouwer, an Excel expert, guides Microsoft Excel users in elevating their proficiency with spreadsheets by sharing an array of helpful shortcuts and techniques.

He kicks off by unveiling top productivity enhancing tips. Then, he delves into effective methods for navigating, displaying, and selecting data swiftly.

The course further delves into strategies for data input and modification, clever formatting tricks, drag-and-drop techniques, as well as keyboard shortcuts designed to streamline formula manipulation.

It also covers smart data management approaches and innovative ways to manipulate charts.


Topics include:

  • Performing calculations without relying on formulas

  • Applying formatting using convenient keyboard shortcuts

  • Employing database techniques to effectively manage Excel data

  • Swiftly navigating within workbooks for improved productivity

  • Selecting noncontiguous ranges with ease

  • Quickly creating split screens for efficient multitasking

  • Easily converting formulas to values through simple drag-and-drop actions

  • Accessing the Ribbon directly from the keyboard

  • Instantly inputting today's date or time

  • Utilizing keyboard commands for undoing and redoing actions

  • Streamlining data movement through drag-and-drop functionality

  • Enhancing data entry efficiency

  • Working proficiently with charts, shapes, and linked images

This is the perfect course for Microsoft Excel users that want to up their Excel skills to the next level.

Impress your boss just that little bit more.


All the Resource Files are provided which can be downloaded for free.

Course Content

  • 10 section(s)
  • 57 lecture(s)
  • Section 1 Introduction
  • Section 2 Top Ten Tricks
  • Section 3 Ribbon & Quick Access Toolbar Tips
  • Section 4 Display Shortcuts
  • Section 5 Navigation Shortcuts
  • Section 6 Selection Shortcuts
  • Section 7 Data Entry and Editing Shortcuts
  • Section 8 Drag and Drop Techniques
  • Section 9 Formula Shortcuts
  • Section 10 Operational Shortcuts

What You’ll Learn

  • Become the Microsoft Excel Expert Everyone Looks Up To
  • Learn the Shortcuts and Tricks to Make Your Excel Skills Shine
  • Ribbon and Quick Access Toolbar Tips
  • Display, Navigation, Selection and Data Entry & Editing Shortcuts
  • Drag and Drop Techniques That Make You the Excel Master
  • Formula, Operational and Formatting Shortcuts
  • Data Management Techniques that Everyone Wishes They Knew
  • Charting and Visual Object Tips


Reviews

  • S
    Shelly Candler
    5.0

    Easy to understand and having the resources ready to go is very helpful.

  • R
    Robyn Viljoen
    5.0

    Explanations are very easy to understand, the pace is perfect and everything I am learning will help me be more productive and efficient in my new job.

  • L
    Lenine Joseph
    4.5

    I am learning so much, thank you.

  • S
    Shimelis Engida Tessema
    4.0

    thanks, a lot it is an important tip and also an amazing shortcut for beginners!

Start FollowingSee all

We use cookies to enhance your experience on our website. Please read and confirm your agreement to our Privacy Policy and Terms and Conditions before continue to browse our website.

Read and Agreed