Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Most Useful Excel Tips and Tricks - Be the Excel Expert
Rating: 4.7 out of 5(104 ratings)
2,167 students

Most Useful Excel Tips and Tricks - Be the Excel Expert

Tips, Tricks and Shortcuts for Microsoft Excel That Will Increase Your Output by 200%
Created byMichael Bouwer
Last updated 11/2024
English

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

Course content

12 sections57 lectures6h 40m total length
  • Introduction1:26
  • Structure and Pace1:51
  • Exercise Files1:52

    Download the exercise files for each section, open the separate workbooks with multiple sheets, and practice the shortcuts, tips, and tricks.

Requirements

  • Basic understanding of Microsoft Excel
  • Having Completed a Beginners Course in Excel Will Make It More Beneficial (Not Compulsory)

Description

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.

Who this course is for:

  • Users of Microsoft Excel that want to increase their productivity
  • Learners with basic Excel knowledge and want to improve
  • If you have a desire to take your Excel skills and knowledge to the next level
  • For anyone that uses and Excel and want to use it better and in a faster way