Skip to main content

SILABUS TRAINING MICROSOFT EXCEL ADVANCED


TRAINING MICROSOFT EXCEL ADVANCED

MICROSOFT EXCEL ADVANCED TRAINING

Purnama Academy Bandung , Jakarta Training Provider
Method : Online Training , Offline Public Training, Inhouse training
Duration : Call/WA 0838-0838-0001



What is :
Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.

What You will learn :
Able to use and apply Database function
Able to use and apply Logical function (IF, AND)
Able to use and apply Statistical function (COUNTIF, AVERAGEIF, COUNTIFS, AVERAGEIFS)
Able to use and apply Mathematical function (SUMIF, SUMIFS)
Able to use and apply Lookup function (VLOOKUP)
Able to use Auto and Advanced Filter command
Able to validate data
Able to apply Conditional Formatting
Able to Protect worksheet and workbook
Upon completion of this program, participants should be able to:

Advance Chart function and PowerPivot Function
Analyze data Using Pivot Tables
Perform What If Analysis using:
Goal Seek
Solver
Input Table
Scenarios
Use VLOOKUP function to extract data
Nesting INDEX and MATCH Function
Combining & Consolidating Data
Create Hyperlink in a workbook


Syllabus Detail : Call/ Whatsapp 0838-0838-0001 , http://www.purnamaAcademy.com
ALL THE BEST TRAINING YOU CAN GET WITH OUR BEST TRAINER
COVID-19 COMPLIANT


Other Recommendation training in Purnama Academy :

ā€¢ Excel Advanced for Business & Accounting
ā€¢ Excel VBA Macro Programming
ā€¢ Excel PowerPivot , PowerView, Power BI

Comments

Popular posts from this blog

Laravel Training Purnama Academy

Nov 2018 Purnama Academy 0838-0838-0001 Kursus Laravel Training Center INdonesia, jakarta, Bandung, Bogor, Semarang, Yogya, Palembang kalimantan, surabaya visit www.purnamaacademy.com , Laravel - Online Courses, Classes, Training, Tutorials on Lynda https://www.lynda.com/Laravel-training-tutorials/2779-0.html Learn how to use Laravel, from beginner basics to advanced techniques, with online video tutorials taught by industry experts. Top Laravel Courses Online - Updated November 2018 | Udemy https://www.udemy.com/topic/laravel/ Whether you're interested in developing web apps in the Laravel PHP framework, or building a RESTful API with Laravel, Udemy has a course to help you ... PHP Laravel Framework | Brainmatics.Com brainmatics.com/php-laravel-framework/ Translate this page Laravel merupakan framework PHP yang dirancang untuk membangun situs web ... Pada training ini diharapkan mampu membantu meningkatkan kemampuan ... Dec 3 - Dec 6 Brainmatics Laravel training - Laracasts htt...

TRAINING SQL Server 2017 DATABASE ADMINISTRATOR-BANDUNG

TRAINING SQL Server 2017 DATABASE ADMINISTRATOR By Purnama Academy - Training Center January 18, 2018  No comments SQL Server 2017 DATABASE ADMINISTRATOR Syllabus Class Type           : Training Duration              : 4 Days (09.00 ā€“ 17.00) Training Description : Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applicationsā€”which may run either on the same computer or on another computer across a network Database administrators (DBAs) use specialized software to store and organize data. The role may include capacity planning, installation, configuration, database design, migration, performance monitoring, security, troubleshooting, as well as backup and data recovery Call us for detail syllabus ! ...

Download Slank Full Album lagi sedih 4shared

Untuk para slanker, salah satu album legendaris slank lagi sedih 1997, download gratis di 4shared.com http://www.4shared.com/get/HsDEfGc6/slank-lagi_sedih.html HERY PURNAMA Certified IT Trainer http://www.inhousetrainer.net , http://www.purnama.info hery.purnama@gmail.com , hery@purnama.info  Call/ SMS/WA :  081.223344.506    Blog :   inhousetrainer.blogspot.com   freelance-it-trainer.blogspot.com    Social Net :   facebook.com/inhousetrainer   twitter.com/inhousetrainer   instagram.com/inhousetrainer Hometown : Bandung - Jawa Barat Please consider your environmental responsibility. Before printing this e-mail message, ask yourself whether you really need a hard copy.