Advance Excel

by Hi-Tech Academy Claim Listing

Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Hi-Tech Academy Logo

img Duration

25 Days

Course Details

Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. 

In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display. It allows sectioning of data to view its dependencies on various factors for different perspectives (using pivot tables and the scenario manager). 

It has a programming aspect, Visual Basic for Applications, allowing the user to employ a wide variety of numerical methods, for example, for solving differential equations of mathematical physics, and then reporting the results back to the spreadsheet.

 

Expected Skills:

  • Excel Introduction
  • Customizing Excel
  • Using Basic Functions
  • Formatting And Proofing
  • Mathematical Functions
  • Protecting Excel
  • Text Functions date And Time Functions
  • Advanced Paste Special Techniques
  • New In Excel 2013 / 2016 And 365
  • Sorting And Filtering
  • Printing Workbooks
  • What If Analysis
  • Logical Functions
  • Data Validation
  • Lookup Functions
  • Pivot Tables
  • Arrays Functions
  • Charts And Slicers
  • Excel Dashboard
  • Vba Macro
  • Variables In Vba
  • Messagebox And Inputbox Functions
  • If And Select Statements
  • Looping In Vba
  • Ranchi Branch

    6th Floor, Panchwati Plaza, Kutchery Rd, Ranchi

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy