Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Personal Transformation Life Purpose Meditation Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
2021-02-07 13:37:19
30-Day Money-Back Guarantee
Office Productivity Microsoft Excel

50 MS Excel Tips to Upgrade your Excel Skill to next Level

Learn hidden Excel features to improve your Excel experience and use it like a pro
Rating: 4.7 out of 54.7 (35 ratings)
1,108 students
Created by Sandip Banerjee
Last updated 1/2021
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Microsoft Excel
  • Excel Tips
  • MS Excel
  • Excel Productivity Tips

Requirements

  • Microsoft Excel 2016 or later version is required to work on all tips

Description

Microsoft Excel is the most widely used spreadsheet program being used by users across the World. While this program is being widely used by millions of users, still full capability of this program is not known to majority of regular users. There are countless features and shortcuts are available within Excel which can help users to save precious time.

In this course I tried to cover such tips which I use on regular basis during my day to day work. I personally found these features very useful and helped me to be more productive.

I have tried to make all these features available in same place, so that it can help others also to be more productive while using MS Excel. Hopefully this will be helpful.

There are 5 sections in this course and each section contains 10 tips which will help you be more productive while using MS Excel. Tips in each of sections are not grouped in a specific order. I kept all tips random to avoid any monotonous flow. You can pick up any tip in any order as per your wish and requirement.

In case you have any question, please feel free to post in Q&A section. I will try to answer within 48 hours of time. Happy Learning ?

Who this course is for:

  • Excel users with some level of working knowledge
  • Excel users who wants to learn time saving tips to improve productivity

Course content

7 sections • 52 lectures • 2h 58m total length

  • Preview01:50

  • Preview04:55
  • Tip #2: Add Line Break in Formula Bar
    02:43
  • Tip #3: Advanced Copy-Paste using Office Clipboard
    03:13
  • Tip #4: Navigation between Worksheets using Shortcut Keys
    01:15
  • Tip #5: Flash Fill
    02:15
  • Tip #6: Add Multiple Rows and Columns Quickly
    02:21
  • Tip #7: Delete Blank Rows
    03:16
  • Tip #8: Multi Level Row and Column Sorting
    04:04
  • Tip #9: Add Sparklines
    02:38
  • Tip #10: Paste Special - Transpose
    03:06

  • Tip #11: Snap to Grid
    02:53
  • Tip #12: Create Custom Autofill List
    06:11
  • Tip #13: Absolute Cell Reference
    02:59
  • Preview04:16
  • Tip #15: Move Cell Direction
    02:32
  • Tip #16: Delete Data using Mouse
    01:30
  • Tip #17: Status Bar Quick Calculations
    02:35
  • Tip #18: Link Text Boxes to Cell
    03:34
  • Tip #19: Phone Number and ZIP Code Format
    04:24
  • Tip #20: Speaking Cell
    04:46

  • Preview03:08
  • Tip #22: Worksheet Grouping
    03:49
  • Tip #23: Advanced Transpose
    03:59
  • Tip #24: XLStart Folder
    03:16
  • Tip #25: Use Slicers
    04:54
  • Tip #26: Convert Text to Numbers
    02:50
  • Tip #27: Hiding Workbook Elements
    02:12
  • Tip #28: Useful Shortcut Keys
    03:22
  • Tip #29: Sort data from Left to Right
    02:43
  • Tip #30: Advanced Filter (Complex)
    10:54

  • Preview02:26
  • Tip #32: Synchronous Scrolling
    02:35
  • Tip #33: Quick Analysis of data within Excel
    02:27
  • Tip #34: Fill blank cells with Value
    02:58
  • Tip #35: Hidden Chart Source Data
    03:12
  • Tip #36: Two more Shortcuts
    02:40
  • Tip #37: Add Blank Rows
    03:27
  • Tip #38: Custom views in Excel
    05:45
  • Tip #39: EMBED Feature
    04:04
  • Tip #40: Adding Country code in Mobile Numbers
    03:52

  • Preview04:08
  • Tip #42: 3D Referencing
    04:25
  • Tip #43: Extract Unique Values
    03:14
  • Tip #44: Excel Array Formula
    04:03
  • Tip #45: Forecast Sheet
    03:35
  • Tip #46: Add Spin Controls in Excel
    05:10
  • Tip #47: Move Data using Mouse
    01:27
  • Tip #48: Add new entry in Auto Correct to use across Office Applications
    05:05
  • Preview02:05
  • Tip #50: Find formulas Quickly
    02:13

  • Thank You
    01:08

Instructor

Sandip Banerjee
MBA & PRINCE2 Certified Practitioner
Sandip Banerjee
  • 4.6 Instructor Rating
  • 56 Reviews
  • 1,612 Students
  • 2 Courses

If you're reading this probably you might be interested in what I do. I am an Online Educator and IT Professional with 20 years of experience in technology consulting, teaching and project management. I hold MBA in Project Management and also a PRINCE2 certified practitioner. I manage a team of 300 people in my day job and support multiple companies across the globe. Teaching is my passion and I love to share my knowledge and experience with many people with my courses and deliver some value to them.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.