Analir Pisani

Microsoft Excel has a command button in the ribbon that will apply several feature in one hit. It's great. It Applies Colour on every second row, turns on the Filters, has a totals row at the bottom,…

Instead of hiding and unhiding cells use the outlining feature of Microsoft Excel. Press plus and Minus buttons instead of hid/unhide. YouTube Analir Pisani. Outlining is the name of this feature. ht…

There is a little trick to entering your data in Excel as a percentage. We will talk you through the places where people tend to get stuck. YouTube Analir Pisani. If you need further assistance for a…

Need to be left with a unique list of data try remove duplicates is just one command button under the Data tab and you are done. You can always undo. YouTube Analir Pisani. Still stuck AZ Solutions P…

Playing with Filters in Excel spreadsheets. First ensure you have all the data selected. Quick tip mentioned for how to enter the current date by a shortcut key. YouTube Anallir Pisani. Customised Mi…

You have gone through the trouble to apply multiple formatting styles to a cell in a Microsoft Excel spreadsheet. Heard of the Format Painter. but there is a trick to using it that most people over l…

Widen Columns in a Microsoft Office Excel Spreadsheet is easy. YouTube Analir Pisani. Face to Face Customised lessons Sydney New South Wales and Virtual Classroom.

Analir Pisani - www.azsolutions.com.…

Join several cells to make them appear as one great for headings spread out over several columns of data. YouTube Analir Pisani. Classes available both Virtual and Face to Face Sydney. http:azsolutio…

Keeping Zeros in front of a number has always been a bit of a challenge. However I have the best solution. YouTube Analir Pisani or attend classes Virtual or Face to Face. http:azsolutions.com.au

Anal…

Struggling to see where formulas have been used in Microsoft Excel spreadsheets. I have a simple keystroke that will reveal all. YouTube Analir Pisani. Virtual Classes and Face to Face Customised Cou…

When you have lots of Excel Spreadsheets it can be a pain to navigate around. I have a tip that will knock your socks off. YouTube Analir Pisani. Virtual Classes in Microsoft Office as well as Face t…

You may have been filling Excel Formulas by simply dragging for 100 years. Well there is no need this podcast will reveal a stress free technique.YouTube Analir Pisani or hop on a Virtual Training Se…

Date keeps changing to a number and it stays eg;red formatted. One button and it's all sorted. This podcast will clarify the technique to clean your formatting in Microsoft Excel Spreadsheets. YouTub…

Need to see the data closer and bigger. Zoom into the Microsoft Excel spreadsheet with these techniques. Watch YouTube Analir Pisani or attend a Virtual Classroom unless you prefer Face to Face Custo…

The XLookup overcomes the limitations of the Vlookup Function in Microsoft Excel Spreadsheets. With the XLookup you are not bound by the lookup value being located in the first column of the table, y…