• Home
  • Courses
    • Business and Management
    • Finance & Accounts
    • Human Resource
    • Marketing & Sales
    • Personal Development Skills
    • Workplace Wellbeing
    • Compliance Management
    • Skill Development
  • Webinar
    • Webinar on Power BI
    • Webinar on Internal Control
  • Contact
  • Become an Instructor
    • Cart

      0
    • RegisterLogin
ECDLECDL
  • Home
  • Courses
    • Business and Management
    • Finance & Accounts
    • Human Resource
    • Marketing & Sales
    • Personal Development Skills
    • Workplace Wellbeing
    • Compliance Management
    • Skill Development
  • Webinar
    • Webinar on Power BI
    • Webinar on Internal Control
  • Contact
  • Become an Instructor
    • Cart

      0
    • RegisterLogin
  • Home
  • All courses
  • MS Office
  • Advanced Excel Functions & Reporting in Excel

Advanced Excel Functions & Reporting in Excel

User Avatar
Rashed Munshi
MS Office

Please fill following information

Advanced Excel Functions & Reporting in Excel
  • Overview
  • Instructor

Overview:

Take your data analysis and reporting skills to the next level with Advanced Excel training. With this training, you’ll learn how to manipulate large data sets, perform complex calculations, and create custom reports and dashboards that provide valuable insights into business performance. You’ll also discover how to automate repetitive tasks, reduce errors, and save time by using advanced Excel features such as macros, pivot tables, and conditional formatting.

Objective:

This training focuses on providing participants with advanced Excel skills and techniques to effectively manage, analyze, and present data. By the end of the training, participants will be able to manipulate large data sets, perform complex calculations, and create custom reports and dashboards using advanced Excel features such as macros, pivot tables, and conditional formatting. Participants will also learn how to automate repetitive tasks, reduce errors, and save time, which will enhance their productivity and efficiency.

Course Outline:

  1. Getting Start with Excel
    • Basic Calculations
    • Case Change
    • Cell References relative & Absolute
    • Join Text
    • Text Apart
    • Formula Bar
    • Row, Columns, Cells
    • Sheets, Zoom
    • Hiding/Unhiding Columns/Rows
    • Alignment
  2. Data Formation 
    • Format Painter
    • Formatting Cell by fill & Border
    • Formatting Cell by font
    • Cell Margin
    • Replace All
    • Data Validation
    • Find & Replace
    • Paste Specials
    • Case Change
    • Freeze Panes
    • Subtotal
  3. Data Summarizing
    • Advanced Filter
    • Filter Function
    • Colour Filter
    • Conditional Formatting
    • Sum Function
    • Consolidation
    • SUM Product Function
    • Accsending/Decsending
    • Formate Table
    • Dynamic Slice in Table
    • Data Group/ Ungroup 
  4. Working with Dynamic Formula
    • Protect Sheet/ Unprotect Sheet
    • Column Function
    • Column Array Function
    • Picture Reference
    • Using Data Bars, Colors, Scales & Icon sets for great visual
    • Dynamic Vlookup
    • Hlookup
    • IF functions
    • Autofill options
    • Flash Fill
    • Nested IFO with other Functions
  5. Advance Analysis Tool & Reporting
    • Using Data Bars, Colors, Scales & Icon sets for great visual
    • Use of AND, OR, NOT
    • Sumif, Sumifs
    • CountIIFs And AverageIfs Functions
    • Pivot Table
    • Table, Slicer
    • Average Value, Top/Bottom Analysis/Top/Bottom
    • 3D Sum Function
    • Concatenate
    • Trim

Course Information

  • Reg. Ends 20 July, 2023
  • Start Date 21 July, 2023
  • End Date 22 July, 2023
  • Class Schedule 9:00AM to 5:00PM
  • Total Hours 16 Hours
  • Venue Title ECDL Classroom
  • Venue Address Cemex Shimul Trade Center, Flat: 4/A, Kha 86/1, 87, 87/1, Kuril, Dhaka
author avatar
Rashed Munshi

Microsoft Certified Excel Trainer

Mr. Rashed has very wide range from working experience. He is experienced over 5.2 years in Business Planning & Operations, Sales Admin, Sales Analytics & Business Operation, Customer experience, Core Sales & Marketing in reputed Telecommunication & FMCG. He has vast knowledge on sales operations, Sales automation, Campaign Management, Advance excel reporting & data presentation, etc.

Currently, he is working in RAK Consumer Products Limited in Business Planning and Operations department. Before that, he was in Grameenphone Limited As Customer Service Manager. Later on he devoted himself on Microsoft Excel training. Till now he has trained more than 500 professionals from different organizations on Basic to Advance Excel, Report Format Updating technique, Analytical Ability in Excel, Dynamic Data presentation, and on other related topics of Microsoft Excel. Mr. Rashed has completed his graduation from National University of Bangladesh. Then he perused his Post-Graduation from Jahangir Nagar University. He also has obtained certificates on Analyzing and Visualizing Data with Microsoft Power BI and Microsoft Azure Fundamentals issued by Microsoft.

  • Overview
  • Instructor
Book Your Seat
  • Share:

    Book Your Seat

    Please fill following information

    You May Like

    Bangladesh Labour Act 2006 and Its Rules 2015 up to the Amendment of 2022 Read More

    Bangladesh Labour Act 2006 and Its Rules 2015 up to the Amendment of 2022

    0
    ৳ 4,347.83 + VAT
    Job Analysis: How to Write JD Read More

    Job Analysis: How to Write JD

    0
    ৳ 3,478.26 + VAT

    Leave A Reply Cancel reply

    Your email address will not be published. Required fields are marked *

    thirteen − 11 =

    Latest Courses

    Financial Management for startup Business

    Financial Management for startup Business

    The Essentials of Lean Supply Chain Management

    The Essentials of Lean Supply Chain Management

    Microsoft Excel Basic to Advanced Level

    Microsoft Excel Basic to Advanced Level

    ecdl logo

    +8801767804408

    training@ecdl.com.bd

    Trade Licence No.: 03-079607

    Company

    • About Us
    • Courses
    • Contact

    Links

    • Become an Instructor
    • Terms of use
    • Privacy Policy
    • Refund Policy

    Recommend

    • Enroute Center for Development Ltd.
    • Enroute International Ltd
    • Enroute Digital Lab
    • Sudoksho

    Copyright © 2024, Enroute Center for Development Ltd.

    • Facebook
    • LinkedIn
    • Youtube

    Login with your site account

    16 − two =

    Lost your password?

    Not a member yet? Register now

    Register a new account

    seventeen − seven =

    Are you a member? Login now

    Modal title

    Message modal