Webs Jyoti, established in 2009, is a website Development and Training organization based in Gurgaon, India which offering a variety of services from Website development to classroom, indivisual and corporate trainings.
To schedule a demo session or to get course details call us : 8802000175
Features & Facilities
Corporate Training Specialist
Trained Over 500+ Classroom & Corporates
Training on YOUR Premises and OUR Premises
Certified & Well Qualified Instructors
Instructors with Considerable Industry Experience.
Experience in the Training Industry
Training Industry since over 9 years
At PRIME Locations – Old Delhi Road Gurgaon
Convenient Batch Timings
Weekend weekdays batches on various advanced topics
In this lesson we will teach you how to analyze your data with excel, how to use goal seek, how to use solver, how to create Amortization Tables to Calculate Mortgage Payment and how to use the Analysis ToolPak Add-In.
Pivot Tables are considered by most advanced Excel users to be the most powerful feature in Excel. Pivot Tables allow you to tabulate and report on data in your spreadsheets in ways that would take hours to achieve without using a Pivot Table.
When you use the Advanced Filter, you need to enter the criteria on the worksheet. Create a Criteria range (blue border below for illustration only) above your data set. Use the same column headers. Be sure there's at least one blank row between your Criteria range and data set.
Dashboards give you unprecedented visibility into your work. You can get a quick, visual status update on your projects or drill down into important details, all in one place. Dashboards can boost your organizations speed by allowing you and your team to see more, manage more, and communicate more.
Going beyond the basic computational tools of Excel unlocks unlimited potential for processing and analyzing data. In this chapter we will takes you beyond basic Excel computations by introducing logical functions and lookup functions. Logical functions are used to assess the contents within cell locations and produce custom outputs or mathematical computations. We will look at two types of logical functions in this chapter. The first is the IF function, which uses a logical test to evaluate the contents in a cell location. The OR and AND functions also use logical tests to evaluate the contents in a cell location and are often used within the IF function.
To test your basic excel skills