ADVANCE
EXCEL


enroll for admission

Description​

Advance Excel is an indispensable tool for businesses and professionals of all levels, as it offers powerful data analysis, organization and reporting capabilities. With its comprehensive suite of features, Advance Excel provides users with numerous possibilities for analyzing and transforming data into meaningful insights. It also allows users to automate routine tasks like producing summary reports or creating spreadsheets and graphs. Moreover, user-friendly design elements make it easy to embed interactive visuals like pivot tables or sparklines into presentations or documents. Overall, Advance Excel is a robust application that empowers users to devise sophisticated analyses in quick time frames, making it invaluable for any professional dealing with expansive datasets.

ADVANTAGES OF ADVANCE EXCEL

  1. Improved DataAnalysis: Advanced Excel provides users with a range of powerful tools such as PivotTables, Power Query, Power Pivot, and data modeling that enables them to analyze and visualize data in various ways. With these tools, users can quickly create reports, charts, and dashboards that help them make informed decisions based on data insights.
  2. Increased Efficiency:Advanced Excel offers several time-saving features such as macros, keyboard shortcuts, and custom functions that can help automate repetitive tasks, increase efficiency, and reduce the risk of errors.
  3. Enhanced Data Management:Advanced Excel makes it easy to manage large datasets. With its filtering, sorting, and conditional formatting features, users can quickly find, sort, and highlight specific data in a large dataset. Furthermore, Advanced Excel offers powerful data validation, cleansing, and error checking features that ensure data accuracy and consistency.
  4. Improved Collaboration:Advanced Excel makes it easier for users to collaborate on spreadsheets. With its sharing and collaboration features, users can collaborate on spreadsheets in real-time, track changes, and share files easily.
  5. Improved Presentation:Advanced Excel offers powerful charting, formatting, and visualization tools that allow users to present their data in an engaging and meaningful way. With these tools, users can create professional-looking reports, charts, and graphs that convey insights more effectively.
  6. Accessibility:Advanced Excel is widely used and accessible, making it easy for users to share their work with others. Additionally, advanced Excel skills are highly sought after in the job market, and proficiency in Advanced Excel can be a valuable skill to have for many roles.

SYLLABUS OF
ADVANCE EXCEL

Basic worksheet modeling

  • Answers to this chapter’s questions
  • Problems

Range names

  • How can I create named ranges?
  • Answers to this chapter’s questions 
  • Remarks
  •  Problems

Lookup functions

  • Answers to this chapter’s questions
  • Problems
  • Syntax of the lookup functions
  • Answers to this chapter’s questions
  • Problems

The INDEX functions

  • Syntax of the INDEX functions
  • Answers to this chapter’s questions
  • Problems

The MATCH function

  • Syntax of the MATCH function
  • Answers to this chapter’s questions 
  • Problems

Text functions and Flash Fill

  • Text function syntax
  • Answers to this chapter’s questions 
  • Problems

Dates and date functions

  • Answers to this chapter’s questions
  • Problems

NPV and XNPV functions

  • Answers to this chapter’s questions
  • Problems

IRR, XIRR, and MIRR functions

  • Answers to this chapter’s questions
  • Problems

More Excel financial functions

  • Answers to this chapter’s questions
  • Problems

Circular references

  • Answers to this chapter’s questions
  • Problems

Toggle TitleIF, IFERROR, IFS, CHOOSE, and SWITCH functions

  • Answers to this chapter’s questions
  • Problems

Time and time functions

  • Answers to this chapter’s questions
  • Problems

The Paste Special command

  • Answers to this chapter’s questions
  • Problems

Three-dimensional formulas and hyperlinks

  • Answers to th
    is chapter’s questions
  • Problems

The auditing tool and the inquire add-in

  • Answers to this chapter’s questions
  • Problems

Sensitivity analysis with data tables

  • Answers to this chapter’s questions
  • Problems

Using the Scenario Manager for sensitivity analysis

  • Answers to this chapter’s questions
  • Problems

Using the Scenario Manager for sensitivity analysis

  • Answers to this chapter’s questions
  • Problems

COUNTIF, COUNTIFS, COUNT, COUNTA, COUNTBLANK functions

  • Answers to this chapter’s questions
  • Problems

SUMIF, AVERAGEIF, SUMIFS, AVERAGEIFS, MAXIFS, MINIFS functions

  • Answers to this chapter’s questions
  • Problems

The OFFSET functions

  • Answers to this chapter’s questions
  • Problems

Thew INDIRECT functions

  • Answers to this chapter’s questions
  • Problems

Conditional formatting

  • Answers to this chapter’s questions
  • Problems

Shorting in Excel

  • Answers to this chapter’s questions
  • Problems

Excel tables and table slicers

  • Answers to this chapter’s questions
  • Problems

Spin buttons, scrollbars, option buttons, check boxes, combo boxes, group list boxes

  • Answers to this chapter’s questions
  • Problems

The analytics revolution

  • Answers to this chapter’s questions
  • Problems

An introduction to optimization with Excel Solver

  • Answers to this chapter’s questions
  • Problems

Using solver to determine the optimal product

  • Answers to this chapter’s questions
  • Problems

Using Solver to schedule your workforce

  • Answers to this chapter’s questions
  • Problems

Using Solver to solve transportation or distribution

  • Answers to this chapter’s questions
  • Problems

Using Solver for capital budgeting

  • Answers to this chapter’s questions
  • Problems

Using Solver for financial planning

  • Answers to this chapter’s questions
  • Problems

Using Solver to rate sports teams

  • Answers to this chapter’s questions
  • Problems

Warehouse location, the GRG Multistart, Evolutionary Solver engines

  • Answers to this chapter’s questions
  • Problems

Penaltiens and the Evolutionary Solver

  • Answers to this chapter’s questions
  • Problems

The traveling salesperson problem

  • Answers to this chapter’s questions
  • Problems

Importing data form a text file or document

  • Answers to this chapter’s questions
  • Problems

Get & Transform

  • Answers to this chapter’s questions
  • Problems

Geography and Stock data types

  • Answers to this chapter’s questions
  • Problems

Geography and Stock data types

  • Answers to this chapter’s questions
  • Problems

Summarizing data by using descriptive statistics

  • Answers to this chapter’s questions
  • Problems

Using pivot tables and slicers to describe data

  • Answers to this chapter’s questions
  • Problems

The Data Model

  • Answers to this chapter’s questions
  • Problems

Power Pivot

  • Answers to this chapter’s questions
  • Problems

Nonlinear pricing

  • Answers to this chapter’s questions
  • Problems

Array formulas and functions

  • Answers to this chapter’s questions
  • Problems

Filled and 3D Power Maps

  • Answers to this chapter’s questions
  • Problems

Sparklines

  • Answers to this chapter’s questions
  • Problems

Summarizing data with database statistical functions

  • Answers to this chapter’s questions
  • Problems

Filtering data and removing duplicates

  • Answers to this chapter’s questions
  • Problems

Consolidating data

  • Answers to this chapter’s questions
  • Problems

Creating subtotals

  • Answers to this chapter’s questions
  • Problems

Charting tricks

  • Answers to this chapter’s questions
  • Problems

Estimating straight -line relaionships

  • Answers to this chapter’s questions
  • Problems

Modeling exponential growth

  • Answers to this chapter’s questions
  • Problems

The power curve

  • Answers to this chapter’s questions
  • Problems

Using correlations to summarize relationship

  • Answers to this chapter’s questions
  • Problems

Introducation to multiple regression

  • Answers to this chapter’s questions
  • Problems

Incorporating qualitative factors into multiple regression

  • Answers to this chapter’s questions
  • Problems

Modeling nonlinearitiies and interactions

  • Answers to this chapter’s questions
  • Problems

Analysis of variance: One -way ANOVE

  • Answers to th
    is chapter’s questions
  • Problems

Randomized blocks and two -way ANOVE

  • Answers to this chapter’s questions
  • Problems

Using moving averages to understand time series

  • Answers to this chapter’s questions
  • Problems

Winters method and the Forecast Sheet

  • Answers to this chapter’s questions
  • Problems

Ratio – to – moving – average forecast method

  • Answers to this chapter’s questions
  • Problems

Forecasting in the presence of special events

  • Answers to this chapter’s questions
  • Problems

SUMIF, AVERAGEIF, SUMIFS, AVERAGEIFS, MAXIFS, MINIFS functions

  • Answers to this chapter’s questions
  • Problems

An introduction to probability

  • Answers to this chapter’s questions
  • Problems

An introduction to random variables

  • Answers to this chapter’s questions
  • Problems

Binomial, hypergeometric, negation binomial random variables

  • Answers to this chapter’s questions
  • Problems

The Poisson and exponential random variable

  • Answers to this chapter’s questions
  • Problems

The normal random variable and Z-scores

  • Answers to this chapter’s questions
  • Problems

Weibull, beta distributions: Modeling machine life & duration of a project

  • Answers to this chapter’s questions
  • Problems

Making probability statements from forecast

  • Answers to this chapter’s questions
  • Problems

Using the lognormal random variable to model stock prices

  • Answers to this chapter’s questions
  • Problems

Importing historical stock data into Excel

  • Answers to this chapter’s questions
  • Problems

Introduction to Monte Carlo simulation

  • Answers to this chapter’s questions 
  • The impact of risk on your decision
  • Confidence interval for mean profit 
  • Problems

Calculating an optimal bid

  • Answers to this chapter’s questions
  • Problems

Simulating stock prices and asset-allocation modeling

  • Answers to this chapter’s questions
  • Problems

Fun and games: Simulating gamblin & sporting event probabilities

  • Answers to this chapter’s questions
  • Problems

Using resampling to analyze data

  • Answers to this chapter’s questions
  • Problems

Pricing stock options

  • Answers to this chapter’s questions
  • Problems

Determining customer value

  • Answers to this chapter’s questions
  • Problems

The economic order quantity inventory model

  • Answers to this chapter’s questions
  • Problems

Inventory modeling with uncertain demand

  • Answers to this chapter’s questions
  • The back-order case 
  • The lost-sales case 
  • What does the term 95 percent service level mean? 
  • Problems
  •  

Queuing theory: The mathematics of waiting in line

  • Answers to this chapter’s questions
  • Problems

Geography and Stock data types

  • Answers to this chapter’s questions
  • Problems

Estimating a demand curve

  • Answers to this chapter’s questions
  • Problems

Pricing products by using tie-ins

  • Answers to this chapter’s questions
  • Problems

Pricing products by using subjectively determined demand

  • Answers to this chapter’s questions
  • Problems

Recording macros

  • Answers to this chapter’s questions
  • Problems

Advanced sensitivity analysis

  • Answers to this chapter’s questions
  • Problems