Pivot Tables Field lists can be hard to find the field you are after. Since 2013 Microsoft added a search bar in the Pivot Tables Field List area. YouTube Analir Pisani. If you still can't find it drop us a line by visiting our web site http:azsolutions.com.au. If you get really stuck AZ Solutions Pty Ltd customised Microsoft Office training sessions.

Analir Pisani - www.azsolutions.com.au
Microsoft Office Training Specialist

Struggling to keep your inbox under control. I have a few tips to help. Set some rules. Use the Do not Save command button and a great one to remember is to file it away before you hit the send button. The idea is that you want to touch the inbox files a little as possible. More great tips. https:azsolutions.com.au

Analir Pisani - www.azsolutions.com.au
Microsoft Office Training Specialist

There are some great features of the XLOOKUP Function, most peoples favourite part I imagine would be that the lookupvalue can be located anywhere not just on the first column of your table. XLOOKUP function eliminated the need for nesting other functions to get the job done like the IFERROR and MATCH functions. You can also search from top to bottom or from Bottom to top. The IFERROR component is built into the functions. I also have a YouTube Video if you prefer lookup Analir Pisani. If face to face consulting is best and you are in Sydney Australia https:azsolutions.com.au can help.

Analir Pisani - www.azsolutions.com.au
Microsoft Office Training Specialist

Getting the 2 in H2O to sit below the line level you need Subscripts. Think submarine and for 20 degrease Celcius o to sit above the line level you need SuperScript. Think superman. YouTube Analir Pisani. http:azsolutions.com.au. Virtual and Face to Face Microsoft Office training for groups available in Sydney Australia. 

Analir Pisani - www.azsolutions.com.au
Microsoft Office Training Specialist

Change the bullet design, Add to a numbering system in Microsoft Word, Changing Bullets to Numbers. Stop numbering enter twice. YouTube Analir Pisani. Virtual Classes available. http:azsolutions.com.au

Analir Pisani - www.azsolutions.com.au
Microsoft Office Training Specialist

Change Case using Shortcut keys. YouTube Analir Pisani. http:azsolutions.com.au. Face to Face Microsoft Office Computer Courses Sydney Australia.

Analir Pisani - www.azsolutions.com.au
Microsoft Office Training Specialist

Need to pull bits and pieces of your data out of one cell. You may use text to column. There is a new way it's called Flash Fill. As the name suggests it will save you soooo much time. Yes in a Flash. YouTube Analir Pisani. http;azsolutions.com.au. Want more try face to face customised Microsoft Office Training session just for your team. 

Analir Pisani - www.azsolutions.com.au
Microsoft Office Training Specialist