Excel Fundamentals Tutorial for Beginners in PDF

Contents

• Understanding Workbooks
• Navigating in a File Typing Text or Numbers Into
• A Worksheet Typing Simple Formulas In A Worksheet
• Filling A Series, Inserting And Deleting Worksheets
• Copying A Worksheet Renaming A Worksheet
• Moving or Copying A Sheet To Another Workbook Changing Worksheet Tab Colours
• Grouping Worksheets, Freezing Rows, And Columns
• Selecting Ranges, Selecting Rows, Selecting Columns
• Understanding Formatting, Applying General Formatting
• Changing Fonts, Changing Font Size Understanding Borders

Learning the Excel Fundamentals

• There are 16,384 alphabetically labeled columns on a worksheet (or page) in a workbook. Even though this limit can never be reached, a worksheet cell can hold up to 32,767 characters. Column and row labels are used to identify cells. Knowing what to do before using Excel is helpful.
• Make the cell you want to type into active before you can type anything into a worksheet. 
  Excel's entire purpose is to make calculations for you. You must type formulas into the worksheet for it to do this. Microsoft Excel formulas can be entered by selecting the desired cell with the cell pointer and typing the formula starting with =. The worksheet will display the calculation's outcome, and the Formula Bar will display the formula. This is a different kind of formula called a "function," which is a list of sequentially ordered entries. Days and months are available as unique built-in series in Microsoft Excel. These can be generated in a worksheet using the fill method.
• After choosing a layout for your workbook, you might discover that some worksheets can be removed. The worksheet will be immediately deleted because it is empty of any data. Right-click on Insert and select Insert to bring up the Insert dialog box and insert a new worksheet between two already-existing worksheets. 
• By selecting the worksheet tab name and typing in a new, more appropriate name, you can rename a worksheet. In order to accommodate worksheet names that are longer and more meaningful, you can also adjust the horizontal scroll bar. Then click "Create a copy" of the copied worksheet in the Move or Copy dialog box. This will send the data to the other workbook and create a new workbook.
• You can alter the color of a worksheet tab in Microsoft Excel. While inactive tabs display a solid color background, the active sheet is underlined in a gradient version of the chosen color. You can quickly distinguish between various fiscal years, departments, or months thanks to this.
• With this exercise, Excel can assist you in better identifying the tabs on different worksheets. You can instantly make the same change to all of the selected worksheets by using worksheet grouping. For instance, grouping the worksheets will allow you to make changes to one worksheet and have those changes automatically appear in all the others. The majority of text and formatting changes made to one worksheet in a group will be applied to all of the worksheets in that group. columns and rows that contain the headings.
• To put worksheet panes in the freezer, click in the cell to the right and below the desired location to freeze or unfreeze the area. Select the cell in row 1 if you want to only freeze the columns and leave the rows unfrozen. Any collection of chosen cells that shapes a square or rectangle is referred to as a contiguous range. The mouse and the keyboard, or a combination of the two, can be used to select ranges.
• You can alter the appearance of a number in Microsoft Excel so that the reader of your worksheet understands it right away. On a worksheet, for example, you could show sales tax as 10% rather than 10%. As you type, formatting can also be applied; for instance, if you type 30/9/2020, Excel will format it as a date and display it exactly as you typed it.
• Font in Excel simply refers to the typeface or letter shape. Times New Roman, Arial, Century Gothic, and Copperplate are examples of common fonts. Click the drop arrow next to the Font group on the Home tab to apply font formatting. A worksheet's primary headings typically have a slightly larger font size than the rest of the data. For instance, you might want to make the headings 13 pt. or larger if your normal text is 11 pt.
• For minute details like comments or a caption, the font size can also be changed. Borders are drawn around the perimeter of specific cells or ranges. Borders are used because they can be used to separate data into groups, show totals, or draw attention to important cells that might require special data entry. A worksheet that has borders and none A structure can be applied using borders. utilizing Excel The borders can be used to add a more form-like appearance, show how the cells relate to one another, or demarcate groups.