How can we differ excel and advanced excel?

Asked by Last Modified  

2 Answers

Follow 1
Answer

Please enter your answer

Advanced Excel & PowerPoint Trainer

Hi kaberi, Technically there is no such thing called Basic Excel ,Intermediate Excel or advance Excel. Microsoft has designed a application called MS Excel Only. The terms are coined one.Basic Excel:If you are working with FUnctions, Formulae, Conditional Formatting, Pivot Table, Charts & Graphs.Advance...
read more
Hi kaberi, Technically there is no such thing called Basic Excel ,Intermediate Excel or advance Excel. Microsoft has designed a application called MS Excel Only. The terms are coined one.Basic Excel:If you are working with FUnctions, Formulae, Conditional Formatting, Pivot Table, Charts & Graphs.Advance Excel:Power Query, Power Pivot, Excel VBA and Macro Automation read less
Comments

Whatsapp me to contact www.mathdecode.com

Advanced Excel is quite different from Basic Excel, the focus for the user is more on DSUM, DCOUNT, Pivot Table, Pivot Chart, Formulas, Functions, and Macros.
Comments

Related Questions

Hi I want to use conditional formatting for 4 cell and where they have - value too. So, I want anything in the range which are in - in a colour and positive in one single colour. How can that happen so can anyone please help me on it?
1. First you have to select the range of cells where you want to apply conditional formatting 2. You have to select conditional formatting from Home tab in Excel window 3. There will be many categories,...
Charan
How do I type new line inside a single cell? I don't want to go to another cell but there should be a new line inside 1 cell. Please help.
You can type Alt+Enter, in case you wanted word wrap, then goto the Home Tab, Alignment group and select Word Wrap otion
Arjun
Hi All, My question is how to define age calculation in excel by formula?
Enter DOB in one cell. For example in Cell A1. Then in the cell where you want to calculate Age there write as =(TODAY()-A1)/365.25 .25 has been added to the 365 because to accommodate the leap year days in between.
BINAYAK

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons


Two Important Tools to Convert Your Dream Into Goal
How to convert your dream into Goal If we want to convert the dream into Goal, two important tools are given below. SMART & 5D S: Specific M: Measurable A: Achievable R: Realistic T: Time-bound...

Create a Grading in Excel using Formulas (All versions)
Topic: Applying Grading /Ranking in Excel (All versions Let’s Say you need to rate the Sales with some grade text like POOR, AVERAGE, GOOD and EXCELLENT Based on a range of values as mentioned...

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...

Exploring Excel HLOOKUP Formula
Let's break down HLOOKUP in detail. What is HLOOKUP? HLOOKUP (Horizontal Lookup) is an Excel function that searches for a specific value in the first row of a table and returns a value...
G

Ganesh S.

0 0
0

Recommended Articles

Microsoft Office is a very popular tool amongst students and C-Suite. Today, approximately 1.2 billion people across 140 countries use the office programme. It is used at home, schools and offices on a daily basis for organizing, handling and presenting data and information. Microsoft Office Suite offers programs that can...

Read full article >

Almost all of us, inside the pocket, bag or on the table have a mobile phone, out of which 90% of us have a smartphone. The technology is advancing rapidly. When it comes to mobile phones, people today want much more than just making phone calls and playing games on the go. People now want instant access to all their business...

Read full article >

Business Process outsourcing (BPO) services can be considered as a kind of outsourcing which involves subletting of specific functions associated with any business to a third party service provider. BPO is usually administered as a cost-saving procedure for functions which an organization needs but does not rely upon to...

Read full article >

Applications engineering is a hot trend in the current IT market.  An applications engineer is responsible for designing and application of technology products relating to various aspects of computing. To accomplish this, he/she has to work collaboratively with the company’s manufacturing, marketing, sales, and customer...

Read full article >

Looking for Microsoft Excel Training classes?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you