Hidden Secrets in Data Analysis With Excel everydayExcel Business Lab Pte Ltd
السعر: 600 SGD

    تفاصيل الدورة

    Managers and Executives who have to manage, analyse and prepare reports using data downloaded from systems. They must have some basic to intermediate knowledge of Excel i.e. navigate around a worksheet, format cells, auto-filter, sorting, create a simple template and enter simple formulas (e.g. SUM) into the worksheet.

    Learning Objectives

    Upon completion of the course, participants will be able to:

    • Apply useful built-in functions in Excel to process data and enhance the usefulness of the data.
    • Apply the function learnt to consolidate records.
    • Acquire skills to analyse the records for operations and reporting purposes.
    • Employ new ways of tabulating and managing data.

    Course Outline

    • Manage The Use of Dates
    • MONTH, YEAR, DAY, DATE, COUNTIF, SUBTOTAL, DATEDIF formula, Advanced Auto-Filter Function, Absolute and relative reference
    • Quick and Accurate Way to Select Records
    • GOTO function
    • Building Complex formulas
    • MID, SEARCH
    • Merging 2 Lists into One
    • VLOOKUP formula, SUBTOTAL, REPLACE ALL function
    • Unleashing The Power of Formulas
    • SUMIF Formula, TEXT TO COLUMN Function
    • Analyzing Business Data in Double Quick Time
    • PIVOT TABLE function
    • Making Your Report Update Automatically
    • MS Query Function
    • Consolidate Data From Multiple Workbooks
    • MS Query Function
    • Tapping the Power of Pivot Chart
    • Recording Macros to Speed Up Repetitive Tasks
    تحديث بتاريخ 08 November, 2015

    نبذة عن معهد everydayExcel Business Lab Pte Ltd

    everydayExcel Business Lab is a training company offering Professional Microsoft® Excel CThierses with a Business Perspective. They tailor-made Excel cThierses for busy Executives and Managers who do not have the time to explore the various uses of formulas and functions to solve real business problems in sales and marketing, human resThierce, administration, business development, etc.

    عرض الجميع دورات everydayExcel Business Lab Pte Ltd
    Are you from everydayExcel Business Lab Pte Ltd ? Claim your course!
    دورات يمكنك الالتحاق بها على الفور... خذ دورة عبر الإنترنت على Business Analysis ابتداءً من الآن. See all courses

    هل هذه الدورة التدريبية الاختيار المناسب لك؟

    قيِم هذه الصفحة

    لم تجد ما كنت تبحث عنه؟

    أو