Analir Pisani Profile

Blog

These posts have been designed by Analir Pisani from AZ Solutions. Analir is a Certified instructor with over 24 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, Visio, 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

Excel is for everyone, all business types. If choosing the right Excel Course level to book into is daunting for you. Then attend a customised Microsoft Office Computer courses instead where you can bring examples of your own work. Book in with a group of your colleagues or just for you. The main things an employer is looking for out of your Excel skills is that you can create basic spreadsheets with formatting, basic formulas and functions like SUM, AVERAGE and COUNT. For the high-end skilled jobs like Analysts they are looking that you know more complex functions like, VLOOKUP, INDEX, MATCH, PIVOT TABLES and MACROS. Remember is you are serious about making this knowledge stick then, practice, practice, practice withing the first week of your learning.

  • PowerPoint presentations

Design Effective PowerPoint Presentations

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

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

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

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

  • excel courses

Excel Formatting

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

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