Learn Excel Visually
The ‘Learn Excel Visually’ Journey Excel is relevant for all aspects of a business and it’s not hard to learn, but even apparently smart people can have trouble mastering Excel. Why is this? Well - Excel provides the tools,but doesn’t tell you how to use them. You can read about the functionality of Excel and try and figure out what to use, but how do you know what to apply and when? The Learn Excel Visually (LEV) journey is here to take you through the essentials of the Excel process; set up your spreadsheet, capture and structure data efficiently, cleanse it, analyse it meaningfully and present it with visual oomph.
Quick glossary
Most of you will already understand the basic elements of
Excel but I want to use this section to clarify some key Excel terminology to
ensure we are on the same page.
Menu = The list of items along the top of the screen; for example, file, insert, page layout etc.…
Ribbon = Ribbon is like an expanded
menu. It depicts all the features of Excel in an easy-to-understand pictorial
form. Since Excel has 1000s of features, they are grouped into several
ribbons. For example, the ‘insert’ ribbon has functions grouped into, clipboard, font, alignment, number, styles etc.…
Name box = Just
underneath the Ribbon you have a white box on the left-hand side – it shows the
cell reference (default A1) or if you have specified a name for a cell or range
of cells, it will show that name.
Formula bar =
Next to the Name box, also underneath the Ribbon. The formula bar shows you the
contents of a selected cell, particularly useful if you want to see a
calculation within a cell and not just the output of the calculation.
Spreadsheet = A
method of spreading information across a sheet of paper - the screen represents
a piece of paper with grid lines.
Workbook = the
file you create in Excel.
Worksheet = A
page within the Workbook. By default, an Excel Workbook contains 3 worksheets;
they are the viewed using tabs along the bottom.
Cells = The grid
lines make rectangular boxes - known as cells. Referred to as a letter and a
number.
Columns = Cells down a spreadsheet are columns - letters.
Rows = Cells across the spreadsheet
are rows - numbers.
Hide
& Unhide ➪ Hide Columns from the drop-down menu (or you
can just press Alt+HOUC)
No comments:
Post a Comment