Details
This course is for users who have a Microsoft 365 version of Excel. The new features of Excel are more efficient, simple, and powerful than lower versions of Excel. Microsoft 365 continuously innovates its functionalities and adapts to the rapid changes of industries due to pandemics. Excel 365 is an effective tool for workers or organizations that heavily rely on collaboration, more powerful than Google Sheets.
Users: Beginners and Intermediate
Webinar will be conducted through ZOOM platform. . You can also download the app through Playstore and Appstore on your mobile/tablet device.
Requirements:
- Zoom and STABLE INTERNET. If you don't have stable internet you may opt to receive a recorded sessions instead.
- Must have Microsoft Excel with version 365.
- It is highly recommended that you run MS Excel during the session.
INCLUSIONS:
- Live interactive training with Q& A
- Lifetime access to modules and learning materials(will be sent to you at least 30 minutes before the actual session)
- Lifetime access to copy of recorded session of the training
- One month support for trainee in application of Excel
- Certificate of Completion
Outline
- Find the largest and smallest value based on criteriaCombining cell data with separators
- Dynamic Arrays, such automatic filter based on conditions, sorting and retun to unique list of values
- Modern replacement of NESTED IF
- Replacing values
- Modern replacement and flexible lookup of VLOOKUP
- Modern replacement and flexible lookup of INDEX-MATCH
- Collaboration of Excel 365
Speaker/s
He conducted over hundreds of online trainings and company-site training and coached over thousands of individuals, executives, professionals and entrepeneurs.
Special Offer
Discounted price to Php 1,950.00
Providing training for MS Excel, MS Access and Power BI for individual, group and company. Inquire now to request details and schedules.
We cater tutorial services and online and onsite training conducted by expert and certified Microsoft trainer. Upskill and invest an in-demand skill. We ensure that you acquire the required efficiency and productivity in data management , analysis and visualization through Excel and other Microsoft Offices.