• Post category:StudyBullet-6
  • Reading time:5 mins read


Become a Excel pro at work, with over 50+ Hacks and Tricks along with the Practice files.

What you will 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

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.


Get Instant Notification of New Courses on our Telegram channel.


In this Course you’ll learn a lot of Hacks and tips to become efficient in the below areas.

  • Pivot Tables
  • Formulas
  • Features like Conditionalย Formatting
  • Advanced Filter
  • Data Validation
  • Text To Columns
  • Navigation between Sheets and Files
  • Customizing the view of Ribbons and Making it efficient
  • Managing Rows, Columns and Sheets

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 Jayachandiran, fondly called “KD”, founder and CEO 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.

English
language

Content

Introduction

Introduction to the Course
Important notice about the Practice Files

Basics of Shortcuts

Understanding the Types of Shortcuts
How to identify a shortcut for a feature
Moving between Ribbons – Inwards and Outwards
Shortcuts within Features – Inwards and Outwards

Navigation Shortcuts & Hacks

Section Introduction & Practice File Download
Navigating within a Sheet – Empty Sheet
Navigating within a Sheet – With data
Navigating Between Sheets
Navigation Quiz

Data Protection Shortcuts and Hacks

Section Introduction and Practice File
Enabling a part of the Sheet to be editable
Protecting a Sheet, yet allowing only a few actions to happen
How to Create Backup of your file automatically
Excel Password Encryption to Open and Modify