আপনার গ্লোবাল ক্যারিয়ার প্রসপেক্ট ও আয় বাড়িয়ে নিন মাত্র ১ সপ্তাহেগ্রামীণফোন একাডেমিতে কোডার্সট্রাস্টের প্রফেশনাল সার্টিফিকেট কোর্সগুলো করে, সম্পূর্ণ বিনামূল্যে।

আজই এনরোল করুন
  • 01958220813
  • contact@coderstrust.global

Follow Us!

Stay in the loop by connecting and following us on our social media! Keep up-to-date with our latest news and activities.

FOLLOW

Facebook-f Linkedin-in Youtube
Facebook-f Linkedin-in Youtube

@ Copyright 2022

আপনার গ্লোবাল ক্যারিয়ার প্রসপেক্ট ও আয় বাড়িয়ে নিন মাত্র ১ সপ্তাহেগ্রামীণফোন একাডেমিতে কোডার্সট্রাস্টের প্রফেশনাল সার্টিফিকেট কোর্সগুলো করে, সম্পূর্ণ বিনামূল্যে।

আজই এনরোল করুন
  • 01958220813
  • contact@coderstrust.global

Follow Us!

Stay in the loop by connecting and following us on our social media! Keep up-to-date with our latest news and activities.

FOLLOW

Facebook-f Linkedin-in Youtube
Facebook-f Linkedin-in Youtube

@ Copyright 2022

Advanced Excel

Master Advanced Excel for Data Analysis and Business Solutions

This Advanced Excel course is tailored for professionals looking to elevate their Excel expertise for complex data analysis, dynamic reporting, and financial modeling. You will master advanced features such as PivotTables, Power Pivot, complex formulas (VLOOKUP, SUMIF, INDEX, IF), and advanced data visualization techniques. The course covers automating workflows with macros, managing large datasets, and integrating financial modeling and trend analysis. By the end, you’ll be equipped with the skills to generate insightful business reports, make informed decisions, and solve real-world problems, positioning you as a valuable asset in any business environment.

Whether you’re looking to boost your career, optimize business operations, or develop cutting-edge data analysis solutions, this course equips you with the practical expertise to succeed and become a highly valued professional.

Enroll Now

Acquire a skill and become job-ready with professional certifications

ENROLL NOW

Online

BDT 10,000

On-Campus

Not Available
  • 20 Hours
    (Live Online)
  • 10 Classes
    (Live Online)
  • Instructor-Led
  • Online

Share this course

  • Master advanced Excel tools, data analysis, and financial modeling
  • Gain expertise in PivotTables, data visualization, and business decision-making
  • Hands-On Learning with Real-world Projects
  • Develop skills for real career growth
  • Learn from experts active in their field
  • Learn by working on real-world problems
  • Structured guidance ensuring continuous learning

Key Features

  • Earn a Professional Certificate from CodersTrust to validate your skills and enhance your career prospects
  • Build and manipulate financial models for budgeting, forecasting, and decision-making
  • Specialized classes on freelancing platforms like Fiverr, Upwork, and Freelancer to help you onboard into freelance marketplace
  • Self-branding and Client Communication sessions to enhance your communication skills and effectively promote yourself in the job market as a Web Developer
  • Interactive live classes, available both on-campus and online, are offered in weekday or weekend cohorts to suit your schedule

Tools Covered

What you'll learn

  • Apply advanced Excel functions and data analysis techniques for decision-making
  • Use PivotTables, Power Pivot, and financial modeling for dynamic reporting
  • Analyze datasets and visualize trends with charts, graphs, and dashboards
  • Optimize decisions using Goal Seek, Solver, and forecasting tools
  • Organize and manage large datasets efficiently for accuracy and speed
  • Design Excel templates to automate daily business tasks
  • Integrate Excel with Google Sheets for streamlined workflows
  • Leverage data analytics to stay ahead of industry trends and Big Data

Learning Path

  • Getting Started with Excel
  • Identifying the Different Excel Programs
  • Identifying New Features of Excel
  • Working with the Ribbon
  • Customizing the Excel Program Window
  • Zooming In on a Worksheet
  • Arranging Multiple Workbook Windows
  • Adding Buttons to the Quick Access Toolbar
  • Customizing the Ribbon
  • Maximizing Usable Space in the Program Window
  • Creating Workbooks
  • Modifying Workbooks
  • Modifying Worksheets
  • Inserting Rows, Columns, and Cells
  • Merging and Unmerging Cells
  • Working with Data and Excel Tables
  • Entering and Revising Data
  • Managing Data by Using Flash Fill
  • Moving Data Within a Workbook
  • Finding and Replacing Data
  • Correcting and Expanding Upon Worksheet Data
  • Defining Excel Tables
  • Performing Calculations on Data
  • Naming Groups of Data
  • Creating Formulas to Calculate Values
  • Summarizing Data That Meets Specific Conditions
  • Working with Iterative Calculation Options and Automatic Workbook Calculation
  • Using Array Formulas
  • Finding and Correcting Errors in Calculations
  • Changing Workbook Appearance
  • Formatting Cells
  • Defining Styles
  • Applying Workbook Themes and Excel Table Styles
  • Making Numbers Easier to Read
  • Changing the Appearance of Data Based on Its Value
  • Adding Images to Worksheets
  • Focusing on Specific Data by Using Filters
  • Limiting Data That Appears on Your Screen
  • Filtering Excel Table Data by Using Slicers
  • Manipulating Worksheet Data
  • Selecting List Rows at Random
  • Summarizing Worksheets by Using Hidden and Filtered Rows
  • Finding Unique Values Within a Data Set
  • Defining Valid Sets of Values for Ranges of Cells
  • Reordering and Summarizing Data
  • Sorting Worksheet Data
  • Sorting Data by Using Custom Lists
  • Organizing Data into Levels
  • Looking Up Information in a Worksheet
  • Combining Data from Multiple Sources
  • Using Workbooks as Templates for Other Workbooks
  • Linking to Data in Other Worksheets and Workbooks
  • Consolidating Multiple Sets of Data into a Single Workbook
  • Analyzing Data and Alternative Data Sets
  • Examining Data by Using the Quick Analysis Lens
  • Defining an Alternative Data Set
  • Defining Multiple Alternative Data Sets
  • Analyzing Data by Using Data Tables
  • Varying Your Data to Get a Specific Result by Using Goal Seek
  • Finding Optimal Solutions by Using Solver
  • Analyzing Data by Using Descriptive Statistics
  • Creating Charts and Graphics
  • Creating Charts
  • Customizing the Appearance of Charts
  • Finding Trends in Your Data
  • Creating Dual-Axis Charts
  • Summarizing Your Data by Using Sparklines
  • Creating Diagrams by Using SmartArt
  • Creating Shapes and Mathematical Equations
  • Using PivotTables and PivotCharts
  • Analyzing Data Dynamically by Using PivotTables
  • Filtering, Showing, and Hiding PivotTable Data
  • Editing PivotTables
  • Formatting PivotTables
  • Creating PivotTables from External Data
  • Creating Dynamic Charts by Using PivotCharts
  • Printing Worksheets and Charts
  • Adding Headers and Footers to Printed Pages
  • Preparing Worksheets for Printing
  • Previewing Worksheets Before Printing
  • Changing Page Breaks in a Worksheet
  • Changing the Page Printing Order for Worksheets
  • Printing Worksheets
  • Printing Parts of Worksheets
  • Printing Charts
  • Most Used Formulas
  • Upper, Lower, Proper and Trm
  • Left, Mid, and Right
  • Concatenate& (Ampersand)
  • Concatenate vs. & (Ampersand) Roundup, and Rounddown
  • Vlookup
  • Hlookup
  • Xlookup
  • Index
  • If
  • Nested If
  • If and And
  • Sumif
  • Error Values in Excel
  • Using Google Sheets
  • Excel Sheets vs Google Sheets
  • Integrated Google Sheets
  • Financial Modeling and Valuation
  • Data Analysis with Pivot Tables and Power Pivot
  • Data Visualization, Charts & Graphs
  • Financial Analysis for Accounts and Finance
  • Master in Google Sheets
  • Forecast and Trend Analysis – Sales, Production, and Distribution
  • Excel for Supply Chain and Logistics
  • Excel for Complete Human Resource Management
  • Creating Excel Templates for Day-to-Day Tasks
  • Examination
  • Discussion on Exam Questions and Answers
  • Course Review

Who Will Benefit

This course is ideal for:
  • Business professionals looking to enhance data analysis skills
  • Financial analysts and accountants seeking advanced Excel expertise
  • Data analysts working with complex datasets
  • Supply chain and logistics professionals using Excel for efficiency
  • HR professionals managing workforce data
  • Entrepreneurs and small business owners streamlining operations
  • Students aiming to boost career prospects with Excel skills

Skill Level

  • Beginner

Eligibility

Prerequisite

  • ICT Literacy
  • Laptop/Desktop with internet connection
  • Basic knowledge of English (reading, writing, speaking)

Develop Your Knowledge and Skills for a Successful Career

Earn a certificate and get ready for your dream job!

Training 1.5M+ Learners and Professionals in 15+ Countries
Build Your Future!

Enroll in CodersTrust Digital Skills courses and get globally accepted certifications.

CONTACT NOW

Frequently Asked Questions

This course is ideal for business professionals, data analysts, finance experts, project managers, and anyone looking to improve their Excel skills for data analysis, financial modeling, and reporting. It’s also perfect for those seeking to advance their career or upskill in Excel for day-to-day tasks and decision-making.
While basic knowledge of Excel is helpful, it is not mandatory. This course starts with fundamental Excel functions and gradually moves towards advanced topics like PivotTables, Power Pivot, financial modeling, and data analysis.
You’ll master Excel functions and formulas, data analysis techniques, PivotTables, data visualization, financial modeling, and forecasting. Additionally, the course covers Google Sheets, supply chain management, and HR management, making it highly applicable across different industries.
Yes! The course includes practical exercises to ensure you can apply what you’ve learned. You’ll work with real-world data, build dashboards, analyze trends, and create financial models using Excel and Google Sheets.
Yes, upon successfully completing the course, you will receive a certificate of completion that you can use to demonstrate your advanced Excel skills.
No, all course materials and exercises can be completed using Microsoft Excel (Office 365, Excel 2019, or Excel 2021). Google Sheets is also covered for cloud-based work.
We offer flexible learning options with on-campus and online classes. You can choose between weekday sessions (2 sessions per week, 3 hours each) or weekend sessions (1 session per week, 4 hours each).
We offer career support including interview preparation, portfolio-building guidance, and tips for job searching or freelancing.
You can easily enroll by visiting our website and selecting the course schedule that works for you. Payment options are available online, and our team is here to assist if you need help with the enrollment process.
Payment can be made securely through SSLCommerz or via mobile wallet options such as bKash and Rocket. Detailed instructions will be provided during the enrollment process.
Our support team is available 24/7 to assist you with any technical issues. You can reach out through our designated channels, and we will help resolve the issue promptly.
Feel free to reach out by emailing hello@coderstrustbd.com. Our team will respond within 24 hours to address your questions and provide assistance.

Innovating to Transform High-Potential Youth into Skilled Digital Workforce Worldwide

Facebook-f Linkedin-in Youtube
MENU
CONTACT

40 Wall Street, Suite 2004

New York 10005, USA

House# 82, Road# 19/A, Block# E

Banani, Dhaka-1213

Bangladesh

SUBSCRIBE

Unsubscribe anytime

We Accept

Copyright © 2023 – 2025 CodersTrust | All Rights Reserved

Call us to Enroll
Banani Campus
Mirpur Campus
Dhamondi Campus
Chattogram Campus
Select Your Option
Online

Course Fee

BDT 10,000
PAY NOW
On-Campus

Course Fee

Not Available
PAY NOW
Call us to Enroll
Banani Campus
Mirpur Campus
Dhamondi Campus
Chattogram Campus
Get Quick Answers

Error: Contact form not found.