Advanced MS Excel 2007 2010 2013 2016
Details
Contact us for other payment options: [email protected]
Or chat with live person: www.facebook.com/InsightsManila
Or send a text message: 0977.103.1800
The Advanced MS Excel Training will level up your skill in order to efficiently process data in the spreadsheet. This course goes beyond VLOOKUP-- you will learn to look up data regardless of data orientation. You will also learn how to make advanced pivot table features such as Calculated Fields, Slicers, etc.
Outline
- Review of Basic Excel Functions
- Text Functions
- Math Functions
- Advanced Excel Functions
- Logical Functions
- Lookup Functions
- Array Functions
- Data Management
- Advanced Conditional Formatting
- Data Validation
- Basic Dropdowns
- Advanced Dropdown Options
- Other Data Validation Options
- Subtotal Tool
- PivotTables
- Creating and Using PivotTables
- Drill Down
- Using Tables
- Calculated Fields
Insights Manila (registered as Insights MLA Business Solutions) is a training services company based in Makati. The company believes that the country’s workforce requires ample training that is effective and insightful, yet affordable.
The consultants of Insights Manila are experienced professionals who had executed the courses several times for different companies under various training institutions.
Insights Manila mostly offers exclusive training for companies. The courses are customized to meet specific training needs. The company also offers public classes where individuals can enroll, and one-on-one training for people who wish focused training. Other than training, the company also accepts Excel automation projects and course development projects.
With Insights Manila, you are directly dealing with the consultants– no intermediary parties who just add costs to the training delivery.