Become Efficient at your Excel Shortcuts, with over 30+ Excel Hacks and Excel Tricks with Practice files.
Free tutorial
10,065 students
1hr 50min of on-demand video
Created by Kadhiravan Jayachandiran
What you’ll learn
- Shortcuts and Hacks on Excel environment, Workbooks & Worksheets, Formatting Tips
- Increase your Productivity and Be the Excel Pro of your workplace
- Understand the Excel Hacks completely with the help of the Custom-Build Practice Files
- Improve your Excel Skills using the latest version of Office Excel 365
Requirements
- Basic Excel Knowledge
- Access to any version of Excel
Description
Knowing Excel is the easiest part, becoming efficient at it is the hardest journey you’ll ever encounter.
However that very journey of becoming efficient with Excel is for eternity. They say “Excel is an Ocean and you can only explore it so much”. This stands true and in reality no matter how much you learn it just adds very little knowledge.
In this course we’ll see about a lot of hacks and tricks that mostly gets missed from our naked eye while using excel. Some of these can blow you away & some of them you would already be aware of.
Please remember none of the course’s video is longer than 2 minutes in length and ensure to complete the assignments as you progress through.
In this Course you’ll learn a lot of Hacks and tips to become efficient in the below areas.
- Navigation between Sheets and Files
- Managing Rows, Columns and Sheets
- Data Protection Hacks and Shortcuts
- Formatting Shortcuts and Tips
With all the experience of over 12 years, I’m bringing this course to help all of you get effective and efficient at excel. All the hacks that I’ve learned throughout the years.
My name is Kadhiravan Jayachandran, fondly called “KD”, founder of YourExcelGuy, a platform dedicated to train people on excel. I have trained over 7000 students online and well over 12000 students offline. Majority of my students come from Northern America, South East Asia and Africa.
I’m only doing this because I have so much to give back to Excel Community, if not for them my career would be a lot different.
Who this course is for:
- Beginner in Excel, Specialists of Excel looking to become an Advanced and Efficient User
Show less
Course content
6 sections • 46 lectures • 1h 50m total lengthCollapse all sections
Introduction2 lectures • 2min
- Introduction to the Course00:27
- Important notice about the Practice Files01:30
Worksheet Hacks & Shortcuts9 lectures • 22min
- Section Introduction and Practice Files00:26
- How to Create a Hyperlink to Other Worksheets04:37
- Copying and Moving Worksheets in Various Ways03:17
- Entering Data to Multiple Worksheets at a Time02:49
- Preventing a sheet from Unhiding – Very Hidden Property02:56
- Hiding Scrollbars in a Worksheet02:26
- Creating and Managing Custom Views02:15
- Changing the Default number of Worksheets01:11
- Hiding and Unhiding Sheets02:05
Basics of Shortcuts4 lectures • 12min
- Understanding the Types of Shortcuts03:35
- How to identify a shortcut for a feature01:44
- Moving between Ribbons – Inwards and Outwards02:40
- Shortcuts within Features – Inwards and Outwards03:40
Data Protection Shortcuts and Hacks5 lectures • 12min
- Section Introduction and Practice File00:26
- Protecting a Sheet, yet allowing only a few actions to happen03:25
- Enabling a part of the Sheet to be editable02:42
- How to Create Backup of your file automatically02:44
- Excel Password Encryption to Open and Modify02:43
- Data Protection Quiz3 questions
Navigation Shortcuts & Hacks4 lectures • 7min
- Section Introduction & Practice File Download00:17
- Navigating within a Sheet – Empty Sheet02:13
- Navigating within a Sheet – With data03:14
- Navigating Between Sheets01:06
- Navigation Quiz4 questions
Formatting Hacks and Shortcuts22 lectures • 56min
- Section Introduction and Practice Files00:52
- How Excel Stores Info03:34
- Changing Default Values03:16
- Shrink Cell Tools to Have the Size of the Cells02:01
- How to Add Text to a Number02:31
- Solving the Problem with Leading Zero01:59
- Blocking a User from Interacting Outside a Specific Range01:57
- Understanding the Custom Format Options04:59
- How to Hide & Unhide the Status Bar02:03
- Calculating Values without Formulas03:02
- Highlight Cells that contain Formulas03:49
- Coloring Alternate Rows or Columns03:29
- Formatting Numbers – Rapid Fire Shortcuts02:19
- Duplicate Records and How to Get Rid of These03:08
- Creating Bulleted List01:42
- Format Painter Tips03:00
- How to Insert a Watermark01:53
- Formatting Dates – Custom Date formats06:11
- Filling a cell with Color – Shortcut01:01
- Increasing the Font Size and Decreasing it using Shortcut00:38
- Hiding and Unhiding Rows and Columns02:13
