Advanced MS Excel

حول هذه الدورة

Participants will learn to use advanced functions of Excel to improve productivity, enhance spreadsheets with templates, charts, graphics, and formulas and streamline their operational work.
They will apply visual elements and advanced formulas to a worksheet to display data in various formats. Participants will also learn how to automate common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and leverage on Excel’s advanced functionality to simplify and streamline their day-to-day work.

مناطق تحسين مسيرتك المهنية

At the end of this course, the participants are expected to be able to:
Understand the use of Excel’s advanced Functions
Gain Insights from vast array of data with ease
Make powerful dashboards
Analyse data like a professional
Understand shortcut techniques for faster and efficient use of Excel

ما الذي سوف تتعلمه؟

  • Working with Formulae and Functions:-
  • Introducing Formulae and Functions
  • Creating formulae that manipulate text
  • Working with Dates and Times
  • Creating Formulae that Count and Sum
  • Creating Formulae that Look Up Values
  • Creating Formulae for Financial Applications
  • Introducing Array Formulae
  • Performing advanced tasks with Array Formulae
  • Using advanced Excel features:-
  • Customizing the Excel User Interface
  • Using Custom Number Format
  • Using Data Validation and Text to Columns
  • Creating and Using Worksheet Outlines
  • Linking and Consolidating Worksheets
  • Excel and the Internet
  • Sharing Data with Other Office Applications
  • Using Excel in a Workgroup
  • Protecting Your Work
  • Making Your Worksheets Error-Free
  • Creating Charts, Graphics and Dashboards:-
  • Getting Started Making Charts
  • Learning Advanced Charts
  • Visualizing Data Using Conditional Formatting
  • Creating Sparkline Graphics
  • Enhancing Your Work with Pictures and Drawings
  • Maintaining and creating advanced dashboards
  • Analyzing data with Excel:-
  • Getting Data from External Database Files
  • What-if Analysis
  • Data Validation - advanced
  • Introducing Pivot Tables
  • Analyzing Data with Pivot Tables
  • Analyzing Data Using Vlookup
  • Analyzing Data Using Hlookup
  • Maintaining and creating Dashboards
  • MACROS:-
  • Basics of Macros Project procurement management
  • Project stakeholder management

التعليمات

المتطلبات الأساسية
None
المدة
4 Days
من يتعين عليه التسجيل؟
  • A must for every professional from entry to senior level managers in any industry:-
  • Engineering & IT graduates BTech/ BE
  • BSc-IT
  • BCA
  • MCA
  • MSc-IT etc
  • Management graduates – MBA
  • BBA
  • For students aspiring for entry level jobs in any domain this is mandatory.

لمحة عامة

Manipal University
نوع الدرس:
دورة تدربية معتمدة‎
نمط الدراسة:
قاعة دراسية
المكان:
Dubai Knowledge Village
التكاليف:
$385
الشهادة:
Certificate in Advanced MS Excel
التاريخ:
31/07/17


سيتم الحفاظ على سرية معلوماتك وإرسالها مباشرة إلى الكلية.