LEARNING COMPUTER INSTITUTE

  Data Validation in Excel Learn how to add drop down lists, whether static or dynamic, to have complete control of your data input! This section shows how much you can do in implementing data validation in Excel. You would think that Microsoft Excel is all about inputting raw data inside. But add the layer of data validation and you can have more control over getting clean data. Data Validation in Excel is a wonderful feature and is essential to master if you want to have complete control of your data. You can have custom data validation in Excel as well with dynamic drop down lists! It will look like magic when you see your drop down lists change their contents after another field has been populated. Read all about it below! Here are the top things on how to do Data Validation in Excel: Dynamic Data List using Excel Tables Excel Tables have many great features to them and one of them is their ability to create a dynamic drop down list. A dynamic drop down list expands as the...

  Conditional Formatting Learn how to add color & shapes to your data & reports to highlight key findings. Conditionally Formatting a Drop Down List We are now going to take this concept one level further and apply some conditional formatting to the drop down data validation list. This is useful if you want to highlight when a job is completed, check off items from a list or to evaluate risk in a project just like I have done in below´s example. STEP 1:  Select the range that you want to apply the conditional formatting to. STEP 2:  Go to  Home > Styles > Conditional Formatting > Manage Rules STEP 3:  Select  New Rule STEP 4:  Create the new rule for  High  values: Select  Use a formula to determine which cells to format Type in the Formula  =$A4=”high”  This formula will ensure only the column is absolute. Go to  Format > Fill  then select a color of your choosing.  Click OK. Repeat the same ...

  Excel Keyboard Shortcuts Learn about the many Excel keyboard shortcuts & discover a lot of hidden gems here! CTRL + SHIFT + ARROWS: Move / Highlight Cells If you want to quickly move to the last cell of your table/data you can press CTRL +  ↔ ↕ . If you want to quickly highlight up to the last cell of your table/data you can press CTRL + SHIFT +  ↔ ↕ . CTRL + SHIFT + L: Insert a Filter in Excel To insert a filter in Excel using a keyboard shortcut you need to click in a column heading and press  CTRL+SHIFT+L To un-filter, you need to press this shortcut again.  I use this shortcut all the time :) F4: Repeat Last Action If you want to repeat a previous action, like  inserting a column/row, formatting cells, copy & pasting etc , then you can use the F4 keyboard shortcut which will repeat your last action (in most cases).

  How to Use Windings Symbols in Excel Wingdings  is a symbolic font that a lot of us use for fun. I do that a lot too! But what if we wanted those cool symbols to be of good use in Excel? Whenever I tried typing using the Wingdings font, I was not sure which symbol I would get! I will show you how easy it is to pick a  cool Wingdings Symbol  and use it in your Excel worksheet! Here is a sample usage of a Wingdings symbol for stock prices: STEP 1:   Select the cells that you want to place the symbols in: From the  Font dropdown , select  Wingdings: STEP 2:  Now that our cells are able to accept Wingdings symbols, go to  Windows Start (Windows 10)  > Search Bar > Character Map If you are have an older version of Windows, go to  Start > All Programs > Accessories > System Tools > Character Map STEP 3:  You will now see all the characters!  Ensure the  Font  is  Wingdings. Doubl...