Course Overview
Why Choose This Course?
Everything you need to become successful
Expert Trainers
Learn from industry professionals with years of experience
Industry Certificate
Get certified and boost your career prospects
Course Curriculum
Comprehensive modules designed for complete learning
Excel Home Tab: Clipboard, Font and Alignment Number formatting and Styles Cells and Editing options Tables and Illustrations Charts, Links, Text and Symbols Basic data processing concepts Excel interview questions
Statistical functions: SUM, SUMIF, SUMIFS, AVERAGE, AVERAGEIF, AVERAGEIFS Counting functions: COUNT, COUNTIF, COUNTIFS, COUNTA, COUNTBLANK SMALL, LARGE, MAX and MIN Database functions: DSUM, DMAX, DMIN, DCOUNT, DAVERAGE Lookup functions: VLOOKUP, HLOOKUP and CHOOSE MATCH, INDEX, FORECAST and RANK Formula auditing and calculations
Cell References Advanced Conditional Formatting Advanced Data Validation Get Data and Sorting Excel Data Tools What-If Analysis Goal Seek and Solver Advanced Filtering Stock Maintenance
Filters, Slicers and Timeline Advanced Filter with Macro Advanced VLOOKUP with Data Validation Financial Functions and Depreciation Logical Functions: IF, IF AND, IF OR Error handling in Excel Flash Fill
Excel Dashboard creation Data Entry Forms Visitor Report Invoice preparation Attendance Sheet Practical data-management exercises and reporting skills
Course Demo Video
Watch this demo video to get an overview of what you'll learn in this course.
Book Free Demo Class