IT DIGEST
To open Disk Cleanup on a Windows 8 or Windows 8.1 system, follow these instructions: Click Settings > Click Control Panel > Administrative Tools. Click Disk Cleanup. At the Drives list, select which drive you want to run Disk Cleanup on. Select which files you want to delete. Click OK. Click Delete files. How do […]
Contributions to 401(k)s must be done through payroll. However, many plans allow free changes to your contributions. Technically, the tax code states you are limited to contributing 100% of your earnings or the contributory maximum, whichever is less. Can I contribute to my 401k outside of payroll deduction? Pre-tax contributions to your 401(k) must be […]
Support for Windows 8 ended on January 12, 2016.Microsoft 365 Apps is no longer supported on Windows 8. To avoid performance and reliability issues, we recommend that you upgrade your operating system to Windows 10 or download Windows 8.1 for free. Can I still use Windows 8 after 2020? Windows 8 has reach end of […]
Where is the tab key on the keyboard? You can find the tab key on the left side of the keyboard, just above the caps lock key and to the left of the Q key. You can recognize the tab key by its two arrows going in opposite directions and pointing towards a line, one […]
VLOOKUP stands for ‘Vertical Lookup‘. It is a function that makes Excel search for a certain value in a column (the so called ‘table array’), in order to return a value from a different column in the same row. How do I use VLOOKUP in Excel? In the Formula Bar, type =VLOOKUP(). In the parentheses, […]
The VLOOKUP function performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index_number position. The VLOOKUP function is a built-in function in Excel that is categorized as a Lookup/Reference Function. How use VLOOKUP step by step? How to […]
VLOOKUP stands for ‘Vertical Lookup’. It is a function that makes Excel search for a certain value in a column (the so called ‘table array’), in order to return a value from a different column in the same row. What is the use of VLOOKUP in Excel with examples? The VLOOKUP function in Excel performs […]
How to use VLOOKUP in Excel Click the cell where you want the VLOOKUP formula to be calculated. Click Formulas at the top of the screen. Click Lookup & Reference on the Ribbon. Click VLOOKUP at the bottom of the drop-down menu. Specify the cell in which you will enter the value whose data you’re […]
Sparklines are tiny charts inside single worksheet cells that can be used to visually represent and show a trend in your data. Sparklines can draw attention to important items such as seasonal changes or economic cycles and highlight the maximum and minimum values in a different color. What are sparklines and their purpose? Sparklines are […]
9 Ways to Organize and Manage Your Calendar Properly Schedule everything. Break down your activities into simple problems. Color-code your calendar using the chakra system. Choose strategy over opportunity. Eat that frog. Consider time blocking instead of to-do-lists. Create an “optional” calendar. How do you set up a calendar to organize personal and work schedules? […]