Azure Devops

Students will learn DSUM and table formatting in Excel. 
  • Hours and mode: 16 hours & VILT
  • Hands-on available?: Yes
  • Assessments or certification available: Assessment Available
  Get Enterprise Training on Azure Devops for Your Teams 

6 Hrs

Live Session

12 Hrs


10 Hrs

Hands-On Practice

23 Hrs

Batches Conducted

Request a Quote

Your Learning Advisor will get back to you within 24 hours

Organizational Benefits of Training on "Azure DevOps"


Improved Collaboration

Quality Improvement

Enhanced Productivity

Cost Efficiency

Benefit 2

Benefit 4

Request a Quote

Your Learning Advisor will get back to you within 24 hours

Course Contents


  1. Excel Interface
  2. Navigation Methods
  3. Terminologies
  1. Introduction
  2. Types of formulae
  3. Function basics
  4. Function syntax
  5. Function examples quick recap
      i) Sum, count, max, min, average
  6. Addressing methods revisited
  1. If statements
    • i)Simple
  2. And , Or functions
  3. Vlookup, Hlookup
  4. Count family functions
  5. Statistical functions
  1. Formula based conditional formatting
  1. Auto filters
  1. Introduction – concepts
  2. Modifying a pivot table
  3. Sorting, filtering pivot data
  4. Top n items
  1. Creating Subtotals/Nested Subtotals
  2. SUBTOTALS Formula
  1. Consolidating Data with Identical/Different Layout
  1. Introduction
  2. Creating bi-Axis Charts
  3. Changing chart data
  4. Creating bi charts

Request this curriculum for your organization or explore customizations.

Trainer Details 

X years experience
X batches trained
Conducted trainings at A, B, C

Why Train With Techademy? 

On-demand mentoring

1-on-1 sessions with 10,000+ industry experts 

Practical application

Hands-on labs and role-based assessments

Detailed analytics

Fine-grained insights with OneProfile 

Multiple modes

In-person, online, or blended learning 

What our learners have to say about this training 

Arun KK is a seasoned professional with over two decades of experience in the IT industry. Throughout his illustrious career, Arun has adeptly navigated diverse roles, showcasing his versatility and expertise. With a rich background in customer-facing responsibilities, as well as in delivery and operations, Arun has consistently demonstrated

-Philip Samuel

Creative copy writer

We're trusted by the best