TYPE: PHYSICAL
DURATION:30 HOUR
BATCH START
DATE:
Apr.16,2023
PRICE:
10000
.jpg)
This course aims to provide trainees with knowledge that will further boost their ability to perform complex business operations and overall management functions.
Advance excel is a spreadsheet tool that is used to store and make sense of all the data that are generated. The sheer amount of data can be presented visually giving you the comfort of using graphics, data can also be calculated, organized and evaluated by the use of Advance Excel. This course will give you a deep understanding of the advanced formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool. While most Excel courses focus on simply what each formula does, we teach through hands-on, contextual examples designed to showcase why these formulas are awesome and how they can be applied in a number of ways. We will not train you to regurgitate functions and formula syntax; We will teach you how to THINK like Excel.
Working with Dates
Working with Tables
Working with Charts
Condiitional Formulas and Formatting
Using Logical Functions
Working with Lookup Functions
Working with Multiple Worksheets and Workbooks
Documenting and Auditing
Advanced List Management
PivotTables and PivotCharts
Using "What-If" Analysis Tools
Macros
Working with Large Worksheets
Kings College, Kathmandu, Nepal
Remote
New Baneshwor
New Baneshwor
New Baneshwor
New Baneshwor
Intern Nepal - Recruit Nepal is a visionary project aimed to link education, industry and human resource. We intend to reinvent internships & bring unique alignments in talent acquisition.
View More
