MS Office Software Training

MS Office Software Training

Trending Questions and Lessons

Follow 15,303 Followers

Ask a Question

Feed

All

All

Lessons

Discussion

Answered on 07 Jun IT Courses/MS Office Software Training/Microsoft Excel Training/Basic Excel

I need to know the fee details?

MADAN MOHAN P.

Tutor

Fee are based on student class standred and subjects.
Answers 1 Comments
Dislike Bookmark

Lesson Posted on 17 May IT Courses/MS Office Software Training/Microsoft Excel Training IT Courses/MS Office Software Training

Advanced Excel Training Course - SLA Consultants India

Sla Consultants India

SLA Consultants India, has been steadily rising as a corporate training & development leader to take...

Introduction to Advanced Excel Training Course, Basic Understanding Menu and Toolbar, Introduction to a different category of functions like Basics, Mathematical and Statistical, Date and Time, Logical, Lookup and References, Text and Information. Mathematical Functions:- Sum, Sumif, Sumifs, Count,... read more

Introduction to Advanced Excel Training Course, Basic Understanding Menu and Toolbar, Introduction to a different category of functions like Basics, Mathematical and Statistical, Date and Time, Logical, Lookup and References, Text and Information.

Mathematical Functions:- Sum, Sumif, Sumifs, Count, Counta, Countblank, Countif, Countifs, Average, Averagea, Averageif, Averageifs, Subtotal, Aggregate, Rand, Randbetween, Roundup, Rounddown, Round, Sumproduct

Date & Time Function:- Date, Day, Month, Year, Edate, Eomonth, Networkdays, Workday, Weeknum, Weekday, Hour, Minute, Second, Now, Today, Time

Text Functions & Data Validation:- Char, Clean, Code, Concatenate, Find, Search, Substitute, Replace, Len, Right, Left, Mid, Lower, Upper, Proper, Text, Trim, Value, Large, Small Filters (Basic, Advanced, Conditional), Sort (Ascending, Descending, Cell/ Font Color), Conditional Formatting, Data Validation, Group & Ungroup, Data split.

Statistical Function & Other Functions:- Isna, Isblank, Iserr, Iseven, Isodd, Islogical, Isytext, Max, Min, Len, Right, Left, Mid, Maxa, Maxifs, Median, Minifs, Mina, Vara, Correl, Geomen

Logical Functions:- And, Or, If, Iferror, Not, Nested If

Lookup & Reference Functions:- VLookup, HLookup, Index, Match, Offset, Indirect, Address, Column, Columns, Row, Rows, Choose, Arrays Concept In Lookup Formula’s, Past Special, Past link

read less
Comments
Dislike Bookmark

Lesson Posted on 26 Apr IT Courses/MS Office Software Training/MS Word

Using Table of Contents - MS Word

Vishal G.

10 Years. Training experience in PHP, Adv. PHP, VB, Core Java, HTML, Web Site Design etc.. 10 and 12...

How to use Table of Contents in MS-Word About Table of Contents: It is most common and useful feature in ms-word. By using this option, we can create a table of contents(TOC) for a long document. We can easily navigate on pages by clicking specific headings provides in TOC. Step 1: Write your long... read more

How to use Table of Contents in MS-Word

About Table of Contents: It is most common and useful feature in ms-word. By using this option, we can create a table of contents(TOC) for a long document. We can easily navigate on pages by clicking specific headings provides in TOC.

Step 1: Write your long documents with heading and subheadings.

Step 2: Modify Heading 1 and Heading two as per your requirement like colour, font size etc.

Choose Heading 1 and Heading 2 Options one by one from Home-Styles and apply on your headings

Step 3: Click on Reference menu and then click on the table of contents option and then select built-in heading styles

Step 4: Now, you can see your document is ready as a table of content on the first page, by this you can navigate page to page or headings.

 

 

read less
Comments
Dislike Bookmark

Looking for MS Office Software Training

Find best MS Office Software Training in your locality on UrbanPro.

FIND NOW

Lesson Posted on 07 Apr IT Courses/MS Office Software Training/Microsoft Excel Training/Excel VBA & Macro Training IT Courses/MS Office Software Training/Microsoft Excel Training/Advanced Excel

Why Option Explicit is Required in the VBA Editor

Kumar S

I have 5 Years of experience in MNC's and I worked on real time projects in VBA, Python, MSBI and SQL.

Hi Folks,Do you know Excel VBA Editor has functionality where you don't need to declare a variable in memory (DIM).But what will happen if you write a program without declaring a variable nothing happens?Then why do we need to declare a variable and what is Option Explicit? Yes here comes the answer.When... read more

Hi Folks,

Do you know Excel VBA Editor has functionality where you don't need to declare a variable in memory (DIM).
But what will happen if you write a program without declaring a variable nothing happens?
Then why do we need to declare a variable and what is Option Explicit? Yes here comes the answer.
When you write option explicit at the top of your VBA Editor VBA will force you to declare a variable it's a standard practice to declare a variable.
One more point when you are not declaring a variable in VBA by default VBA Program considers that as a variant data type which consumes more space, Also it increases programs running time.
So next time when you write a program don't forget to declare a variable.
Happy learning!!

read less
Comments
Dislike Bookmark

Asked on 29 Mar IT Courses/MS Office Software Training/Microsoft Excel Training/Excel VBA & Macro Training Exam Coaching/Foreign Education Exam Coaching/Advanced Placement Tests Coaching/Computer Science

How do I transfer AutoCorrect from one computer to another computer?

Answer

Lesson Posted on 28 Mar IT Courses/MS Office Software Training/Microsoft Excel Training/Advanced Excel

Advance Excel Training

Kartik

This is reminder and follow database, ensure to priorities you work distribution
Comments
Dislike Bookmark

Looking for MS Office Software Training

Find best MS Office Software Training in your locality on UrbanPro.

FIND NOW

Lesson Posted on 27 Feb IT Courses/MS Office Software Training/Microsoft Excel Training

Create A Time Sheet In Ms Excel

Pranav

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

Answered on 15 Apr IT Courses/MS Office Software Training/Microsoft Excel Training/Advanced Excel

Trisha Jagtiani

MS Excel Tutor

You need about 8-10 days to finish the Basic and Advance excel course. Depends on how you pick up, the days can increase or decrease...
Answers 10 Comments
Dislike Bookmark

Answered on 01 Jun IT Courses/MS Office Software Training/Microsoft Excel Training/Advanced Excel

How to grade the students when the criteria is given?

Nagamani L

Yoga Teacher

Hi Anurag, I hope you have the criteria like below shown Comum A, B, C and now add the following formula in co, umn C to get the grade according to the percentage. Please revert if you have any questions. =IF(B2<=45,"D",IF(B2<=60,"C",IF(B2<=80,"B",IF(B2<=100,"A")))) Column A Column B Column... read more

Hi Anurag, I hope you have the criteria like below shown Comum A, B, C and now add the following formula in co, umn C to get the grade according to the percentage. Please revert if you have any questions. =IF(B2<=45,"D",IF(B2<=60,"C",IF(B2<=80,"B",IF(B2<=100,"A")))) Column A Column B Column C Student Names Percentage Grade Ram 60 C Suman 80 B Leela 95 A Joe 70 B
Regards,
Nagamani

read less
Answers 2 Comments
Dislike Bookmark

Looking for MS Office Software Training

Find best MS Office Software Training in your locality on UrbanPro.

FIND NOW

Answered on 22 Mar IT Courses/MS Office Software Training/Microsoft Excel Training

Ramesh KN

Corporate Trainer

You can type Alt+Enter, in case you wanted word wrap, then goto the Home Tab, Alignment group and select Word Wrap otion
Answers 34 Comments
Dislike Bookmark

About UrbanPro

UrbanPro.com helps you to connect with the best MS Office Software Training in India. Post Your Requirement today and get connected.

Overview

Questions 136

Lessons 155

Total Shares  

Related Topics

Top Contributors

Connect with Expert Tutors & Institutes for MS Office Software Training

x

Ask a Question

Please enter your Question

Please select a Tag

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 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 6.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