Advanced Excel Course Training

Advanced Excel Course Overview:

MS-Excel is a commercial spreadsheet application produced and distributed by Microsoft Windows and Mac-OS. It has a characteristic of performing the basic calculations, graphing tools, creating pivot tables and creating macros and this application performs very effectively on arithmetic solution.

Advanced Excel Course for :

This course is designed for those who want to familiar with the Microsoft Office Package. Specially designed for the professionals to create business and flash reports to senior management, spreadsheets, performing calculations on data and other features of the excel package.

Advanced Excel Course Syllabus:

Advanced Excel Course

Date & Time

  • Date, Time
  • Day,Month and Year functions

Formulas

  • Creating Formulas
  • Copying Formulas
  • Operators
  • Using Operators in Formulas
  • Formula Error Messages

Text Functions

  • Left, Right, Mid, Len
  • Lower, Upper
  • Concatenate

Logical Functions

  • Using the If Function;
  • If functions with formulas

Statistical Functions

  • Max, Min Function
  • Large, Small Function
  • Count, Average Functions

Charts

  • Inserting different chart types.
  • Resizing and deleting a Chart
  • Chart Title or Labels
  • Chart Background Color
  • Column, Bar, Line or Pie Slice Colors
  • Copying and Moving Charts

Setup & Printing Issues

  • Worksheet Margins
  • Worksheet Orientation
  • Worksheet Page Size
  • Headers and Footers
  • Header and Footer Fields
  • Scaling Your Worksheet to Fit a page

Page(s)

  • Printing Titles On Every Page
  • Printing the Row and Column

Headings

  • Spell Checking
  • Previewing a Worksheet
  • Viewing Workbooks Side By Side
  • Printing Options

Input Tables

  • One-Input Data Tables
  • Two-Input Data Tables

Manipulating Worksheets

  • Copying or Moving Worksheets
  • Splitting a Window.
  • Hiding Rows, Columns & Worksheets.

Data Validation with criteria

Paste Special Options

  • Using Paste Special to Add, Subtract.

Multiply & Divide

  • Using Paste Special ‘Values’.
  • Using Paste Special Transpose Option.

Advanced Excel Course

Pivot Tables

  • Using a Pivot Table.
  • Filtering and Sorting Data
  • Grouping Data
  • Creating Dashboard with dynamic datas
  • Pivot charts

Hyperlinks

  • Inserting a Hyperlink.
  • Editing a Hyperlink
  • Removing a Hyperlink

Linking & Embedding

  • Linking Data within a Worksheet.
  • Linking Cells between Worksheets within a Workbook.
  • Linking Data between Workbooks.
  • Linking Data from Excel to a Word Document.
  • Linking an Excel Chart to a Word Document.
  • Updating, Locking and Breaking Links.

Sorting and Filtering Data

  • Sorting Data by Multiple Columns
  • Custom Sorts
  • Customized List
  • AutoFilter.
  • Top 10 AutoFilter.
  • Advanced Filter Criteria.
  • Sub-Totalling.
  • Removing Subtotals.
  • Expanding and Collapsing Outline Detail.

Tracking and Reviewing Changes

  • Enabling or Disabling ‘Track Changes’.
  • Sharing, Comparing and Merging Worksheets.

Scenarios

  • Scenario Manager.
  • Scenario Summary Reports.

What If Analysis

  • Goal seek
  • Data Table

Validating

  • Whole Number; Decimal Number.
  • List; Date; Time; Text Length
  • Validation Input Message and Error Alert.
  • Removing Data Validation.

Logical Functions

  • Nestedif functions
  • And; Or and not functions

Passwords & Security Issues

  • Password Protection.
  • Password Protecting Cells and Worksheets.
  • Hiding Formulas.
  • Un-Hiding Formulas.

Match and Index functions

Lookup Functions

  • VLOOKUP with formulas
  • VLOOKUP with multiple worksheets
  • VLOOKUP with multiple worksheets
  • VLOOKUP with if error functions
  • HLOOKUP

Math & Trig

  • Sum, Sum if, Sum ifs,
  • Count,countif,countifs
  • Average,averageif,averageifs
  • Product

Macros

  • Macro with recording
  • Creating macros
  • Assigning Macros
  • Editing Macros

Payroll calculations

  • Using countif functions
  • Using sumif functions
  • Arithmatic operations
  • Using HRA,DA and TAX CALCULATIONS

Advanced Filters

  • Using multiple criterias
  • Using multiple datas
Enquire About The Course

    Related Courses

    Certification
    Career Guidance
    Trained by Experts
    Cooperate Project Training

    Student Testimonials

    I have done Arabic language training at Spoton Training Institute. The Trainer Mr. Ahmed Moosa is an awesome personality with good patience. He delivered the best as expected.

    ratings
    Althaf Noor
    Student, Spoton Institute

    I learned Advanced Excel courses in Spoton training Institute. it is more practice sessions and information from them.
    Thank you Spoton!

    ratings
    Menbere Tekaligne
    Student, Spoton Institute

    The training was clear and detailed and best instructor.  I like graphic designer course, Their training contains many of Practice Sessions.  I did thank you spot on institute

    ratings
    Roman Reigns
    Student, Spoton Institute

    I did my MS OFFICE course in spot on and was very impressed with their team and especially Nandini mam who taught me in a way that, I highly recommend because they are Spot on.

    ratings
    Mercy Rajam
    Student, Spoton Institute

    I had great learning experience in Spoton Training Institute. Like; professionals trainers, very supportive staff. I done my 2D & 3D AUTOCAD with this Institute. Thank You Spot on.

    ratings
    Sachin Bhagwat
    Student, Spoton Institute

    CANDIDTES WHO WANTS TO EXPERT IN ADVANCED EXCEL

    Frequently Asked Questions?

    • To communicate effectively
    • To face for the interviews 
    • To find a better job opportunity
    • To speak with different nationalities
    • We engage the students in more practical sessions with our certified trainers.
    • Online and offline
    • We have Cambridge certified trainers with corporate level experienced.
    • You will get more practical knowledge than theory.
    • You will be trained by experts.
    • You will get both institutional certificate and the KHDA certificate.
    • Spoton provides you the facility to schedule the classes according to your availability.
    • You will get the study materials to study further.
    • This course is about how we use the English theoretical knowledge into practice.
    • The Course is designed approximately one and half months.
    • The duration can be adjustable according to your needs.
    • If you need to complete the course as soon as possible we can provide you for fast track.
    • It will depend on the student’s and the trainer’s availability.
    • You can select any three days including both weekdays and weekends.
    • Timing will be flexible ( 2 hours per day)
    • It is open from 9.30am-9.00pm

    We offer two certificate:

    • Institutional certificate
    • KHDA certificate (Knowledge & Human Development Authority of Dubai)

    Contact Us

    Enquire the Courses Now !