Linking worksheets in Excel

Linking sheet in Microsoft Excel is very essential when we work on multiple worksheets in the same workbook or different workbooks. It keeps worksheets at a manageable size, enhanced effective reports and add values to projects in Excel. Linking spreadsheet operation is very handy when carried out calculations on sheets with lots of information, particularly[…]

Shares 0

Duplicate worksheet in Excel

Duplicating Worksheet Worksheet can be duplicate in an excel file. This is very common when you intend to mirror the entire sheet in other to carry out further operation on its copied without affect the primary sheet. To duplicate a worksheet. Select the worksheet Right click on the sheet tab and choose Move or Copy[…]

Shares 0

Renaming Sheet and Color Sheet Tab in Excel

Renaming Worksheets in Excel Worksheets can be renamed from it default name (sheet1, sheet2, …) that appears on the sheet tab at the bottom of the screen to distinguish our work. The following are steps to accomplished that: Right click on the sheet tab you want to rename and select the rename from pop up[…]

Shares 0

Insert and Delete Worksheet in Microsoft Excel

Insert New Worksheet into Excel Microsoft Excel allows insertion of additional worksheets into a workbook. Excel 2013 has one worksheet by default unlike previous versions that provided with three worksheets. To insert worksheet next to an existing one. Select the worksheet, click on the new sheet icon. See the screenshot below Deleting Worksheet from Excel[…]

Shares 0

Formatting for Print and Email in Excel

The following steps must be follow in order to format for printing and Email in excel. Select the Page Layout Menu Highlight the cells range or table you intend to print and set PRINT AREA to tell excel which cells range or part of the sheet to be printed Click on the arrow underneath Print[…]

Shares 0

Formatting Data as Table in Excel

Formatting data as a table make it easier to work with and visual appealing. Below is a data set we want to format as a table. Highlight the entire cells Select the INSERT MENU Click on Table or Using the shortcut CTRL+T convert the range to table The selected range will show on the dialog[…]

Shares 0

Basic Data Types and Data Consistency in Excel

  The classification of data to various types base on it predefined characteristics and how it value should be stored is refers to as data type. In this case Microsoft excel recognizes four (4) different data types which include Number, Text, Boolean, and Formula. Therefore each cell can contains any of the above mention data[…]

Shares 0

Introduction to Microsoft Excel: Review and View Menu

Review and View Menu will complete the introductory section of Menu bar in Excel. Review Menu: This is very handy while carrying out commenting, enabling access restriction and spell checking. Proofing: This facilitate spell check and further research to either find the meaning (or synonyms) of a word. Language: Allows you to translate the selected[…]

Shares 0