Action eBiz Inc. | Microsoft Office Training| Toronto Mississauga |

Trace Formulas in Excel

13 Oct No Comments admin Microsoft Excel

If you are working with an Excel file created by someone else you may not be clear on how the formulas  connect to other cells. Select a cell and in Formula tab > Formula Auditing > Trace Dependents – this will draw a blue line to all the dependent cells (even

Excel Filter by colour

5 Oct No Comments admin Microsoft Excel

It is possible to filter n Excel by colour. Once the filter is applied click on the filter drop down arrow and select “Filter by Color” ) select the color you need filtered Note that it is best to use primary colors so people can tell the difference

Excel – Flash Fill

30 Sep No Comments admin Microsoft Excel

Flash Fill feature is a fantastic new feature in Excel 2013. You just give it an example or two of what you need it to do and it works out the rest for you. If you have first name and last name in one column and you need them in

Copyright © 1999 - 2016 Action eBiz Inc. |

Send us an email   Call 905.271.1119