نوعآموزش کلاس درس
تاریخسپتامبر 9، 2017
زمانروز 2
ثبت نام

رویدادهای نزدیک

  1. 20533 Implementing Microsoft Azure Infrastructure Solutions (15th December 2018)

    دسامبر 15 @ 9: 00 am - دسامبر 29 @ 6: 00 PM
  2. ITIL Intermediate Service Transition (ST – 22nd December 2018)

    دسامبر 22 @ 9: 00 am - دسامبر 23 @ 6: 00 PM
آموزش مایکروسافت اکسل

بررسی اجمالی

پیش نیازها

طرح درس

برنامه و هزینه ها

گواهی

دوره آموزشی MS Excel و صدور گواهینامه

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- دفتر 2007 / 2010 / 2013 و 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

پیش نیازها

نامزدها باید دانش پایه کامپیوتر را بدانند.

Course Outline Duration: 2 Days

  1. مدیریت و قالب بندی کتابها و صفحات برگزیده
    • مدیریت و تنظیم صفحات و کتابها
    • مشاهده صفحات اکسل همان در چند زبانه
    • غلظت ردیف بالا یا ستون اول با استفاده از فریزر پانل
    • بهترین روش صرفه جویی در زمان مدیریت گزینه های راه اندازی صفحه
    • تکنیک های مختلف قالب بندی همراه با قالب بندی شرطی بر اساس ارزش ها، سوابق تکراری، داده ها و غیره
  2. اکسل گزارش را از طریق فرمول های مختلف، توابع و رجوع
    • توابع متن مانند لن، پیوند، بالا، پایین، مناسب و اصلاح.
    • توابع منطقی مانند If و Multiple ifs
    • توابع ریاضی مثل Sum، Abs، Round، Roundup و Rounddown
    • توابع آماری مانند Count، Counta، Countblank، Countif، Countifs، Sumif، Sumifs، Average، Averageifs، Min، Max، Small and Large
    • توابع گرید مانند Vlookup و Hlookup در مورد بازی دقیق و تقریبی
    • بستن آدرس سلولی در یک فرمول با قرار دادن علامت $ (Reference Referencing Absolute)
    • پیوند چندین ورق و کتابچه در فرمول (Referencing 3D)
  3. کار با داده ها
    • ایجاد و تغییر لیست های سفارشی
    • جدا کردن داده ها از طریق Text to Columns
    • مرتب سازی داده ها به ترتیب حروف الفبا در زمینه های تک و چند
    • مرتب سازی داده ها در سفارش سفارشی با وارد کردن لیست ها
    • مرتب سازی داده ها در جهت چپ به راست
    • استخراج داده ها با استفاده از Filters & Advance Filters (فیلترهای شماره، فیلترهای متن، فیلترهای تاریخ و زمان، مدارک منحصر به فرد، سوابق تکثیر شده و فیلتر رنگ)
  4. تجزیه و تحلیل داده ها از طریق جداول محوری
    • انتخاب بهترین چیدمان و اضافه کردن زمینه
    • اعمال توابع چندگانه در جداول محوری
    • تبدیل سلولهای خالی و مقادیر خطا با 0
  5. نمایش داده ها در فرم گرافیکی
    • انتخاب بهترین نمودارها به عنوان داده
    • با استفاده از نمودار ستون، نمودار نوار، خط نمودار و نمودار نمودار
    • شکل دادن نمودارها، اضافه کردن عنوان های نمودار و تغییر مکان های نمودار
    • پیوند نمودارها با ورد و پاورپوینت
  6. کار با پیشرفته اکسل توابع
    • انجام جستجوی در سمت راست به جای سمت چپ
    • انجام جستجوی در جداول متعدد با شرایط مختلف
    • انجام جستجو در زمینه های مختلف
    • انجام جستجوهای حساس به حروف
    • ترکیبی از جستجوی افقی و عمودی از طریق Match & توابع فهرست
    • توابع تاریخ مانند امروز، امروز، روز، ماه، سال، روزهای کاری و شبانه روزی
    • توابع آماری مانند Median و Mode
  7. کار با محدوده و نامگذاری کنوانسیون
    • اعمال یک نام به یک سلول و محدوده سلول
    • اصلاح، حذف محدوده نام و ایجاد نام به صورت خودکار بر اساس عنوان
  8. اداره داده ها
    • پیوند داده اکسل با اسناد ورد، فایل های PDF و اشیاء خارجی از طریق لینک
    • وارد کردن داده ها از منابع خارجی مانند فایل های متنی، فایل های CSV و غیره
    • نمایندگی داده ها در یک ساختار بهتر با استفاده از جداول
    • حذف سوابق تکراری از داده های اکسل
    • طراحی داشبورد / فرم سریع با محدود کردن داده های خاص از طریق اعتبار سنجی داده ها
    • حفاظت از داشبورد ها / فرم ها از طریق قفل کردن و باز کردن بخش خاصی از ورق ها
    • ادغام گزارش ها از کتاب های مختلف با استفاده از Data Consolidation
  9. تجزیه و تحلیل داده های اکسل
    • تقسیم مقادیر برای تجزیه و تحلیل داده ها در زمینه های تک و چند
    • گروه بندی و Ungrouping داده های اکسل در جداول محوری
    • اضافه کردن زمینه های محاسبه در جداول محوری
  10. انجام اگر چه ابزار تجزیه و تحلیل است
    • محاسبه مقدار ورودی بر اساس مقدار خروجی با استفاده از Goal Seek
    • تجزیه و تحلیل داده ها با چندین سناریو با استفاده از Scenarios Manager
  11. اتوماسیون وظیفه و نمایه گرافیکی (همانطور که در دسترس بودن زمان)
    • نمایش داده ها با ترکیب ستون و خط نمودار در محور چند
    • مشارکت داده ها با استفاده از Pie of Pie chart یا Bar of Pie Charts
    • بهبود وظایف از طریق میانبرهای صفحه کلید
    • اتوماسیون وظایف با ضبط ماکرو
    • صرفه جویی در کارنامه با گزینه های سازگار با ماکرو

لطفا برای ما در info@itstechschool.com بنویسید و با ما در 91-9870480053 تماس بگیرید تا قیمت و هزینه صدور گواهینامه، برنامه و مکان

قطره ما یک پرس و جو

برای اطلاعات بیشتر با مهربانی تماس با ما.

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.


بررسی



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.


بررسی



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 در زیر آمده است