A Premier IT Software & Hardware Networking Training Institute

Home
/
Сourses
/
Short Term Courses
/
Advanced MS Excel
/

Advanced MS Excel

  • Short Term Courses

The most commonly used product of Microsoft Office is Excel. Proficiency of Microsoft Excel lies in data entry, data analysis, data presentation and calculation. You can master excel depending on your skill level. Whether a beginner or advanced level, it is easy and efficient for all categories of users.

Course Content

  • New features of MS Excel 2013
  • Customization of the Ribbon and Quick Access Toolbar
  • How to add data by using Flash Fill, Auto Fill and Auto Complete?
  • Proofing and Management of Add-ins
  • Built-in and custom templates in Excel
  • Protecting worksheets by locking and unlocking cells
  • Protection, finalization, and encryption of a workbook
  • Concept of shared workbooks
  • Process of recovering the unsaved version of a file
  • Process for tracking change in a shared workbook
  1. Trace Formula precedents and dependents
  2. Use Data Validation tools to check errors in file
  3. Implementation of iterative calculations
  4. Using Single Cell and Multi Cell array formula
  5. Use SUMIFS(), COUNTIFS(), and basic counting functions
  6. Quick Analysis tool for Data Analysis
  7. Data Consolidation
  8. Use of statistical functions
  9. Logical and Look-up functions
  10. Conditional Formatting
  1. Different types of Charts and their importance
  2. Use of Recommended Charts
  3. Modification of Chart Elements, Chart and Plot Area and Chart Axes
  4. Formatting of Chart title, legend and rigid lines
  5. Trendline and Data Series
  6. Dual axes and chart templates
  1. Conditional Formatting
  2. Process to list and create sparklines
  3. Importance of Pivot Table and its features
  4. Process to create recommended Pivot Tables
  5. Concept of Pivot charts and steps to create it
  6. Concept of Slicers and the steps to create it
  7. Process to use Power View
  1. Analysis ToolPak
  2. Single and two factor tool without replication
  3. Correlation and Covariance
  4. Two sample F-Test for Variances
  5. Histogram and Moving Average
  6. Random Number Generation
  7. Regression, Sampling, Rank and Percentile
  8. Exponential Smoothing
  1. Automatic Data Processing
  2. How to create and run a macro?
  3. Assigning macro to a command button
  4. Creation of a custom macro button on the Quick Access Toolbar
  5. Macro Security
  6. Macro Add-ins
  7. Form Controls
  8. Using of solver, subtotal, goal seek, and scenario
  9. Process to import and export XML

Get a Consultation

Course Duration

Advanced MS Excel is a 2- months course. Classes are held 2 hours a day to 3 days a week.

Eligibility

Basic Excel Knowledge required

Job Opportunities

On successfully completing the Advanced MS Excel, you will be a market ready professional to join top national and international IT Companies as a Financial Analyst

Interested to join our Advanced MS Excel Course?

Fill out the enquiry form below to schedule a free call from our career experts

Contact Us

*Note: Fees and Duration may be different based on the course and centre location. To get a detailed know-how contact us today.

Our Success Stories

“
Et netus et malesuada fames ac turpis egestas sed. Nec feugiat nisl pretium fusce id velit ut. Lobortis mattis aliquam faucibus purus in. Ultricies integer quis auctor elit sed. Lobortis scelerisque fermentum dui faucibus in ornare quam. In mollis nunc sed semper
Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Et netus et malesuada fames ac turpis egestas
Ray Cooper
Founder of colab courses, lecturer

Flexibility in Planning and Teaching

Theoretical Knowledge

Practical Skills

Individual Work with a Mentor

Final Individual Project

Facebook-f Instagram Twitter Whatsapp

Links

Courses

NEWSLETTER

Aptech Learning Baguiati ©  All rights reserved Copyrights 2024