tipsClassroom apmācība
datumsSeptembris 9, 2017
Laiks2 dienas
REGISTER
MS Excel apmācība

Pārskats

Priekšzināšanas

Kursa plāns

Grafiks un maksa

sertifikācija

MS Excel mācību kursi un sertifikācija

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-birojs 2007 / 2010 / 2013 un 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

Priekšzināšanas

Kandidātiem jāzina datora pamatzināšanas.

Course Outline Duration: 2 Days

  1. Darbgrāmatas un darblapu pārvaldīšana un formatēšana
    • Izklājlapu un darbgrāmatūru pārvaldīšana un izveide
    • Aplūkojiet tās pašas Excel lapas vairākās cilnēs
    • Ieslodzīt augšējo rindu vai pirmo kolonnu, izmantojot iesaldējumus
    • Labākās laika taupīšanas metodes lapas iestatīšanas iespēju pārvaldīšanai
    • Dažādas formatēšanas metodes kopā ar nosacīto formatēšanu, pamatojoties uz vērtībām, dublētām ierakstiem, datu bāzēm utt
  2. Padarīt Excel atskaites, izmantojot dažādas formulas, funkcijas un atsauces
    • Teksta funkcijas, piemēram, Len, Concatenate, augšējā, apakšējā, Proper & Trim.
    • Loģiskās funkcijas, piemēram, Ja un vairāki Ja
    • Matemātiskās funkcijas, piemēram, Sum, Abs, Round, Roundup un Rounddown
    • Statistikas funkcijas, piemēram, Count, Counta, Countblank, Countif, Countifs, Sumif, Sumifs, Vidējais, Averageifs, Min, Max, maziem un lieliem
    • Uzmeklēšanas funkcijas, piemēram, Vlookup un Hlookup par precīzu un aptuvenu atbilstību
    • Šūnu adreses iesaldēšana formulā, ievietojot $ zīmi (Absolūtā atsauce)
    • Vairāku lapu un darba grāmatu saistīšana formulā (3D atsauces)
  3. Darbs ar datiem
    • Pielāgoto sarakstu izveidošana un mainīšana
    • Datu atdalīšana, izmantojot tekstu uz kolonnām
    • Datu sakārtošana alfabēta secībā atsevišķos un vairākos laukos
    • Datu sakārtošana pielāgotajā kārtībā, importējot sarakstus
    • Datu sakārtošana no kreisās uz labo pusi
    • Datu izvilkšana, izmantojot filtrus un avansa filtrus (skaitļu filtri, teksta filtri, datuma un laika filtri, unikālie ieraksti, dublēti ieraksti un krāsu filtrēšana)
  4. Analizējot datus, izmantojot pivot tabulas
    • Labāko izkārtojumu izvēle un lauku pievienošana
    • Pielietojot vairākas funkcijas pivot tabulās
    • Tukšo šūnu reklāmguvumi un kļūdu vērtības ar 0
  5. Datu atspoguļošana grafiskā formā
    • Labāko diagrammu izvēle atbilstoši datiem
    • Izmantojot kolonnu diagrammas, joslu diagrammu, rindu diagrammas un rindu diagrammas
    • Formatēšanas diagrammas, pievienojot diagrammas nosaukumus un mainot diagrammas atrašanās vietas
    • Diagrammu saistīšana ar Word un PowerPoint
  6. Darbs ar Excel Excel funkcijas
    • Veicot meklēšanu labajā laukā, nevis pa kreisi
    • Veicot meklēšanu vairākās tabulās ar dažādiem nosacījumiem
    • Veicot meklēšanu vairākos laukos
    • Veicot ar lietu saistītu meklēšanu
    • Apvienojot horizontālo un vertikālo meklēšanu, izmantojot atbilstības un indeksa funkcijas
    • Datuma funkcijas, piemēram, Today, Now, Day, Month, Year, Workdays & Networkdays
    • Statistikas funkcijas, piemēram, Median un Mode
  7. Darbs ar diapazona un nosaukumu konvenciju
    • Nosaukuma lietošana šūnu un šūnu diapazonam
    • Mainot, dzēš diapazona vārdus un automātiski izveidojot vārdus, pamatojoties uz virsrakstiem
  8. Datu apstrāde
    • Excel datu apvienošana ar Word dokumentiem, PDF failiem un ārējiem objektiem, izmantojot hipersaites
    • Datu importēšana no ārējiem avotiem, piemēram, teksta faili, CSV faili utt
    • Datu atspoguļošana labākā struktūrā, izmantojot tabulas
    • Dublikātu noņemšana no Excel datiem
    • Ātru informācijas paneļu / veidņu veidošana, ierobežojot konkrētus datus, izmantojot datu validēšanu
    • Informācijas paneļu / formu aizsardzība, izmantojot lokšņu un atbloķēšanas lapu īpašo daļu
    • Konsolidējot pārskatus no dažādām darbgrāmatām, izmantojot datu apvienošanu
  9. Excel datu analīze
    • Starpsvars tiek piemērots, lai analizētu datus vienā un vairākos laukos
    • Excel datu grupēšana un izgrupēšana apvienotajās tabulās
    • Pievienoto aprēķinu lauku pivot tabulās
  10. Ko darīt, veicot analīzes rīkus
    • Ievades vērtības aprēķināšana, pamatojoties uz izejas vērtību, izmantojot Mērķa meklēšanu
    • Analizējot datus, izmantojot vairākus scenārijus, izmantojot Scenarios Manager
  11. Uzdevumu automatizācija un grafiskais attēlojums (atkarībā no laika pieejamības)
    • Pārstāvot datus, apvienojot kolonnu un rindu diagrammas vairākās asīs
    • Pārstāvot Pie Pie Piezīmes diagrammas vai Bar Pie Piezīmes diagrammas datus
    • Uzdevumu uzlabošana, izmantojot tastatūras saīsnes
    • Uzdevumu automatizācija, ierakstot makrosus
    • Saglabājiet darbgrāmatas ar Macro Compatible opcijām

Lūdzu, rakstiet mums pa info@itstechschool.com un sazinieties ar mums pie + 91-9870480053 par kursa cenu un sertifikācijas izmaksām, grafiku un atrašanās vietu.

Drop Us Query

Lai iegūtu vairāk informācijas laipni Sazinieties ar mums.

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.


atsauksmes



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.


atsauksmes



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



MSExcel kursa saturs ir norādīts zemāk