Team iTAS

iTAS  Institute for Analytics & Reporting App for complete Training on Analytics & Reporting

Course available for lifetime after purchase

Who can do this Course?
- Who want to learn Excel in-depth from Beginners to Advanced
- Who uses Excel on a regular basis
- Who have basic Excel skills and but would like to become more proficient in data exploration and analysis
- Students looking for a comprehensive, engaging, and highly interactive approach to training
- Anyone looking to pursue a career in data analysis or business intelligence

Prerequisite
- Basic Computer Knowledge

Microsoft Excel
Excel is a spreadsheet application developed and published by Microsoft. It is part of the Microsoft Office suite of productivity software. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications (VBA).

The entire course contains following topics
- Introduction
- Spreadsheet Principles
- Understanding Screen Layout
- Creating List
   -- Auto List
   -- Custom List
- Various PasteSpecial Options
- Understanding References
   -- Relative References
   -- Absolute References
   -- Mixed References
- Functions & Formulas
   -- Basic Functions
   -- Text Functions
   -- Date & Time Functions
   -- Logical Functions
   -- Conditional Functions
   -- Mathematical Functions
   -- Lookup Functions
   -- Referring Data from Different Worksheet & Workbook
   -- Formula Errors
   -- Formula Auditing
- Name Range
   -- Static Range
   -- Dynamic Range
- Sorting Techniques
- Filtering Techniques
- Formatting Techniques
   -- Basic Formatting
   -- Conditional Formatting
   -- Number Formatting
- Understanding Data Tools
   -- Data Validation
   -- Group and Outline
   -- Text to Columns
   -- Remove Duplicates
   -- Flash Fill
   -- Data Consolidation
- Hyperlink
   -- Linking Sheets
   -- Linking Files
- Charts & Graphs
- Understanding Sparklines
   -- Line
   -- Column
   -- Win/Loss
- Working with Tables 
   -- Tables
   -- Pivot Tables
   -- Pivot Charts
   -- Change Data Source
   -- Slicers
   -- Timelines
   -- Relationship
- Protecting Sheets & Files
- Printing Techniques
- Understanding Various Excel Window Techniques
- Viewing Excel Spreadsheet in various Layouts
- Templates Themes

Note : The entire Course will be Practical with Real time examples which the Companies using and implementing.

Advanced Excel

U2FsdGVkX1/LSDwotg7EttWRTrVkF1RvbZAuZWRKMy8=

This Video Contains Course Plan and Contents of Advanced Excel Course

Session 01 - Course Plan and Contents

U2FsdGVkX1882ynUxpVoVnIdRual/hreEikTXy2YGR4=

The New Features of MS Excel 365

iTAS - Learning App

Maharashtra

Hey! I’m learning with iTAS - Learning App and you can too. Here’s a course you might like: Advanced Excel by Team iTAS
    https://dwltp.courses.store/127589?utm_source=whatsapp&utm_medium=social&utm_campaign=web-course-share

Hey! I’m learning with iTAS - Learning App and you can too. Here’s a course you might like: Advanced Excel by Team iTAS
    https://dwltp.courses.store/127589?utm_source=facebook&utm_medium=social-fb&utm_campaign=web-course-share

Hey! I’m learning with iTAS - Learning App and you can too. Here’s a course you might like: Advanced Excel by Team iTAS
    https://dwltp.courses.store/127589?utm_source=telegram&utm_medium=social&utm_campaign=web-course-share

Hey! I’m learning with iTAS - Learning App and you can too. Here’s a course you might like: Advanced Excel by Team iTAS
    https://dwltp.courses.store/127589?utm_source=linkedin&utm_medium=social-link&utm_campaign=web-course-share

Hey! I’m learning with iTAS - Learning App and you can too. Here’s a course you might like: Advanced Excel by Team iTAS
    https://dwltp.courses.store/127589?utm_source=copy-link&utm_medium=social&utm_campaign=web-course-share