+977-01-4498485 9843354301 superitnepal2015@gmail.com support@superbraintechnology.com

Professional Advanced Excel Training


About this course

Super Brain Web Technology is the best Advance Excel Training Center in Kathmandu Nepal. Advance Excel course at Super Brain contains formulas, functions and types of financial analysis to be an Excel Expert User.

Advance Excel course designed by our expert team at Super Brain will help you become a world class financial analyst for careers in investment banking, private equity, corporate development, equity research and FP&A.

The basic notion on Microsoft Excel is not just limited on performing simple calculations, data storage, data analysis, report generation and complex statistical computations.. But Microsoft Excel is one the most powerful yet very easy tool to use for data analysis. Advance Excel topic contains on data analysis are lookup, scenario manager, subtotal, advanced filter, conditional formatting, graphs, solver, what if analysis, pivot table, slicer, index and match and so on. It also provides 18 statistical analysis tools and 80 statistical functions


Course Content

  1. Introduction to MS Excel, Quick Review on MS Excel Options, Ribbon, Worksheets and Toolbar
  2. Difference Between Excel 2003,2007,2010 and 2013
  3. Saving Excel File as CSV, Macro Enable Sheet, PDF and Older Versions
  4. Using Excel Shortcuts with Full List of Excel Shortcuts
  5. Copy, Cut, Paste, Hide, Unhide, Delete and Link the Data in Rows, Columns and Sheets
  6. Using Paste Special Options
  7. Formatting Cells, Rows, Columns and Sheets
  8. Protecting & Unprotecting Cells, Columns and Sheets with or without Password
  9. Page Layout, Themes, Background and Printer Properties
  10. Inserting Pictures, Hyperlinks, Header/Footers, Shapes and Other Objects in Worksheets

Exercises

  1. Conditional formatting
  2. Logic and nested functions
  3. Charts Revision of some basic elements of Excel
  4. Advanced formatting

Exercises

  1. Advanced table formatting
  2. Worksheets management
  3. Sort and Filters tools
  4. Subtotal

Exercises

  1. Mathematical functions
  2. Statistical functions
  3. Database functions
  4. Working with references on different worksheets

Exercises

  1. Creating a Pivot Table
  2. Analyze data with Pivot tables
  3. Changing a PivotTable’s Calculation
  4. Create and manage Scenarios and Summaries
  5. Define and use cells names
  6. Other What-if analysis tools

Excercises

  1. Data and time functions
  2. Text functions
  3. Financial functions
  4. Create custom number formats

Excercises

  1. Lookup and reference functions
  2. Data validation
  3. Auditing tools
  4. Security and protection options

Exercises

  1. Macro Definition
  2. Recording a Macro
  3. Assigning a Macro to the Quick Access
  4. Toolbar
  5. Viewing Macro Editor
  6. Writing code on VBA Macro

Exercises

  1. Importing and linking data
  2. Advanced copy and paste options
  3. Automation with Macros
  4. Reviewing tools

Exercises

Join Now ! or Enquire About this course