TipologiaFormazione in aula
DataSettembre 9, 2017
Tempo2 Days
REGISTRATI
Formazione MS Excel

Panoramica

Prerequisiti

Struttura del corso

Pianificazione e tariffe

Certificazione

Corso di formazione MS Excel e certificazione

Microsoft’s Excel is most commonly & powerful used tool which is used worldwide. Innovative technology solutions is having a pool of trainers on Excel who can deliver Microsoft Excel trainings from Basic to Advance level. ITS has delivered more than 1000+ batches on Excel. Delivering training on VBA for Excel is our specialization. ITS is keep on running trainings on Excel in Corporate and for individual as well. Our specially designed course on Microsoft Excel is very easy to learn and it helps to acquire skills to become proficient in excel. ITS do have trainings available on MS-office 2007 / 2010 / 2013 e 2016 as well. We are expert in Excel Online training and can be customize as per participant need. For more enquiry on Excel training, please call @ : + 91-9870480053

Prerequisiti

I candidati devono conoscere le conoscenze di base del computer.

Course Outline Duration: 2 Days

  1. Gestione e formattazione di cartelle di lavoro e fogli di lavoro
    • Gestione e impostazione di fogli e cartelle di lavoro
    • Visualizzazione degli stessi fogli Excel in più schede
    • Congelamento della prima riga o della prima colonna usando Freeze Panes
    • Migliori tecniche di risparmio di tempo per la gestione delle opzioni di impostazione della pagina
    • Varie tecniche di formattazione con formattazione condizionale sulla base di valori, record duplicati, barre dati, ecc
  2. Creazione di report Excel tramite varie formule, funzioni e riferimenti
    • Funzioni di testo come Len, Concatenate, Upper, Lower, Proper e Trim.
    • Funzioni logiche come If e Multiple Ifs
    • Funzioni matematiche come Sum, Abs, Round, Roundup e Rounddown
    • Funzioni statistiche come Count, Counta, Countblank, Countif, Countifs, Sumif, Sumifs, Average, Averageifs, Min, Max, Small e Large
    • Funzioni di ricerca come Vlookup e Hlookup sulla corrispondenza esatta e approssimativa
    • Blocco di un indirizzo di cella in una formula inserendo il segno $ (referenziazione assoluta)
    • Collegamento di più fogli e cartelle di lavoro in formula (riferimento 3D)
  3. Lavorare con i dati
    • Creazione e modifica di elenchi personalizzati
    • Separare i dati usando il testo nelle colonne
    • Ordinamento dei dati in ordine alfabetico su campi singoli e multipli
    • Ordinamento dei dati in ordine personalizzato importando gli elenchi
    • Ordinamento dei dati nell'ordine da sinistra a destra
    • Estrazione dei dati utilizzando filtri e filtri avanzati (filtri numerici, filtri di testo, filtri data e ora, record univoci, record duplicati e filtro colori)
  4. Analisi dei dati tramite tabelle pivot
    • Scegliere i migliori layout e aggiungere i campi
    • Applicazione di più funzioni su tabelle pivot
    • Conversioni di celle vuote e valori di errore con 0
  5. Rappresentare i dati in forma grafica
    • Scegliere i migliori grafici secondo i dati
    • Utilizzo di grafici a colonne, grafici a barre, grafici a linee e grafici a torta
    • Formattazione dei grafici, aggiunta dei titoli dei grafici e modifica delle posizioni dei grafici
    • Collegamento di grafici con Word e PowerPoint
  6. Funzionando con le funzioni avanzate di Excel
    • Esecuzione delle ricerche nel campo a destra anziché a sinistra
    • Esecuzione delle ricerche su più tabelle con varie condizioni
    • Esecuzione delle ricerche su più campi
    • Esecuzione delle ricerche con distinzione tra maiuscole e minuscole
    • Combinare le ricerche orizzontali e verticali tramite le funzioni di corrispondenza e indice
    • La data funziona come Oggi, Ora, Giorno, Mese, Anno, Giorni feriali e Feria
    • Funzioni statistiche come la mediana e la modalità
  7. Lavorare con Range e Naming Convention
    • Applicazione di un nome a una cella e un intervallo di celle
    • Modifica, eliminazione dei nomi di intervallo e creazione automatica di nomi sulla base delle intestazioni
  8. Gestione dei dati
    • Collegamento di dati Excel con documenti Word, file PDF e oggetti esterni tramite collegamenti ipertestuali
    • Importare i dati da fonti esterne come file di testo, file CSV, ecc
    • Rappresentazione dei dati in una struttura migliore utilizzando le tabelle
    • Rimozione di record duplicati dai dati di Excel
    • Progettare dashboard / moduli rapidi limitando i dati specifici tramite Validazioni dei dati
    • Protezione di cruscotti / moduli tramite Bloccaggio e sblocco di parti specifiche dei fogli
    • Consolidamento dei report da varie cartelle di lavoro tramite Data Consolidation
  9. Analizzare i dati di Excel
    • Applicazione di subtotali per analizzare i dati su campi singoli e multipli
    • Raggruppamento e separazione dei dati di Excel nelle tabelle pivot
    • Aggiunta di campi calcolati in tabelle pivot
  10. Esecuzione di Strumenti di analisi if
    • Calcolo del valore di input sulla base del valore di output utilizzando Goal Seek
    • Analisi dei dati con più scenari utilizzando Scenarios Manager
  11. Automazione di compiti e rappresentazione grafica (secondo la disponibilità del tempo)
    • Rappresentare i dati combinando colonne e grafici a linee su più assi
    • Rappresentazione dei contributi dei dati mediante Pie of Pie chart o Bar of Pie Charts
    • Migliorare le attività tramite scorciatoie da tastiera
    • Automazione delle attività mediante la registrazione di macro
    • Salvataggio delle cartelle di lavoro con le opzioni Macro compatibili

Per favore, scrivici a info@itstechschool.com e contattaci a + 91-9870480053 per il costo del corso e il costo, il programma e la posizione della certificazione

Lasciaci una domanda

Per maggiori informazioni gentilmente Contattaci

Microsoft Excel Training in Gurgaon | Microsoft Excel Training Institute in Gurgaon

Innovative Technology solutions provides and the only training company in Gurgaon who provides class room training on Microsoft Excel as per the customer requirement. Our training programs is specially designed for professionals or fresher’s to get placements in MNCs. Innovative Technology solutions is delivering major of IT trainings in Gurgaon and Microsoft Excel Training is one of the most demanded training. ITS offers hands on practical knowledge / practical implementation on live projects and will ensure to understand or learn the in-depth knowledge on Microsoft Excel from our Microsoft Excel Training. Our Microsoft Excel Training in Gurgaon is conducted by specialist working certified corporate trainers and professionals having real time implementation experience on Microsoft Excel.

Innovative technology solutions is well-equipped Microsoft Excel Training Center in Gurgaon. Innovative Technnology solutions is the well-known Microsoft Excel Training Center in Gurgaon with appropriate infrastructure and lab facilities. Microsoft Excel labs are online, so candidate can access the labs from home as well. Innovative Technology solutions in Gurgaon mentored more than 50000+ candidates on different IT skills and we have public batches on Microsoft Excel Certification Training in Gurgaon at very reasonable fee. We have in house trainer and course curriculum can be customized as per your requirement.

Our training labs are well equipped with Projector, computers, LAN with high speed internet to work on cloud. We also serve lunch for corporate.

Innovative Technology solutions is one of the best Microsoft Excel Training Institutes in Gurgaon with placement support.

Innovative Technology solution is corporate delivery training company and provide training to organizations like HCL, Colt, Kronos, BCG etc. working with MNC’s makes us capable to place our students in top MNCs across the globe.

Microsoft Excel Training Introduction

Microsoft Excel is one of the finest, economical and widely used Technology. Major of IT or non IT companies are using Microsoft Excel services for their cloud hosting solutions. Major of companies required the employees who are hands on Microsoft Excel. After visualizing the demand of Microsoft Excel, Innovative Technology solutions started offering Microsoft Excel training in Gurgaon for individual and Microsoft Excel training for corporates. Innovative Technology solutions do offers trainings on Microsoft Excel in classroom or online mode. Our trainers goes to Customer location and deliver training.

Why you should join Innovative Technology solutions for Microsoft Excel Training in Gurgaon

Top Reasons which makes us best among all others:

  • Best corporate trainers are delivering training.
  • 100% hands on.
  • Trainer discuss the real time challenges of industry and solutions to them.
  • Corporate trainers for Microsoft Excel training
  • Standard training curriculum as suggested by Principle.
  • Microsoft Excel training in Gurgaon available on weekend or weekday basis
  • Preparation for JOB interview or placement
  • Different payment modes are available like – online, cash, bank transfer or EMI.

Corporate training on Microsoft Excel, Corporate trainer for Microsoft Excel , Bootcamp for Microsoft Excel training. Best Microsoft Excel training in India

Innovative technology solutions is Corporate training delivery company, since 2010 and delivered 5000+ corporate batches. Innovative is one of the best trainers in India on Microsoft Excel training. Our trainers are well versed with online training solutions. Our trainer’s everyday delivers online Microsoft Excel training. Professionals from USA, UK and other countries also enrol themselves for our Online Microsoft Excel training programme. Taking online or classroom Microsoft Excel training from India is always cost effective.


Recensioni



Are you looking for Microsoft Excel Certification training in India


✓ Microsoft Excel training in Gurgaon


✓ Microsoft Excel training from India


✓ Microsoft Excel online training


✓ Microsoft Excel training


✓ Microsoft Excel classroom training


✓ Microsoft Excel certification

✓ Microsoft Excel video tutorial


✓ Microsoft Excel training in India


✓ Enterprise training on Microsoft Excel


✓ Use Microsoft Excel efficiently


✓ Microsoft Excel guide


✓ best Microsoft Excel training institutes in delhi ncr


Microsoft Excel Training in Gurgaon | Microsoft Excel Training Institute in Gurgaon

Innovative Technology solutions provides and the only training company in Gurgaon who provides class room training on Microsoft Excel as per the customer requirement. Our training programs is specially designed for professionals or fresher’s to get placements in MNCs. Innovative Technology solutions is delivering major of IT trainings in Gurgaon and Microsoft Excel Training is one of the most demanded training. ITS offers hands on practical knowledge / practical implementation on live projects and will ensure to understand or learn the in-depth knowledge on Microsoft Excel from our Microsoft Excel Training. Our Microsoft Excel Training in Gurgaon is conducted by specialist working certified corporate trainers and professionals having real time implementation experience on Microsoft Excel.

Innovative technology solutions is well-equipped Microsoft Excel Training Center in Gurgaon. Innovative Technnology solutions is the well-known Microsoft Excel Training Center in Gurgaon with appropriate infrastructure and lab facilities. Microsoft Excel labs are online, so candidate can access the labs from home as well. Innovative Technology solutions in Gurgaon mentored more than 50000+ candidates on different IT skills and we have public batches on Microsoft Excel Certification Training in Gurgaon at very reasonable fee. We have in house trainer and course curriculum can be customized as per your requirement.

Our training labs are well equipped with Projector, computers, LAN with high speed internet to work on cloud. We also serve lunch for corporate.

Innovative Technology solutions is one of the best Microsoft Excel Training Institutes in Gurgaon with placement support.

Innovative Technology solution is corporate delivery training company and provide training to organizations like HCL, Colt, Kronos, BCG etc. working with MNC’s makes us capable to place our students in top MNCs across the globe.

Microsoft Excel Training Introduction

Microsoft Excel is one of the finest, economical and widely used Technology. Major of IT or non IT companies are using Microsoft Excel services for their cloud hosting solutions. Major of companies required the employees who are hands on Microsoft Excel. After visualizing the demand of Microsoft Excel, Innovative Technology solutions started offering Microsoft Excel training in Gurgaon for individual and Microsoft Excel training for corporates. Innovative Technology solutions do offers trainings on Microsoft Excel in classroom or online mode. Our trainers goes to Customer location and deliver training.

Why you should join Innovative Technology solutions for Microsoft Excel Training in Gurgaon

Top Reasons which makes us best among all others:

  • Best corporate trainers are delivering training.
  • 100% hands on.
  • Trainer discuss the real time challenges of industry and solutions to them.
  • Corporate trainers for Microsoft Excel training
  • Standard training curriculum as suggested by Principle.
  • Microsoft Excel training in Gurgaon available on weekend or weekday basis
  • Preparation for JOB interview or placement
  • Different payment modes are available like – online, cash, bank transfer or EMI.

Corporate training on Microsoft Excel, Corporate trainer for Microsoft Excel , Bootcamp for Microsoft Excel training. Best Microsoft Excel training in India

Innovative technology solutions is Corporate training delivery company, since 2010 and delivered 5000+ corporate batches. Innovative is one of the best trainers in India on Microsoft Excel training. Our trainers are well versed with online training solutions. Our trainer’s everyday delivers online Microsoft Excel training. Professionals from USA, UK and other countries also enrol themselves for our Online Microsoft Excel training programme. Taking online or classroom Microsoft Excel training from India is always cost effective.


Recensioni



Are you looking for Microsoft Excel Certification training in India


✓ Microsoft Excel training in Gurgaon


✓ Microsoft Excel training from India


✓ Microsoft Excel online training


✓ Microsoft Excel training


✓ Microsoft Excel classroom training


✓ Microsoft Excel certification

✓ Microsoft Excel video tutorial


✓ Microsoft Excel training in India


✓ Enterprise training on Microsoft Excel


✓ Use Microsoft Excel efficiently


✓ Microsoft Excel guide


✓ best Microsoft Excel training institutes in delhi ncr



Il contenuto del corso MSExcel è riportato di seguito