Top 10 Microsoft Excel help tips
Microsoft Excel has been the most widely used enterprise
software for 30 years. Although it is widely used, Excel's full functionality
is still not well understood. Of the 100,000 workers we have tested in the past
three years, less than half know which conditional formatting - the main
feature - really works.
What's the most important thing about Excel? We examine
articles by Excel experts and combine them with aggregate data from thousands
of our users to make a list of the 100 most useful Excel functions and
features, including pivot tables, absolute references, conditional formatting,
and more.
If you need advice in quick doses to increase your Excel
knowledge, read the 10 tips below. However, download and do 100 full to get the
most out of this great guide. Visit the Accountech website for more information
So let's get started!
1. Conditional formatting
Graphical conditional formatting in Excel
Realizing our data-rich and noisy world is difficult, but
important. When used properly, conditional formatting will display the pattern
of the universe captured from your desk. For this reason, Excel experts and
Excel users vote on this most important function. This can be complicated. But
even the simplest color changes can be very useful. Suppose you have a number
of sales that sell every month. Only three clicks can reach the top 10% of
sellers and make important business calls.
2. PivotTables
Mastering PivotTables in Excel
After 4 hours of learning skills, you might be late learning
PivotTables, but it's not. Use them to sort, calculate, aggregate, or average
data stored in large tables and display them in new tables. That is the key
here. If you only want to display sales data for specific countries, product
lines, or marketing channels, this is trivial. Warning: Make sure your data is
clean first!
3. special pasta
How and Why You Use Special Paste in Excel Getting (ie
copying) some data from one cell and placing it in another cell is one of the
most common activities in Excel. However, there are many things you can copy
(format, values, formulas, comments, etc.), and sometimes you won't copy them
all. The most common example of this is when you want to lose formatting. The
place where this data is stored is your own table in your own style. Formatting
from other locations is annoying and ugly. Simply copy the value and all you
get is text, numbers, regardless of value. The path after copying cells (Ctrl +
C) is Alt E S V - easier than it sounds. The other big one is transpose. It
reverses rows and columns in seconds. Alt E S E link
4. Add a few lines
Add a few lines to Microsoft Excel
Probably one of the most common spreadsheet activities. Ctrl
+ Shift + is a shortcut that takes longer than right-clicking the row number on
the left in Excel view. The right button is our recommendation. If you want to
add more, select as many rows or columns as you want to add. Then right-click
and add.
5. Absolute reference
Use of fixed references in Excel
Irreplaceable! The dollar in front of the letter fix column,
the dollar sign in front of the number fixing line, F4 runs four possible
combinations. Try the following exercise. Divide three foods horizontally into
cells B1, C1, D1 (olives, muesli, tomatoes) and three colors into cells A2, B2,
C2 (green, blue, yellow). Now enter cells B2 '= A2 & "" &
B1'. Congratulations: green olives! Now - and this is the exercise - add a
dollar sign so that when you copy the formula to everything you get green. Or
just muesli, but in a different color. Experiment!
6. Print optimization
How to optimize printing in Microsoft Excel |
Everyone has problems printing from Excel. But imagine that
what you print is always exactly the way you want it to. It may be. However,
there are several components: print preview, one-sided adjustment, frame
adjustment, print selection, print headers, landscape design and spreadsheets.
Invest time to feel comfortable with it. You will complete this task many times
during your work life.
7. Open the formula from inside / below
Use Excel's crosshairs to extend the formula. The beauty of
Excel is its easy scalability. If you correct a formula once, Excel stops the
correct calculation millions of times. Comfortable crosshair. Double-click
ending when you have continuous data. Sometimes copying and pasting (either
pasting or pasting a formula) is faster for you.
8. Fill Flash
Benefits of using Flash Content in Excel Excel has further
developed your mind in 2013. Suppose you have two columns of names and need to
create email addresses from all of them. Just do it for the first row and Excel
will understand what you mean and do it for the rest. This was possible before
2013, but was based on a combination of functions (FIND, LEFT, etc.). Much
faster now and people will see it. If Flash Fill is enabled (advanced file
options), it only needs to work when you type. Or do it manually by clicking
Data> Flash Fill or Ctrl E.
9. GAME INDEX
Combine INDEX and MATCH in Excel
This is one of the most powerful combinations of Excel
functions. You can use it to find values in a large data table and return the
corresponding values in that table. Assume that your company has 10,000
employees and a table with all employees, which contains a lot of information
such as salary, start date, manager, etc. But you have a team of 20 and you are
only really interested in them. INDEX-MATCH looks for the value of your team
members in this table (they must be unique as email or employee numbers) and
returns the information requested for your team. It's worth avoiding this
because it's more flexible and therefore stronger than VLOOKUP.
10. Filter
Using Filters in Excel
Quick lookup of data in a table. Filtering effectively hides
data without interest. Usually there is one value (e.g. a blue car) that you
are looking for and the filter will show and hide the rest. In the more modern
versions of Excel, you can now look up numerical values (e.g. greater than
10% etc.) and filter cell colors. Filtering is more efficient if you need to
filter more than one column in a combination, e.g. The colors and vehicles to
find your blue car. Alt D F F is a shortcut (easier than it sounds - just try
it). Conditional formatting and sorting are used for related purposes. When
sorting, you need to reset your table. This is annoying and may not be
desirable. Conditional formatting brings a preview. Fast and efficient
filtering. Choose well.
How much do you know?
100 of the most useful tips in Excel
Get more and learn more with our online Excel training in Karachi. From the complete list, Excel experts must know 80+, 60+
experienced users, an average of 40+ users, and if you know less than 40, we
will qualify you as a beginner.
Scan a list of tricks that:
You agree that it will benefit you
you still don't know yet
Ideally, don't take a lot of time to study
If you find a handful who meet these criteria, find this useful article learn and
become a stronger person!
Comments
Post a Comment