Save time, fill across worksheets…
The Fill menu has a number of interesting options. One allows you to copy the same data into multiple worksheets in one go. Select the data to copy.Hold down Ctrl and select the other worksheets that you want to copy to.Go to the Home menu, find the Editing section, select the Fill dropdown. Choose Across […]
Data Types: Get your information here!
Excel includes Data Types that can get information directly from the internet and put it straight into your spreadsheet. You can find the Data Types on the Data Menu. You can choose from twenty different types of information, including Stocks, Geography, Food, and Movies. Type in the thing you are interested in, select which data […]
Increase accuracy of data entry using Data Validation.
Using data validation in Excel means you can put restrictions on what can be entered into the cell, increasing accuracy. There are a lot of different options and settings within the data validation area. Here we have a drop down list of choices that the user can select from. You could also require the data […]
Time saver: Enter data in multiple cells at once.
Select cells to enter the data into (Holding down the ctrl key if they are not in one continuous block). Type into one cell. Press Ctrl + Enter, the data is entered into all the selected cells.
Avoid manual data entry with the Fill Handle.
Instead of doing lots of typing, did you know you can fill a series of cells based on just one manually entered cell? Using the Fill Handle, you can. For example, if you write in a date, and take your mouse to the bottom right-hand corner of the cell, the pointer will turn into a […]
Super Powerful: Power Query
If you are having to collate information from different sources into one place, learn about Get & Transform. (It used to be called Power Query and is still often referred to as this.) It will change your life. The Basics You can find Get & Transform on the Data menu. Basically, Get & Transform is […]
Make your data colour coded with Conditional Formatting
Conditional Formatting, such a great tool. On the home tab of your #Excel sheet or shortcut key Alt, H, L. Start by selecting the cells that you want to apply the formatting too. I have used it to highlight all the cells in my column that are over 85. You can use it to automatically […]
Make your life easier, use shortcut keys in Excel.
Shortcut keys can make your time on Excel much more efficient. Reaching for the mouse or touch pad to do something is definitely slower than using a shortcut key. Also, some of the best shortcut keys saving typing time and are more accurate. It can take a bit of time to get used to using […]
Display just the way you want.
The data displayed in a cell can be different to the data that is stored in the background. You can change the way the data looks by formatting the cell. Perhaps the simplest way to understand this is to enter a number and then format it as money (either Currency or Accounting). The data stored […]
Workbook, Worksheets, and Cells.
There is some terminology that is important to understand when using an Excel spreadsheet. The workbook is the whole file. You can change the name of the workbook by saving the file with a new name. A workbook can have one or more worksheets. Each worksheet is listed across the bottom of the workbook in […]