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

Check out more MS Excel courses in India

Don Bosco Technical School Logo

DTP1 (Typing, Intrduction to Computer, Windows, Ms Office)

DTP1 (Typing, Intrduction to Computer, Windows, Ms Office) Course is Offered by Don Bosco Technical School.

by Don Bosco Technical School [Claim Listing ]
EITM (Eden Institute of Technology Management) Logo

Certificate In MS Office Proficiency

Certificate in MS Office Proficiency course is offered by EITM (Eden Institute of Technology Management). EITM aims to be an outstanding institute for Talent Development and Knowledge Creation for a vibrant and inclusive society.

by EITM (Eden Institute of Technology Management) [Claim Listing ]
E-Escot Educare Logo

Basic Computer

Word Processing, Spreadsheets, Presentation are of great use in day to day work in Home at Office. Work Processing contain daily typing works, page layout functions. Spreadsheets help us in daily calculations, preparing charts for business work.

by E-Escot Educare [Claim Listing ]
STG Education Logo

MS Excel

Excel is a spreadsheet program used to save, modify and retrieve numerical data in a grid format of columns and rows. Excel is the basis for almost every profession for entering, calculating and analyzing data such as product sales, figures, plan budgets, chart data, sales taxes or commissions.

by STG Education [Claim Listing ]
KS Technologies Logo

MS Access

MS Access is RDBMS software package offered by Microsoft. It is one of the most popular software tool for managing data in tabular form. This tool offers amazing set of features to maintain database.

by KS Technologies [Claim Listing ]

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