About the Course
Formulas, Macros make Excel smarter. without them, MS Excel is just a database. But by using its advanced features like formulas, you can crunch data, analyze and get simple solutions to most complex questions.
Who needs the course
HR Professionals, Payroll professionals, Sales & Marketing Professionals, Finance Professionals and anyone who needs to maintain various cuts of data.
module 1 Document navigation
module 2 Using formatting function
module 3 Conditional formatting and vlook up function
module 4 Using templates and workbook
module 5 Working with data
module 6 Pivot table
module 7 Consolidation of data
module 8 Scenarios
module 9 Trend lines
module 10 Macros and auditing workbook
module 11 Sharing books and protecting
module 12 Data tables and vba variables
The purpose of this course is provide students the necessary skills to use MS Excel in the workplace as an analysis and presentation tool, above and beyond the average skill level of most users thus making the student more attractive candidate in the job market.