Advance Excel with VBA Contents Course

Course

In Banglore

Price on request

Description

  • Type

    Course

  • Location

    Banglore

  • Duration

    75 Days

Facilities

Location

Start date

Banglore (Karnātaka)
See map
# 410, 5th 'A' Cross, 2nd Block, HRBR Layout, Kalyan Nagar,, 43

Start date

On request

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme



Module 1- to begin with Excel

: Basics of Excel
: Rows & Columns Excel
: How to Enter text & numbers in a Cell
: To edit text in a Cell
: To Centre text & numbers
: Font Formatting methods in Excel
: Changing the colour of a Cell
: Way of saving your work in Excel
: Symbols of Currency in Excel
: Method of Merging Cells
: Review Number One

Module 2 - A more intricate spreadsheet

: Description to Section Two
: The uses of Auto-Fill in Excel
: How to enter Simple Addition Formula
: The Function of SUM in Excel
: How to Copy & Paste
: The use of Paste Special
: Method of multiplying in Excel
: How to finish your spreadsheet for this section
: Method of adding a Comment to a Cell
: Review Number Two

Module Three - Charts on Excel

: Ways of data sorting in Excel
: How to make an Excel Chart
: Move & Resize your Chart
: Chart Styles & Layouts
: Chart Titles & Series Titles
: Excel Chart Layout Panel
: Format of Chart Panel
: How to Create a Pie Chart in Excel
: How to Add Labels to a Pie Chart
: Format Pie Chart Segments
: How to create a 2D Line Chart in Excel
: Formatting your Axis Titles

Excel Formulas

: The SUM method in Excel
: How to Multiply in Excel
: Subtract & Divide
: Combining the Arithmetic Operators
: Budget Spreadsheet in Excel

Functions in Excel

: The normal Function in Excel
: Date Function
: Time Functions of Excel
: Financial Functions



Conditional Logic in Excel

: The Function of IF
: Conditional Formatting in Excel
: Count IF
: Sum IF


Important tables in Excel

: Excel Pivot Tables
: Pivot Tables, Part 2



Advance Excel with VBA Contents Course

Price on request