Online Live Course – Pure Advanced Course on MS Excel
Become an Excel Expert
- Be comfortable navigating the Excel user interface, entering, manipulating and formatting data.
- Analyze data and present the results in a user-friendly way. Create charts and tables that effectively summarize raw data.
- Use formulas and functions to perform calculations on data. Automate choices and data lookups using functions.
- Create easy-to-use spreadsheets. Validate data, find and correct errors. Create navigation aids for large workbooks.
Chapter 1 Excel Formula
- Constituents of Excel formula
- Operators in formulas
- Entering a formula in Excel
- Editing a formula
- Absolute/relative cell references
- Copying/pasting formulas in Excel
- Formula auditing
Chapter 2 Math Formulas in Excel
- INT function
- MOD function
- RAND function
- RANDBETWEEN function
- ROUND function
- SUM function
- SUMIF function
- SUMIFS function
- SUMPRODUCT function
Chapter 3 Stats Formulas in Excel
- AVERAGE function
- AVERAGEIF function
- AVERAGEIFS function
- COUNT function
- COUNTA function
- COUNTBLANK function
- COUNTIF function
- COUNTIFS function
- LARGE function
- SMALL function
- RANK function
- MAX function
- MIN function
Chapter 4 Text Formulas in Excel
- LEFT function
- RIGHT function
- MID function
- LEN function
- LOWER function
- PROPER function
- UPPER function
- FIND function
- REPLACE function
- SUBSTITUTE function
- TEXT function
Chapter 5 Lookup and Reference Formulas
- VLOOKUP function
- HLOOKUP function
- INDEX function
- MATCH function
- OFFSET function
- INDIRECT function
- ROW function
- ROWS function
- COLUMN function
- COLUMNS function
Chapter 6 Logical Formulas in Excel
- AND function
- OR function
- NOT function
- TRUE function
- FALSE function
- IF function
- IFERROR function
- IS function
Chapter 7 Date and Time Formulas in Excel
- DAY function
- HOUR function
- MINUTE function
- DATE function
- DATEVALUE function
- TODAY function
- NOW function
- WEEKDAY function
- NETWROKDAYS function
- INTL function
- WORKDAY function
- INTL function
Chapter 8 Name Range
- Named Ranges in Excel
- Creating Named Ranges
- Managing Named Ranges
Chapter 9 Data Validation in Excel
- Data Validation Criteria
- Input Message
- Customizing Error Messages
- Circle Invalid Entries
- Advanced Data Validation Tricks
Chapter 10 Data Sorting and Filtering in Excel
- Data Sorting
- Multi-Levels of Sorting
- Data Filtering
- Advanced Filtering
Chapter 11 Introduction to Excel Charting
- Excel Chart Types
- Chart Editing
- Formatting Chart Elements
- Combination Charts
- Handling Gaps in Charts
Chapter 12 Advanced Excel Charting Examples
- Advanced Excel Chart Cases
Chapter 13 Overview of Excel Pivot Table
- Introduction to Pivot Tables
- Creating a Pivot Table in Excel
- Formatting the Pivot Table
- Grouping data in an Excel Pivot table
- Calculated Field/Items in Pivot Table
- Pivot Table Slicers
- Pivot Charts
Chapter 14 Excel Dashboard
- Introduction of Dashboard
- Dashboard Design
Chapter 15 Introduction to Macros
- How to record a macro in Excel
- Absolute and Relative Cell References
Chapter 16 Introduction to Power Query
- Introduction to Excel Power Query
MANIK HOSSAIN
Md. Manik Hossain is an experienced Training, Learning and Development professional with many years of experience in management, customer service and specialist learning and development roles for industry leading multinationals across a range of industries. Hossain’s experience includes extensive consultancy, writing and delivery of training; along with setup and delivery of various Management and Customer Service qualifications with 5 years of experience as Manager in a top ranked university.