Advanced Excel Course

by Thirdeye Computer Classes Claim Listing

Advanced Excel refers to high proficiency in using Microsoft Excel, focusing on sophisticated features and functions beyond basic spreadsheet operations. Advanced Excel skills are crucial for data analysis, financial modeling, reporting, and decision-making.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Thirdeye Computer Classes Logo

img Duration

Please Enquire

Course Details

Advanced Excel refers to high proficiency in using Microsoft Excel, focusing on sophisticated features and functions beyond basic spreadsheet operations. Advanced Excel skills are crucial for data analysis, financial modeling, reporting, and decision-making in various business and professional contexts.

 

Content:

  • WORKING WITH FUNCTIONS
  • Writing conditional expressions (using IF)
  • Using logical functions (AND, OR, NOT)
  • Using lookup and reference functions (LOOKUP, HOOKUP, MATCH, INDEX)
  • VlookUP with Exact Match, Approximate Match
  • Nested VlookUP with Exact Match
  • VlookUP with Tables, Dynamic Ranges
  • Nested VlookUP with Exact Match
  • Using VLookUP to consolidate Data from Multiple Sheets
  • DATA VALIDATIONS
  • Specifying a valid range of values for a cell
  • Specifying a list of valid values for a cell
  • Specifying custom validations based on the formula for a cell
  • WORKING WITH TEMPLATES
  • SORTING AND FILTERING DATA
  • Sorting tables, Using multiple-level sorting, Using custom sorting
  • Filtering data for selected view (AutoFilter), Using advanced filter options
  • WORKING WITH REPORTS
  • Creating subtotals, Multiple-level subtotals
  • Creating Pivot tables, Formatting, and customizing Pivot tables
  • Pivot charts
  • Consolidating data from multiple sheets and files using Pivot tables
  • Using external data sources
  • Using data consolidation feature to consolidate data
  • Show Value As (% of Row, % of Column, Running Total, Compare with Specific Field)
  • Viewing Subtotal under Pivot
  • MORE FUNCTIONS
  • Date and time functions
  • Text functions
  • Database functions
  • Power Functions (CountIf, CountIFS, SumIF, SumIfS)
  • FORMATTING
  • Using the auto-formatting option for worksheets
  • Using conditional formatting option for rows, columns, and cells
  • WHAT-IF ANALYSIS
  • Goal Seek
  • Data Tables
  • Scenario Manager
  • CHARTS
  • Using Charts, Formatting Charts, Using 3D Graphs
  • Using Bar and Line Chart together, Using Secondary Axes in Graphs
  • Sharing Charts with PowerPoint / MS Word, Dynamically
  • (Data Modified in Excel, Chart would automatically get updated)
  • Jaipur Branch

    35 First Floor Above Hdfc Bank Near Sanganer Stadium Nagar Nigam Road Sanganer, Jaipur

Check out more MS Excel courses in India

Heet Computer Education Logo

Certificate In Ms Office

Certificate in MS Office course is offered by Heet Computer Education. Heet Computer Education aims to provide quality education and training in computer science and related disciplines to students and professionals who want to enhance their skills and knowledge in the field of IT.

by Heet Computer Education [Claim Listing ]
  • Price
  • Start Date
  • Duration
Dream India Technologies Logo

MS Office

Dream India Technologies is the Best Ms Office Training Institute in Guntur. Dream India Technologies is the best Job Oriented and Placement Focused Ms Office 2019 Institute in Guntur. Our Ms Office course content created by industry experts to fulfill industry expectations.

by Dream India Technologies [Claim Listing ]
  • Price
  • Start Date
  • Duration
TechCADD Computer Education Institute Logo

Advance Excel

Advance Excel course is offered by TechCADD Computer Education Institute. We're here to help you learn and grow in the exciting field of computers and digital technology. At TechCADD, we're passionate about empowering individuals with the knowledge and skills they need to succeed in today's digit...

by TechCADD Computer Education Institute [Claim Listing ]
OCAC Training Centre Logo

Advanced Excel

Advanced Excel course is offered by OCAC Training Centre. OCAC Training Centre is a collaboration of Odisha Computer Application Centre (OCAC) and Odisha Knowledge Computer Centre (OKCL).

by OCAC Training Centre [Claim Listing ]
  • Price
  • Start Date
  • Duration
Lal Bahadur Shastri Training Center Logo

MS Access

MS Access course is offered by Lal Bahadur Shastri Training Center for all skill level. 

by Lal Bahadur Shastri Training Center [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy