Udemy

Most Useful Excel Tips and Tricks - Be the Excel Expert

立即報名
  • 2,164 名學生
  • 更新於 11/2024
4.8
(102 個評分)
CTgoodjobs 嚴選優質課程,為職場人士提升競爭力。透過本站連結購買Udemy課程,本站將獲得推廣佣金,有助未來提供更多實用進修課程資訊給讀者。

課程資料

報名日期
全年招生
課程級別
學習模式
修業期
6 小時 40 分鐘
教學語言
英語
授課導師
Michael Bouwer
評分
4.8
(102 個評分)
4次瀏覽

課程簡介

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.

課程章節

  • 10 個章節
  • 57 堂課
  • 第 1 章 Introduction
  • 第 2 章 Top Ten Tricks
  • 第 3 章 Ribbon & Quick Access Toolbar Tips
  • 第 4 章 Display Shortcuts
  • 第 5 章 Navigation Shortcuts
  • 第 6 章 Selection Shortcuts
  • 第 7 章 Data Entry and Editing Shortcuts
  • 第 8 章 Drag and Drop Techniques
  • 第 9 章 Formula Shortcuts
  • 第 10 章 Operational Shortcuts

課程內容

  • 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


評價

  • 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!

立即關注瀏覽更多

本網站使用Cookies來改善您的瀏覽體驗,請確定您同意及接受我們的私隱政策使用條款才繼續瀏覽。

我已閱讀及同意