Analir Pisani, Director

Analir Pisani Profile

These posts have been designed by Analir Pisani from AZ Solutions. Analir is a Certified instructor with over 25 years experience in delivering Microsoft Office Courses to a wide audience both Face to Face and Virtual Classroom.

Speciality is to customise the course to the group.

Deliver training in Excel, Word, Outlook, OneNote, Publisher, One Drive and Microsoft Office 365.

Use the categories section to choose a subject dear to you. Or you might prefer to search for a topic like “how to create basic formulas”, “formatting in Excel”, “how to create styles in Word”.

  • ms certification

Jobs Requiring Excel Skills

10th July, 2020|

Excel is for everyone. An employer is looking that you can create basic spreadsheets with formatting, basic formulas and functions like SUM, AVERAGE and COUNT. For the high-end skilled jobs you'll need complex function skills.

  • PowerPoint presentations

Design Effective PowerPoint Presentations

10th May, 2020|

Design ideas feature makes presentation design easy. Reduce bullet points by converting text to SmartArt and where possible you your company corporate colour scheme. Transitions and Animations are great but don't over use them.

  • excel courses

Complex Functions

1st March, 2020|

Need to cross check or copy, paste data but keep it linked. Lessons in Excel available in Sydney. Try VLOOKUP or XLOOKUP Function in Excel.

  • SUM

Basic Functions

1st February, 2020|

Functions are different to Formulas. Formulas use operations like + - * / where as Functions follow a structure. They both start with = A Functions has = Function Name ( in that order. There are over 300 Functions in Microsoft Excel.

  • bodmas

Basic Formulas

1st November, 2019|

All Formulas and Functions begin with =. Operators are + - * / and they need to be used in a specific order.

  • excel courses

Excel Formatting

1st October, 2019|

Formatting Excel spreadsheets made easy by using the correct tools. Most useful tools are Conditional Formatting and Format as Table features.

  • woman-typing-writing-windows

Pivot Tables

1st September, 2019|

Use Dynamic data to create your Excel Pivot Tables. Excel Courses available M: 0414417059