UrbanPro
true

Learn Microsoft Excel Training from the Best Tutors

  • Affordable fees
  • 1-1 or Group class
  • Flexible Timings
  • Verified Tutors

Search in

EXCEL - Not just for the professionals but to make your daily life easy

Kunal Kansra
31/10/2019 0 0

 

Microsoft Excel 

 

This course will focus on real-life applications of MS Excel and help you start from scratch to help build your macros to make your life easier. Apart from technical bits, we will work together to help unravel the analytical self in you by continually questioning the method proposed by me and trying to figure out easier and more efficient ways to solve the problems. Throughout the course, we will pick examples close to our environment so that the problems are more relatable and directly applicable (as opposed to the trigonometric problems that I barely have used since 12th grade). During the course of the course, we will be able to not only solve well-defined problems but also try and work together to define the problems and then work towards finding a probable solution. Now that I have detailed out the plan (well, too much detailing I must say with utmost guilt), we will begin with the first lesson towards making sure we have MS Excel at our disposal (rather than the other way round).

Excel Basics - The two guiding Pillars

Imagine Excel sheets as a blackboard/whiteboard but only more organized (someone did not want you to get lost out there!). In order to navigate this blackboard, we have our two guiding pillars - the rows (Pillar 1) and the columns (Pillar 2). Rows are represented by the numbers along the side of this board while the columns are represented by letter across the top of this board. While these are our guiding pillars, they also divide the sheet into small houses called 'Cells'. Each of the combinations of these numbers and letters help us locate one of the houses on the board called cells. Let's say I am told to go to Satya's house, without his house number I am not sure if I will ever be able to locate the right Satya (unless I am that Swiggy delivery guy who just knows it all). Just like I need a house number (say 123, block 4) to locate Satya, I need both the Rows' number and Columns' letter to be able to locate that tiny little house on my excel sheet.

Example: Locate Sandy's house at B5 on the Excel sheet

How do I do it?: I start with the top of the board and locate the letter B. I then move down, down and down till I hit the 5th small house in that column. Here I am at Sandy's

How else could I have done it?: I would have alternatively started with going down till the number 5 is highlighted. I then would have moved right till I reach the 2nd house in that row. Even this brings me to Sandy's (certainly all roads lead to Rome)

How else could this still have been done?: This, I leave upon to you and help me figure out how we could have done this and still be at Sandy's.

0 Dislike
Follow 2

Please Enter a comment

Submit

Other Lessons for You

Practical use of Two way Look-up (Category: Advanced Excel)
///////////////////////////////////////////////////////////////

Excel Tip: VLOOKUP formula limitations
1. Vlookup is not case-sensitive 2. If Lookup value has duplicates in the lookup column, then it returns 1st found value 3. Vlookup cannot pull values which are on the left side from Lookup column 4....

Macro Recording
G

Gagan G.

0 0
0

VBA Tip: Repeating Emp Names N number of times using 4 different loops
Hi All,This is a requirement from one of our student and here we are posting the question along with solution (this can be achieved using 4 different loops). In Column “J” there are few employee...

MS Excel: Formulas and Functions: Listed by Category
MS Excel: Formulas and Functions: Listed by Category Worksheet formulas are built-in functions that are entered as part of a formula in a cell. These are the most basic functions used when learning Excel....
X

Looking for Microsoft Excel Training Classes?

The best tutors for Microsoft Excel Training Classes are on UrbanPro

  • Select the best Tutor
  • Book & Attend a Free Demo
  • Pay and start Learning

Learn Microsoft Excel Training with the Best Tutors

The best Tutors for Microsoft Excel Training Classes are on UrbanPro

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more