How to work in Ms Excel

Sometimes, Excel seems too good to be true. All I have to do is enter a formula, and pretty much anything I'd ever need to do manually can be done automatically. Need to merge two sheets with similar data? Excel can do it. Need to do simple math? Excel can do it. Need to combine information in multiple cells? Excel can do it.
If you encounter a situation where you need to manually update your data, you're probably missing out on a formula that can do it for you. Before spending hours and hours counting cells or copying and pasting data, look for a quick fix on Excel -- you'll likely find one.
o start you off, get yourself familiar with formatting your spreadsheet cells. A visually organized spreadsheet is highly appreciated by others as it can help them follow your data and calculations easily. To quickly apply your formatting across hundreds of cells, use the Format Painter:
  1. Select the cell with the formatting you wish to replicate
  2. Go to the Home menu and click on the Format Painter. Excel will display a paintbrush next to the cursor
  3. While that paintbrush is visible, click to apply all of the attributes from that cell to any other.
3.To format a range of cells, double-click the Format Painter during step 1. This will keep the formatting active indefinitely. Use the ESC button to deactivate it when you’re done.
Quick Access Toolbar: This is a place where all the important tools can be placed. When you start Excel for the very first time, it has only 3 icons (Save, Undo, Redo). But you can add any feature of Excel to to Quick Access Toolbar so that you can easily access it from anywhere (hence the name).
2. Ribbon: Ribbon is like an expanded menu. It depicts all the features of Excel in easy to understand form. Since Excel has 1000s of features, they are grouped in to several ribbons. The most important ribbons are – Home, Insert, Formulas, Page Layout & Data.
3. Formula Bar: This is where any calculations or formulas you write will appear. You will understand the relevance of it once you start building formulas.
4. Spreadsheet Grid: This is where all your numbers, data, charts & drawings will go. Each Excel file can contain several sheets. But the spreadsheet grid shows few rows & columns of active spreadsheet. To see more rows or columns you can use the scroll bars to the left or at bottom. If you want to access other sheets, just click on the sheet name (or use the shortcut CTRL+Page Up or CTRL+Page Down).
5. Status bar: This tells us what is going on with Excel at any time. You can tell if Excel is busy calculating a formula, creating a pivot report or recording a macro by just looking at the status bar. The status bar also shows quick summaries of selected cells (count, sum, average, minimum or maximum values). You can change this by right clicking on it and choosing which summaries to show.
Familiarize yourself with the language needed to use Excel. Knowing the terminology of the technology is important for being able to use it easily and understand step-by-step guides.
  • A row is a section that goes right to left across the screen (indicated by numbers along the left side of the screen).
  • A column is a set of data that goes from the top to the bottom of the worksheet, and it is identified with a letter at the top of the sheet.
  • A cell is any individual square of the worksheet that data may be placed in.
  • Excel 2016 is a version of Excel developed by Microsoft that runs on the Windows platform. This Excel 2016 tutorial covered the basic concepts of spreadsheets such as:
    • Cells
    • Rows
    • Columns
    And then expanded on the more advanced Excel topics such as:
    • Sheets
    • Hyperlinks
    • Ranges
    Each version of Excel can "look and feel" completely different from another. As such, we recommend that you try one of our other Excel tutorials to become familiar with the Excel version that you will be using.

    Other Excel Tutorials

    Now that you know the basics of Excel 2016, learn more.
    Try one of our other Excel tuto
  • By default when you create a new workbook in Excel 2007, all cells will be formatted with the Calibri font. You can change the font within any cell to improve the look of your document.
    To change the font in a cell, select the text that you wish to change the font for. This can either be the entire cell or only a character in the cell.

Comments

Post a Comment

Popular posts from this blog

PUBG PC system requirements and recommended

Interestingly, and perhaps typically, PUBG doesn't actually have "recommended" specs like games usually do. Instead, there's just a bare minimum that you should be aiming to exceed across the board. Note that the one thing that is compulsory though is the operating system, which must be 64-bit. System Spec Minimum System Requirements Operating System (OS) 64-bit Windows 7, Windows 8.1, Windows 10 Processor i3-4340 / AMD FX-6300 Memory 6 GB RAM Graphics nVidia GeForce GTX 660 2GB / AMD Radeon HD 7850 2GB DirectX Version 11 Network Broadband Internet connection Storage 30 GB available space As we mentioned above, it's worth remembering that the best graphics settings really do vary case by case. Your system might require you to turn certain more demanding settings down, or it might allow you to crank those more demanding ones up a little higher than average. Likewise, your preferences might dictate that, actually, you prefer a little more foliage ...
Read more

best pubg settings 2019 new

PUBG graphics settings  have become weirdly important over time, as a combination of the game's somewhat shonky performance and, interestingly, the fact that you can gain a pretty clear competitive advantage by making a few tweaks in the menus. Here on this page, then, we'll be explaining both the  best PUBG settings  for a competitive edge, and the best settings for  how to increase FPS in PUBG , too, so whether you're out to tryhard your way to a chicken dinner, or just trying to get the game to run smoothly, you should be sorted. The best PUBG graphics settings for visibility and a competitive edge Much of the conversation about finding the best PUBG graphics settings have revolved around what settings the professional players and top streamers use. Copying your favourite pro is certainly a way to do it - but that misses a large part of the question out. It's important to know why the pros' settings are what they are if you want to get the most out of t...
Read more

Tips to make money by working as a freelancer on Elance.

What is freelancing ? In one sentence – Freelancing means working freely from anywhere on any project on your own terms . Lot of peoples are working as a freelancer to earn their full time livings ,But the most important is where to get the freelance projects , There are huge number of online portals advertising every where , to work online . But In my career as a freelancer , I found 90% of them are not legitimate . They will get their work done & will not pay you , or will pay you very less for your hard work. Hence the solution is why not you work for a Big Brand like – Elance.com & freelancer.com . Because people trust  them , However it is a bit difficult to get project on these websites for beginners. But if you make a try regularly & if you deliver you best on elance , once you get good feedback and rating in your elance profile , then you need not to worry about getting projects. Elance is one of the best freelance website (market place) , to work for a ...
Read more