Date and Time function in Excel This step-by-step article describes how to use date and time functions in Microsoft Excel to perform complex date and time calculations. Excel stores all dates as integers and all times as decimal fractions. To get started Creating a date functions in Excel Step 1 : Create a Workbook Step 2: Type the […]
Protecting Worksheets in Excel 2013 Sometimes you may require to protect your important worksheets from misuse & theft. in this post, you are going to learn how to protect your Worksheet in Excel 2013 from unauthorized access. There are variety of ways in Excel 2013 to protect an Excel sheet. These are the available options: […]
Using Transpose Tool in Excel 2013 In this Post I am gonna show you how you can use transpose Tool to convert rows into columns! Do you Know? In Excel 2013, you can use the same transpose function that appeared in Excel 2010 to rotate tables or change rows & columns. Using Transpose tables you […]
Sharing Workbooks in Excel 2013 Excel 2013 makes it really easy to share workbooks using OneDrive, which we discussed in Earlier Sections. In order to share any workbook in Excel 2013, it must first be saved to your OneDrive (See How to Save onto OneDrive Section). Here’s How to Share a Workbook: Simply click the tab that says, “File” to access the backstage view, and […]
Saving an Workbook in Excel 2013 When you create & work on a new workbook in Excel 2013, you’ll should to know how to steps to save your work & workbook so that you can access it & edit it later. There are many different ways to save a workbook in Excel 2013. In previous versions of Microsoft Excel […]
Worksheet Views in Excel 2013 Excel 2013 has different types of viewing options that allows you to change how your workbook appears. You Can Choose from Options like, Normal view, Page Layout view & Page Break view. These Views are very useful. Here’s How to change the worksheet views: Locate “worksheet view command” in the bottom-right corner of your […]
Creating and Opening Workbooks in Excel 2013 Do you know? Excel files are known as workbooks. Whenever you start or plan to start a new project in Excel 2013, you’ll have to create a new workbook in Excel 2013. If you would like to view or edit any existing workbook, you’ll have to learn how to open […]
Quick Access Toolbar in Excel 2013 Quick Access Toolbar is Located just above the Ribbon. It let you access the most general & common commands. By default, Quick Access Toolbar in Excel 2013 includes Commands like, Save, Undo, and Repeat. Yes of Course you can add other commands to Quick Access Toolbar depending on your preference. Here’s […]
Excel 2013 Interface & Environment Microsoft Excel 2013 is a spreadsheet program from Microsoft Corporation that allows you to store, process, organize, and analyze information & Data. Generally, People Think Microsoft Excel 2013 is only used by certain Technical people to process complicated data. But Reality is that anyone can learn how to take benefits of Microsoft Excel’s powerful Capabilities & features. […]
This tip describes a quick method to randomize a list. It’s like shuffling a deck of cards, where each row is a card. Figure 165-1 shows a two-column list, arranged alphabetically by column A. The goal is to arrange the rows in random order. Figure 165-1: This alphabetized list will be randomly arranged. 1. In […]