Call nowContact us
  •  

     

    Advance Excel Course

    Course Duration : 40 Hrs, Course Fee : 5000

    Advance Excel Course

    Advance Excel Course with International Microsoft Certification. The course includes more than 250 formulas, 100+ Assignments, Customized Notes, International Certification from Microsoft (MOS) and Placement assistance.

    advance excel course

    Call at +91-72899 89188 or mail at info@aclm.in 

    Rated 4.8 out of 5.0, in India. 40 Hours Training will help you for 40 Years in your work. The Advance Excel Course is available online as well as offline mode.

    Advanced Excel Course majorly covers the data handling along with automating our daily routine work with the help of customized excel formulas and functions. The in-depth training will enable to you write your own complex formulas with the mixture of other formulas and functions.

    The customized training on Advance Excel is designed in such a way that the people from the diverse fields can have in-depth technical knowledge of the tools and techniques to develop a customize Excel based report.

    Pearson-VUE-Authorized-Test-Center-logo-US_footer“Turning Motivated Individuals into Office Superstars” is our main concern overall training. The primary focus of making individuals ready at par with the technology makes organization more reliable over their existing members and making their arm stronger.


    ACLM, Known for the MIS Training institution, successfully completed more than 6000 training including corporate as well as individual training. Our MIS page on well known social platform facebook is increasing gradually and the posts are liked by all friends. Our area of services includes globally via online live classes. The batch strength would be 15-20 person each group.

    KEY FEATURES

    • 50+ assignments, Custom notes on Advance Excel and its various properties
    • Command on more than 250+ formulas
    • Flexibility to avail Regular as well as Weekend Classes
    • For fast learners, daily classes of up to 5 hours of each class
    • Test and Mock Interview Sessions for Interview Preperations
    • Exposure on Real time work environment

     

    Topics Covered

    EXCEL PART
    • Focus on real scenarios of Reporting / Data Management / Automation, Difference between basic and advance Excel, Excel Basics, Excel Settings, Advanced Formulas, Name Manager, Absolute and Relative references, field setting, Goal Seek / Scenario manager, Managing custom Lists, Cross addressing.
    • Excel Ribbon, Setting and Options
    • Excel File System (Exporting and Handling Files)
    ADVANCE EXCEL PART
    • Conditional formatting, Data Validation, Consolidation, Grouping and Sub Grouping, User Settings for Excel Application Level, Data Management and Analysis, Reporting Techniques, Pivot Table, Power Pivot, Macros, List box, Combo box, Buttons etc.
    Set of Important Formulae and related assignments
    • Logical Function Sets - And, Or, Not, Nand, Nor, Xor, True, False, Iferror, Iserror, Iserr, Isna, Isblank, Istrue, IsFalse, IsNumber, IsText, IsEven, Isodd, IsLogical
    • Usage of Operators - Logical Operator, Arithmetic Operator, Assignment Operator and Unary Operators
    • Text Function Set - Upper, Lower, Proper, Left, Mid, Right, Concatenate, Char, Code, Find, Search, Replace, Substitute, trim, text value, Text set, T, BahtText. The array formulae including various other text functions
    • Date & Time Function Set - Date(), Day, month, Year, time(), Hour, minute, second, Datedif, Datevalue, Time Value, Weeknum, Weekday, Age Calculator, Usage of scientific and moderate calculator, Days360, General Date Diff, EDate, EOmonth, Workdays, Workdays.intl, Networkdays, Networkdays.intl, now, Today, Yearfrac
    • Lookup and References set - Address, Area, Choose, Vlookup, Hlookup, Lookup, Reverse Lookup, Index, Match, Row, Rows, Column, Columns, Get Pivot Data, Hyperlink, Indirect, offset, Transpose, RTD
    • Mathematical Function - General Use Function - Sum, sumif, Sumifs, Count, countif, Countifs, Average, Averageif, Averageifs, Product, Sumproduct, Sumproduct Array Formula, Round, Roundup, Rounddown, Floor, Ceiling, INT, Sqrt, Power, Subtotal, Fact, Even, Odd
    • Conditional Statement - If, If else, if else if (nested if), if with operator, if with the use of text functions, if with the use of numbers, if with date function, if with time functions
    DATA FILTERING / DATA FORMATTING
    • Understanding Different Data Types, Using String / Text / Number / Long Data Types with examples, Managing Date Time Format, Handling Long Date time Format, Data Correction, Identifying bad data, Conversion of different data types, Importing and accessing different file types in excel
    ADVANCE EXCEL SECURITY
    • Protecting Excel File, Protecting worksheet, Workbook, Enable / Disable Range, Allow users to edit range, Protecting users to edit range, Field Controls using customized user access.
    USING CHARTS  / GRAPHS / PIVOT CHARTS / PIVOT TABLE
    • Setting Data Source, Getting Charts / Graphs using Referential fields, Getting ACCESS Data Getting Other Data
    Projects, Assignments and Certifications
    • Opportunity to work on live project on data reporting
    • 100+ assignments
    • Certificate of participation from ACLM - AISECT
    • Certification from Microsoft
     

    Who Should Attend

    • Freshers
    • Data Entry professionals
    • Any one looking for career opportunity in data analytics and reporting fields

    Pre-requisites

    • Basic Knowledge of Excel, Candidate's having some programming background will have an added advantage

    What You Need To Bring

    • Notepads, Laptops / Notebooks (Up to your choice)

    Key Takeaways

    • Various technique with the help of Excel, Generate different Analytical Process. Data handling and correcting bad data with the help of Excel, Reporting and Formatting with different angles, Macro generation and application design

    About Trainer

    • Having 17+ Years of Experience in Data Analysis, Clinical Data Research, Data Mining and Presentation
    • Delivered more than 100+ VBA Projects (onsite & offsite)
    • Real time exposure of data Analytics, Python Data Science, Tableau and SAS clinical research.


    Admission Form

    admission form aclm

    have a question?

    PAY FEE ONLINE BY :

    Schedule

    26
    Oct
    Online Python Data Science – 30% off till 25th Oct
    register
    26
    Oct
    SQL Server Workshop
    register
    26
    Oct
    Digital Marketing Workshop
    register
    26
    Oct
    Python Workshop
    register
    26
    Oct
    Free Core Java Workshop
    register