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.
Description : Download free ebook Excel Fundamentals, PDF course and tutorials on 60 pages by St. George’s Information Services.
Level : Beginners
Created : March 30, 2020
Size : 7.03 MB
File type : pdf
Pages : 60
Author : St. George’s Information Services
Downloads : 59673

Related Excel Fundamentals PDF eBooks

jQuery Fundamentals

The jQuery Fundamentals is a beginner level PDF e-book tutorial or course with 108 pages. It was added on October 18, 2017 and has been downloaded 2816 times. The file size is 563.78 KB. It was created by Rebecca Murphey.


Procreate: The Fundamentals

The Procreate: The Fundamentals is a beginner level PDF e-book tutorial or course with 38 pages. It was added on April 4, 2023 and has been downloaded 253 times. The file size is 2.45 MB. It was created by Procreate.


Networking Fundamentals

The Networking Fundamentals is a beginner level PDF e-book tutorial or course with 56 pages. It was added on December 31, 2012 and has been downloaded 12379 times. The file size is 1.44 MB. It was created by BICSI.


Linux Fundamentals

The Linux Fundamentals is a beginner level PDF e-book tutorial or course with 365 pages. It was added on October 17, 2018 and has been downloaded 27969 times. The file size is 2.68 MB. It was created by Paul Cobbaut.


Computer Fundamentals

The Computer Fundamentals is a beginner level PDF e-book tutorial or course with 86 pages. It was added on August 17, 2017 and has been downloaded 13628 times. The file size is 772.52 KB. It was created by Dr Steven Hand.


Fundamentals of Cryptology

The Fundamentals of Cryptology is an intermediate level PDF e-book tutorial or course with 503 pages. It was added on December 9, 2021 and has been downloaded 1853 times. The file size is 2.35 MB. It was created by Henk C.A. Tilborg.


Fundamentals of Python Programming

The Fundamentals of Python Programming is an intermediate level PDF e-book tutorial or course with 669 pages. It was added on January 6, 2019 and has been downloaded 22290 times. The file size is 3.3 MB. It was created by Richard L. Halterman.


Fundamentals of Linear Algebra

The Fundamentals of Linear Algebra is an intermediate level PDF e-book tutorial or course with 412 pages. It was added on March 30, 2016 and has been downloaded 1294 times. The file size is 1.93 MB. It was created by James B. Carrell.