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
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
Home > Courses > Digital Business > Advanced Excel
Advanced Excel
Excel Expertise for Today's Professions, Tomorrow's Success!
Enroll Now
Acquire a skill and become job-ready with professional certifications
- 27 Hours
- 7 Classes
- Instructor-Led
- Online
Share this course
- Comprehensive Skill Development
- Precision in Expert-Led Learning
- Career Advancement Opportunities
- 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
- Hands-on learning with real-world applications for practical skill development
- Expert instructors with industry experience providing guidance on best practices
- Special focus on data visualization techniques for impactful presentations
- Opportunities for networking and collaboration with peers in the learning process
- Specialized modules in forecasting, trend analysis, and Excel templates for business applications
- Universal applicability of skills across various professions for broad career prospects
Tools Covered
What you'll learn
- Comprehensive coverage of Advanced Excel and Data Analytics
- In-depth exploration from initial concepts to efficient data reporting
- Open to individuals with basic Excel knowledge or regular work engagement
- Universal applicability across various professions
- Stay ahead of societal peers by enrolling and staying current with evolving trends like Dashboard
- Recognition of the pivotal role of data underscores the course’s relevance
- Anticipation of your enrollment to support your journey into the realm of 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
- Review
Who Will Benefit
- Professionals regularly using Excel, such as analysts
- Accountants seeking to enhance their data management skills
- Project managers aiming to streamline tasks and decision-making
- Individuals in traditionally non-numeric roles wanting to leverage Excel for data organization
- Data enthusiasts looking to expand their skills in spreadsheet wizardry
- Anyone desiring to impress colleagues with advanced spreadsheet capabilities
Skill Level
- Beginner
Eligibility
- SSC/HSC or equivalent qualification
- Basic IT literacy
- Age: No specific age limit
Prerequisite
- A decent grasp of Excel
- Basic knowledge of PCs, MS Windows, internet and online proficiency
- 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.
Frequently Asked Questions
Innovating to Transform High-Potential Youth into Skilled Digital Workforce Worldwide
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 – 2024 CodersTrust | All Rights Reserved