true

Learn Microsoft Excel Training from the Best Tutors

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

Search in

Excel Macros Training

Next Level Technologies

28/11/2016 0 0

The Next Level Technologies

Excel Learning...Read & Share....Happy Learnings

Record Macro (Automating day to day activity reports)

-> Choose Record Macro in the Code group of the Developer tab or View tab. ...

-> Type a name for the macro in the Macro Name text box. ...

(Optional) Assign a Shortcut Key. .

-> Now record the activity of the report

-> Once you have done with the recording Stop the Record where you have selected the start option

-> Test the record macro by giving shortcut key before you assigned

0 Like 0 Dislike

Follow 0

Other Lessons for You

Excel Tip 1: VLOOKUP to pull left column values

Hi,Most of us know that using Vlookup function we can get the right column values, however by using Choose function in Vlookup table array, we can pull left column values as well. In the below screenshot...

Karthik Dale

0 0

Shortcut for adding big data or Columns in MS excel

1. Simply click on the next cell of column where you want the sum. 2. Press Alt and = keys together. 3. It will show the sum and range of sum. 4 Click Enter key and you will get sum of the column.

Kimsi J.

0 0

Create A Time Sheet In Ms Excel

The following tutorial is about creating a Time-Sheet using MS Excel. Steps: Arranging data, Formulas to analyze data points.

Pranav T.

0 0

Hidden Gems of MS Excel - Data Validation - Circle Invalid Data

Q) You apply Data Validation to a range of Cells. e.g. You apply Data Validation Drop-down List of 5 Indian Cities: Indore, Lucknow, Mumbai, New Delhi, Pune, to a range of Cells What if invalid data...

Ankur Sharma

3 1

Today am teaching a excel formula like SUM, in this I'll take a name and no of student and you can see total i'll use here a advanced excel

NAME STUDENT SAURABH 1 ANJALI 2 MAHESH 1 SANJAY 2 SURABHI 1 NEELAM 2 TOTAL 9

Saurabh Sharma

0 0

Find Microsoft Excel Training classes near you

Looking for Microsoft Excel Training classes?

Learn from Best Tutors on UrbanPro.

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you

Microsoft Excel Training Questions

How to develop skill on Excel Macros VBA. I want to be perfect on VBA. As soon as I see the problem.....

60 Answers

Hi I want to use conditional formatting for 4 cell and where they have - value too. So, I want anything...

11 Answers

How do I delete a worksheet in MS Excel?

14 Answers

Can you make a Software Base On Excel, that records Automatic Billing Information Just Like A POS System. ...

9 Answers

can i teach

35 Answers

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

I am a Student I am a Tutor
Name*	Please enter your full name. Please enter institute name.
Email*	Please enter your email address.
Phone*	Please enter a valid phone number.
Location*	Please enter a pincode or area name.
City*	Please enter city name.
Category*	Please enter category.
Gender*	Male Female Please select your gender.
Email ID/ Mobile No.*	Please enter either mobile no. or email.
Enter Password*	Please enter OTP Please enter Password Sorry, this phone number is not verified, Please login with your email Id.