Introduction Reporting Automation with Microsoft Excel This training program builds upon advanced level knowledge and skills of Microsoft Excel 2016 sets you on the road to creating dynamic reports, dashboard, macros as well as discover the power of nesting functions. Reduce work load and reporting errors by creating and modifying macros is our main objective.Training OutcomeUpon successfully completion of this training, participants will be able to create dynamic reports and dashboard along with modifying macros.AssuranceOur training program assure you to implement the knowledge that we transfer to you. We strictly follow KSA process. K – Knowledge, S – Skill & A – AbilityPowerPoint Presentation Excellence Today in the era of digitization human being cannot escape from the effect and impact of presentation. Presentation is no longer limited to one’s professional life only. Starting from student life, to professional life and also in one’s personal there is always a strong need for Presentation skills.This course is designed to provide trainees a complete knowledge on Microsoft Power Point. Trainees will be able to enhance their Power point working skills along with their presentation skills.Training Outcomes:This course will enable participants to develop their skills in the following areas :1. Basic of Presentation, Understanding Importance of Presentation2. Power Point Presentation Types and Different Uses of Power Point Presentation 3. Exploring MS Power Point, Working on MS Power Point 4. Making own Presentation, Practice (Professional Profile Making using Power Point)5. Presenting and AssessmentAssuranceAfter successfully completion of the training participants will be able to make advance presentation that includes animation, sound, video and slide transaction Methodology Hands on training with practice sessions. Contents of Training: Reporting Automation with Microsoft Excel Course Content Excel data visualization and data tools Cells referencing or addressing Custom number formatting Custom date formatting Conditional formattingMicrosoft Excel functions IF, And, Or function Match, Search function Sumifs, Countifs, Averageifs function Lookup, Vlookup function Indirect, Offset function Edate, Eomonth, Weeknum function Forecast, Trend, Growth function Precedent and dependentMicrosoft Excel PivotTables Creating and pivoting PivotTables Summarizing PivotTable data Managing subtotals and grand totals Using PivotTable data in a formula Sorting and Filtering PivotTable Data Formatting PivotTables Visualization using Slicer and Timeline Grouping PivotTable data Using formulas in PivotTableMicrosoft Excel Charts or Graphs Excel chart elements Plotting secondary axis in chart Excel charts customization Creating charts using custom templateMicrosoft Excel macros & VBA What is macro? Trace developer tab Macro recording Excel VBA editor Excel VBA dot notation Excel VBA methods Excel VBA range properties Adding buttons Assigning macros to a button Excel VBA active cell propertiesDynamic reports and dashboard Static and dynamic data Dynamic reports stand for Automated report creation for Daily, Weekly, Monthly, Quarterly and Yearly Exercise of dynamic DashboardMail merge using MS Excel Mail merge stands for Mail merge processWrapping up the session Top Tips Open Forum Evaluation and follow-up *** Queries excluding above mentioned list will be entertained based on available time.PowerPoint Presentation Excellence Course Content1. Presentation: Basic of PresentationPresentation types and uses2. MS Power Point: Application of Power Point Presentation Initials to make Power Point PresentationPower Point Presentation Stages 3. Exploring Power Point: Exploring Menu Bar, Home Menu, Insert Menu, Design Menu and Tools 4. Understanding Power Point: Using Built in Power Point templateExploring Layout and Selecting desired oneTyping or Message Writing Techniques and Tips Inserting Shape, Align Shapes, Picture, Audio and Video Adding Animation: Slide Transaction and Customized Animation Formatting Text Design: Themes, Background, Transaction, Animation, Slide Show and Review Development: Link Slides, Hyperlinks, FinalizationReview: Slide Show, Hide Slide, Rehearse, RecordSecurity: Save as Security, Password ProtectionMaking a Real Presentation using Power Point Short Cut Commands:Use of Short Cut KeysPrint and PDF: Print and PDF MakingReview, Assessment and Feedback Collection

Resource Person

Md. Kamruzzaman

CEO - My Jobs

Chief Executive Officer, MyJobs Chief Operating Office, HR outsources Ex- Chief Human Resources Officer , Asrotex Group Ex-Director, (HCM, Comp. & Admin), Windy Group Ex-GM-HR & Admin, Fakir Apparels , Ex- GM HR, Palmal Group Ex-Head of HR & Admin, Dekko Group Ex-Manager-HR & Admin, Meena Bazar Founder & ex-Secretary General, HR Club Bangladesh Life Fellow, ex-EC and Treasurer – BSHRM ————————————— Mr. Md. Kamruzzaman is a distinguished HR and OD professional in the country, recognized for his expertise as a top trainer. Throughout his extensive career, Mr. Md. Kamruzzaman has personally trained thousands of professionals in soft skills, leveraging his considerable hands-on experience. With 27yrs experience across various industries including Pharmaceuticals, Retail, Automobiles, and RMG, he boasts a successful career in HR and organizational development within renowned companies. Currently serving as CEO of MYJOBS & HR OUTSOURCES, Mr. Kamruzzaman previously held the position of Chief Human Resources Officer at Asrotex Group. Prior to that, he served as Director of Human Capital Management, Compliance, and Administration at Windy Group, and as General Manager of HR & Administration at Fakir Apparels, one of the largest RMG factories. He also led the Corporate HR department at Dekko Group and the HR department at Meena Bazar, a leading retail chain. Mr. Kamruzzaman holds a diverse academic background specializing in Human Resources Management, including BA (Hons.), MA (Eng.), MBA (HR), LLB, PGD (HRM), Diploma in Social Compliance, and Diploma in Computer System Management. He is an ex-Secretary General of HR CLUB BANGLADESH and ex-EC & Fellow of BSHRM. Additionally, he is a member of the SHRM (Society for Human Resources Management, USA). He is a registered member of the Dhaka Taxes Bar.

SMS