Microsoft Excel (Advanced)

  • Address: 201, Al Tawhidi 2, Mankhool Street, Mankhool - Dubai, UAE (Map)
  • Tel: Show Number

Inquiry

Microsoft Excel is a spreadsheet program used to store and retrieve numerical data in a grid format of columns and rows. Excel is ideal for entering, calculating and analyzing company data such as sales figures, sales taxes or commissions. Advanced Microsoft Excel training is for those people who know Excel already and is designed for students to gain advanced skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros (Optiona) etc.

Course Structure

  • Basic Functions
  • Sumif, Countif, Sumifs, Countifs
  • Pivot Table & Pivot Chart
  • Data Validation
  • Goal Seek
  • Hyperlink
  • Print Titles
  • Name Manager
  • Custom List
  • Advanced Filter
  • Scenario Manager
  • Quick Access Tool Bar
  • Header And Footer
  • Formulae Auditing
  • Vlookup & If error
  • Conditional Formatting
  • Subtotal, Group, Ungroup
  • Data Table
  • Remove Duplicates
  • Consolidation
  • Watch Window
  • Text To Columns
  • Custom Views
  • Comment
  • Paste Special
  • Track Changes

We at Rolla Academy want to empower the students. This will eventually make them great assets for the organization they are working in or the ones they aim to work in the future. Our courses are student centric and so are our timings. We understand that the professionals have a busy schedule and thus we alter us according to them. Students are free to choose the timings for their classes. To attend the classes at your convenience, book your batch now.

Community Rating

Studied or Worked here? Share Your Review

Your email address will not be published. Required fields are marked *

Please do not post:

  • Aggressive or discriminatory language
  • Profanities (of any kind)
  • Trade secrets or confidential information

Thank you once again for doing your part to keep Edarabia the most trusted education source.

Similar Courses to Advance Your Career

Artificial Intelligence (AI) in Real Estate Development & Facilities
Artificial Intelligence (AI) in Real Estate Development & Facilities
  • USD 4,250
Inquire
Artificial Intelligence (AI) Strategy & Leadership Program
Artificial Intelligence (AI) Strategy & Leadership Program
  • USD 4,250
Inquire
Artificial (AI), Business and the Future of Work
Artificial (AI), Business and the Future of Work
  • USD 4,250
Inquire
Artificial Intelligence (AI) for Admins
Artificial Intelligence (AI) for Admins
  • USD 4,250
Inquire
Cyber Security Audit
Cyber Security Audit
  • USD 4,250
Inquire
Cyber Security Risk Management
Cyber Security Risk Management
  • USD 4,250
Inquire