Spreadsheet Principles
Screen Layout and Excel Basics Entering, Selecting and Editing Data Formatting Cells, Range, Sheets Printing Techniques
Creating Formulae and Functions Advance Lookup Formulas
Advance Sorting Techniques Advance Filtering Techniques Applying Data validation rules Dynamic Ranges
Linking Sheets and Files
Conditional Formatting
Group and Outline
Data Form
Data Consolidation
Dynamic Charting Techniques
Using Sparkline (Line, Column, Win/Loss) Summarizing Data with Pivot Tables
Using Slicers for Effective Filtering
Pivot Chart Sharing Files Protecting Files
Protecting cells, sheets, files
Introduction to Macros
Templates Themes
Tips & Tricks

Reviews

Be the first to write a review about this course.

Write a Review

"iTech Analytic Solutions" (iTAS) is a Professional training institute contributing towards the requirement of current IT & NON IT industries. iTAS provide trainings on Advance Excel, Visual Basic Applications (VBA), Dashboard Designing, Automation, Tools & Reporting, MS Access, MS Word, MS PowerPoint, SAS, SQL Server, MSBI Tools, Analytics, Statistics.

Why iTAS (iTech Analytic Solutions)?
> Training courses are practical and hands-on, will have lots of opportunities to practice new skills
> Learn how to create robust VBA applications like Automation, Dashboards, Reporting Tools
> Advanced Charting Techniques, Other unique tips to work on Excel, VBA, SAS, Access Projects
> Trainings are designed to solve the real time problems facing by Professionals
> iTAS (iTech Analytic Solutions) NOT ONLY TEACH, MAKE YOU EXPERT

Mobile : 9902058793, 90660678793, 9066078793
email: [email protected], [email protected]
website : www.itechanalyticsolutions.com

View Complete Profile

Financial Management Office Application & Computer System