fbpx


© Copyright ICE Pakistan

Advanced Excel (Level 1 and 2)

Become an Expert of Advance Excel 2019 Financial Modeling & Valuation Analyst

Course Duration

2 months

Class Timing

1.5 hours

Class Schedule

3 days/week

Delivery

Online/On-campus

Fee Packages

Level 1: Rs 25,000

Level 2: Rs 25,000

About Advanced Excel

Advanced Microsoft Excel 2019 is designed for persons who already possess basic to intermediate knowledge of Microsoft Excel 2019.  Participants are introduced to the advanced features in Microsoft Excel 2019 where they will learn to calculate data using advanced formulas and functions, analyze data and use other advanced tools.

This course is divided into two levels to effectively cater to people’s requirements:

Level 1: Beginners

Level 2: Professionals

Interested? Let us contact you

I agree to the privacy policy.

Learning Outcomes

5 Reasons Why You Should Do Advanced Excel

Lets you be detail-oriented

Lets you protect your work better

Saves time

Helps you avoid mistakes

Adds efficiency in your life

Course Plan

  • Introduction of Microsoft Excel 2019  
  • Excel Spreadsheet Structure introduction 
  • Introduction of Excel Formulas 
  • Sum, subtract, Divide, multiple, IF, Nested-if, count, Count if, CountA, Countifs 
  • Differentiate b/w Average & Percentage  
  • File Tab, Home Tab Tools 
  • Table Designing & Shorting 
  • Marksheet, Salary Sheet, Retirement Sheet  
  • Excel securities & Shortcut Keys 
  • Expenditure Sheet, Attendance Sheet  
  • Dialogue Box and Task Panes 
  • Tasks & Test Project

  • Insert Tab Tools 
  • Conditional Formatting (Data High-lighter) with 40 Rules  
  • Excel Sheet (Budget Sheet, Library Sheet, Profit/Loss Sheet) 
  • Column / Bar Chart, Line Chart, Pie Chart, Tree map, Histography) 
  • Forecasting Analyzing 
  • Navigating in Excel 
  • Constituents of Excel Formula 
  • Operators in Formula 
  • Absolute cell Reference  
  • Tasks & Test Project

  • Insert Tab Tools 
  • Pivot Tables Techniques 
  • Hyperlinks the Data  
  • Balance Sheet  
  • Formulas (Sum, Sumif, Sumifs, Average, Average if, Averageifs, Subtotal) 
  • Invoice Handling 
  • Header / Footer Setting 
  • Task & Test

  • Creating Multi-Category Charts 
  • Creating a Gauge Chart 
  • Creating a Thermometer Chart 
  • Creating a Milestone Chart 
  • Creating a Water Fall Chart 
  • Creating Gantt Chart 
  • Creating Chart with Trend Arrows in Data Labels 
  • Creating a Chart with Actual and Target Values 
  • Spotting Data in a Scatter Chart in Excel 
  • Creating Dynamic Target Line in Excel Bar Charts Course Falling / Running Plan

  • Excel Hidden Tricks 
  • Inventory with Stock Making Report 
  • Data Validation Rules 
  • VLOOKUP, HLOOKUP, Concatenate, Datedif, Networkdays, PMT  
  • How to Adjust Long Sheet in One Page with 5 Techniques 
  • Excel Shorting & Freezing Headings 
  • Insert Water Mark 
  • Day Book Report 
  • Task & Test

  • Introduction to the Paste Special all Option. (Formulas, Values, Formats, Comments, Validation, all using source themes, All except Borders, Column Widths, Formula and Number formats, Values and Number Formats, None, Add, Subtract, Multiply, Divide, Skip Blanks and Transpose) 
  • Discount Sheet / Rent sheet / Shop Budget Sheet 
  • Excel Error Solve Formula (Trim, Abs, Now, Today, Fixed, Upper, Lower, Proper, Large, Len, Formula Text, Roman, Clean, Round, if-error, Clean, Transpose, And, OR, NOT, Day, Month, Year, Dated- if, Rept. 
  • Excel Tips & Tricks 
  • Task & Test

  • Function of Absolute Cell Reference with multiple examples. 
  • Formulas (Round, Roundup, Rounddown, Product, SUMPRODUCT, Days360 ) 
  • Functions of New Microsoft” Kutools Tabs” 
  • Kutools Tabs Tools & Groups (Ranges, Cells Group, Editing Group, Formulas, Mailing Group, Protect Group) 
  • Data Tab Tools (Remove Duplicate, Flash fill, Transformation of Data) 
  • What-if analysis 
  • Group or Ungroup  
  • Review & view Tab tools 
  • Macros Function

  • Assessment (all sheet + formulas + 16 tab tools assessment)
  • Final Test
  • Project

Need more information?
Book a FREE call with our Academic Counselor now

First Name *
Last Name * Email *
Phone No (with country code) Nationality * Date of birth *
City



    I have read the privacy policy.

First Name *
Last Name *
Email *
Phone No (with country code)
Nationality *
Date of birth *
City
    I have read the privacy policy.