Specialized Microsoft Excel Training Center

If you wish to Excel your Microsoft Excel skills then you are the at the right place ... in-role today & get started

Welcome to Advanced Excel Training Center

As we all know that Microsoft Excel is the most popular and must needed application in any short of work we do. It is quite frequently and widely used Microsoft product across the globe. Advanced Excel training program is specially designed for the one who wish to master their Excel skills. We provide one on one training attention which will help you gain in depth knowledge towards Excel. Starting from Formatting, Conditional formatting, Formulas and Functions, Charts, Pivot Table, Macro‘s programming language called Visual Basic etc.

If you are truly serious about learning then here you will have several ways to access my knowledge and experience. I have arranged it in order so that you can choose the best module that may suite your requirement. Training is conducted online as well as offline, so if you are not comfortable to come down to our center you can opts for online training from your home or office.

Microsoft office Speciliest
×

  • Working in Excel Worksheet
    • Difference between Workbook / Worksheet
    • Difference between Formulas and Functions
    • How to use brackets "()" Commas (,) and inverted commas ("") in excel formulas?
    • Absolute and relative references
    • Working with Named Ranges
    • How to Protect a sheet?
    • How to Protect a cell?
    • How to hide a formula?

  • Functions and Formulas
    • Logical Functions: IF, Nested IF, AND,OR,NOT,IFERROR
    • Date and Time Functions: TODAY, NOW, YEAR, EDATE, EOMONTH, DAY and DATEDIF
    • Text Functions: TEXT,CONCATENATE, LEN, TRIM, UPPER, LOWER, LEFT, RIGHT
    • Statistical Function: COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFs, RANK, MAX, MIN, LARGE, SMALL
    • Reference Functions: LOOKUP, VLOOKUP, HLOOKUP, INDEX and MATCH
    • Database Functions: DSUM, DAVERAGE, DMAX, DMIN,DCOUNT
    • Mathematical Function: SUMIF, SUMIFs, AVERAGEIF, AVERAGEIFs
    • Financial Functions: PMT, RATE, PV, NPER

  • Creating complex functions using function Nested
  • Data Validation
    • Specifying a valid range of values for a cell
    • Specifying a list by valid name range
    • Creating list based on Data in other worksheet
    • Specifying custom validations based on formula for a cell

  • What if Analysis
    • Scenario Manager
    • Goal Seek
    • Data Table

  • Working with Array
    • What is an Array and Array Formula?
    • Creating Array Formula
    • Conditional Evaluation in an Array Formula
    • TRANSPOSE Array Function

  • Working with Styles and Conditional Formatting
    • Cell Styles
    • Format as Table
    • Conditional Formatting Using large no of icons and bars
    • Highlight cell values in a column based on Numeric/textual/date/Time etc
    • Conditional Formatting by using AND, OR Functions
    • Conditional Formatting by using Vlookup functions
  • Sorting and Filtering Data
    • Sorting tables
    • Using multiple-level sorting
    • Using custom sorting
    • Filtering data for selected view (AutoFilter)
    • Using advanced filter options
    • Extracting/removing duplicate record from database
    • Use of SUBTOTAL Function (For Dynamic Report)
    • Managing Linked Data
    • Data Consolidation
    • Consolidating data in multiple files
  • Pivot tables
    • Creating Pivot Tables
    • Grouping Data
    • Inserting Slicers (new in 2013)
    • Creating a PivotTable Timeline (new in 2013)
    • Inserting new calculated fields
    • Inserting Pivot Charts
  • Working with charts
    • Type of Charts: COLUMN CHART, BAR CHART,LINE CHART, PIE CHART, COMBO CHART, DOUGHNUT CHART
    • Changing the Style of a Chart
    • Adding a Shape and Images to a Chart
    • Adding a Trend line to a Chart
    • Adding a Secondary Axis to a Chart
    • Adding Additional Data Series to a Chart
    • Show, Hiding, or Changing the Location of Data Labels in a Chart
  • What is Workbook / Worksheet?
  • What is Cell, Rows and Columns?
  • How to Add/ Delete/ Rename/ Copy sheet
  • Formating : Page Setup, Text Alignment, Format Painter, Wrap / Merge text, Smart Art
  • Sheet Options , Header and Footer
  • Hyperlink / Symbols / Themes
  • Insert Picture or Shapes
  • Insert and Delete Single or Multiple Cell / Columns or Multiple Sheet
  • Share Workbook
  • Data Sort and Filter
  • Remove Duplicates
  • Data Text to Columns
  • Data Validation
  • Data Consolidate
  • Data Group , UnGroup, Subtotal
  • Protect Sheet / Workbook
  • Various types of charts (Column chart; Line chart; Pie chart; Bar chart etc)
  • Formulas and Functions
  • How to use brackets "()" Commas (,) and inverted commas ("") in excel formulas?
  • What is Absolute and Relative cell references?
  • Working with Name Range
  • What is VBA, Excel Macros
  • Creating, Storing And Running Your First Macro
  • Using Relative Or Absolute Referencing During Recording
  • Change macro security settings
  • Saving Workbooks With Macros Issues
  • Trigger A Macro With A Keyboard Shortcut
  • Using Form Buttons To Trigger Macros
  • Customizing The Form Buttons In Excel
  • Assigning Macros To Ribbon Icons
  • How to select cells/ranges by using VBA
  • How to create a personal workbook
  • Troubleshoot macro
  • View And Edit Macro Code, VBA coding
  • Calling a function
  • MsgBox
  • Declaring Variables
  • Creating Functions
  • Copy a macro module to another workbook
  • Form Controls and ActiveX Controls
  • Use A Macro For Formatting
  • Use Excel Formulas withen Excel VBA
  • Refresh Pivot Table via Excel Macros
  • Track and Report Excel Changes
  • Automatically Run Excel Macros Upon Opening Excel
  • Send Email automatically
  • Create Your Own Excel Function using VBA
  • How to Open and Close workbook with VBA?
  • How to automate your daily task
  • Creating Add-Ins
  • Converting an Excel Workbook to an Add-In
Note: Students have the flexibility to customize course syllabus as per their business needs.

What Others Have To Say About Us:


  • facebook
  • google+
  • Youtube
  • skype
  • whatsapp
  • mobile
  • mail