Advance Excel with VBA Contents Course

Sibyl Solutions
In Banglore

Price on request
You can also call the Study Centre
80254... More
Compare this course with other similar courses
See all

Important information

  • Course
  • Banglore
  • Duration:
    75 Days
Description

Important information
Venues

Where and when

Starts Location
On request
Banglore
# 410, 5th 'A' Cross, 2nd Block, HRBR Layout, Kalyan Nagar,, 43, Karnataka, India
See map

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




Compare this course with other similar courses
See all