Advance Excel with VBA Contents Course
Course
In Banglore
Description
-
Type
Course
-
Location
Banglore
-
Duration
75 Days
Facilities
Location
Start date
Start date
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