Advance Excel with VBA Contents Course

Sibyl Solutions
In Banglore

Price on request
Compare this course with other similar courses
See all

Important information

  • Course
  • Banglore
  • Duration:
    75 Days

Important information

Where and when

Starts Location
On request
# 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