FMM TRAINING PROGRAMME



268033545085FMM Institute (475427-W), Penang Branch394335252730MS EXCEL 2016(Data Analysis in Excel)28-29 September 20209.00AM – 5.00 PMTraining Venue: FMM Institute, Seberang JayaSBL SCHEMECLAIMABLE FROM PSMB00MS EXCEL 2016(Data Analysis in Excel)28-29 September 20209.00AM – 5.00 PMTraining Venue: FMM Institute, Seberang JayaSBL SCHEMECLAIMABLE FROM PSMBSynopsis The use of Excel is widespread in the industry. It is a very powerful data analysis tool and almost all big and small businesses use Excel in their day to day functioning. This course is designed to give you a working knowledge of Excel with the aim of the essential techniques for analysing data. What You Will Learn Learn how to use Number format to format data and Range Name to manage name for Excel Data Analysis. Learn how to use useful features (Format as Table, Sorting, Auto Filter) to manage large data sets. Learn how to use Conditional Formatting to make key data stand out. Learn how to use logical function (IF, AND, OR, IFS) and lookup functions (VLOOKUP, HLOOKUP, INDEX, MATCH, OFFSET, CHOOSE) to get specific data in data analysis. Learn how to use various functions (OFFSET, COUNT, COUNTA, SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS, COUNTIF, COUTIFS, SUBTOTAL) to tabulate large data sets calculation for data analysis. Learn how to use Excel Charting for various data analysis. Learn how to use Sparklines to show data trend. Learn how to use PivotTables to group and analyze your data. Learn how to use Quick Analysis to analyze your data instantly. Who Should Attend This course is intended for existing Excel users who need to do lots of data analysis in daily tasks. Prerequisite Before attending this course, students must have basic Microsoft Excel skills. Course Structure Module 1: Overview of Essential Knowledge for Excel Data Analysis Use to format and manage data for Excel Data Analysis. ? Overview of Number Format ? Overview of Range Name Module 2: Managing Data Sets Use to manage large data sets. ? Format as Table ? Sorting ? Auto Filter Module 3: Conditional Formatting Use to format cells based on cell contents. ? Overview of Conditional Formatting ? Highlight Cell Rules ? Top/Bottom Rules ? Data Bars ? Color Scales ? Icon Sets ? Using Formulas & Functions in Conditional Formatting Module 4: Useful Functions in Data Analysis Use to get specific data in data analysis. ? Logical Functions ? IF Function ? AND Function ? OR Function ? IFS Function (Only available in Excel 2016/2019 Office 365) ? Lookup Functions ? VLOOKUP Function ? HLOOKUP? INDEX Function ? MATCH Function ? OFFSET Function ? CHOOSE Function Module 5: Calculation for Data Sets Use to tabulate large data sets calculation for data analysis. ? Flexible Range Selection & Calculation ? SUMIF Function ? SUMIFS Function ? AVERAGEIF Function ? AVERAGEIFS Function ? COUNTIF Function ? COUNTIFS Function ? SUBTOTAL Function Module 6: Sparklines Use to show data trend. ? Overview of Sparklines ? Column Sparklines ? Line Sparklines ? Win/Loss Spaklines Module 7: Advanced Charting Tips Use visualization in data analysis. ? Trend Line in Charting ? Pie of Pie ? Overlapped Chart ? Combination Chart ? Two-Axis Chart ? Histogram DreamCatcher Consulting Page 3 of 2 Module 8: PivotTable & PivotChart Use to group and analyze data. ? Overview of PivotTable ? Create Flexible PivotTable ? Calculations in PivotTable ? Grouping in PivotTable ? Using Slicers to Filter Data ? Using Timelines to Filter Date ? Creating PivotChart Module 9: Quick Analysis (Only available in Excel 2013/2016/2019) Use to Quick Analysis to analyze your data instantly. ? Overview of Quick Analysis ? FORMATTING ? CHARTS ? TOTALS ? TABLES ? SPARKLINES ADMINISTRATIVE DETAILSCOURSE FEERM850.00 (FMM Member) per participantRM950.00 (Non-Member) per participant (The fees include lunch, refreshment, training notes and certificate)DRESS CODEOffice AttireREGISTRATIONParticipation in the programme is based on a first-come-first-served basis. Cheques made in favour of the “FMM Institute” should be forwarded on or before programme date to the FMM Institute, Penang Branch, Bandar Seberang Jaya. Participants who registered but did not attend will be billed accordingly. Upon confirmation, kindly send us the payment before the commencement of the programme.CANCELLATIONThere will be no refund for cancellation within 2 days prior to the programme, 50% for cancellation between 3 – 6 days and full refund for cancellation 7 days prior to the programme. Please inform in writing if you intend to cancel. A replacement can be accepted at no additional cost.DISCLAIMERThe FMM Institute reserves the right to change the facilitator, date and to vary/cancel the programme should unavoidable circumstances arise. All efforts will be taken to inform participants of the changes. Upon sending the registration form, you are deemed to have read and accepted the terms and conditions.ENQUIRIESFMM Institute (Penang Branch)No 2767, Mukim 11, LebuhTenggiri 2, Bandar Seberang Jaya, 13700 Seberang Perai, PenangNazlizaE-mail: HYPERLINK "mailto:nazliza@.my" nazliza@.myTel: 04-6302052/50/51 Fax: 04-630205413252457874000REGISTRATION FORMMicrosoft Excel 2016 (Data Analysis in Excel)FMM Institute, Seberang Jaya , 28-29 September 2020For further details please contact: FMM Institute Penang BranchMs Nazliza E-mail: HYPERLINK "mailto:nazliza@.my" nazliza@.my Dear Sir/Madam, Please register the following participant for the above programme:1. Name :__________________________________ Designation : ______________________________Email:____________________________________2. Name :_________________________________ Designation : ______________________________Email:____________________________________3. Name :_________________________________Designation : ______________________________Email:____________________________________4. Name :_________________________________Designation : ______________________________Email:____________________________________Submitted by :Name: (Mr/Ms)_______________________________Designation:__________________________________Company:____________________________________Address:_____________________________________________________________________________________________________________________________________________________________________________________________________________________Tel :________________________________________ Fax:________________________________________ Email:_______________________________________Membership No. : ____________________________ ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download