Either you’re new to Microsoft Excel, or you’ve played around with Excel since long but want to get more comfortable with MS Excel’s advanced features, or maybe you want to enhance your data analysis skills using Microsoft Excel. Either way, this Excel course will be great for you.
OBJECTIVE
- Carefully designed curriculum teaching you only the most used functionalities of Microsoft Excel in business environment
- Concise – you can complete this Microsoft Excel course within one weekend
- Business related examples, data analysis and case studies solved using Advanced Excel
- You will learn various data analysis techniques using MS Excel
- Downloadable resources comprising important MS Excel techniques and functionalities
COURSE OUTLINE
- Introduction – In this video, the structure and contents of the course are discussed
- Mathematical Functions
- Formulas such as SUM, AVERAGE, RAND, MIN & MAX, SUMPRODUCT
- Textual Formulas
- Formulas such as TRIM, CONCATENATE, SUBSTITUTE, UPPER & LOWER, LENGTH, LEFT, RIGHT & MID
- Logical Formulas
- Formulas such as AND & OR, IF, COUNTIF, SUMIF
- Date-time (Temporal) Formulas
- Functions such as TODAY & NOW, DAY, MONTH & YEAR, DATEDIF & DAYS
- Lookup Formulas
- Formulas such as VLOOKUP, HLOOKUP, INDEX, MATCH
- Data Tools
- Data Sorting and Filtering, Data validation, Removing duplicates, Importing Data (Text-to-columns)
- Formatting Data and Tables
- Options such as coloring, changing font, alignments and table formatting (borders, highlighted headers, banded rows)
- Pivot Tables – This Excel lecture covers Pivot tables end-to-end
- Charts
- Bar/Column chart, Line Chart, Scatter Plot, Pie & Doughnut charts, Histogram, Waterfall, Sparklines
- Excel Shortcuts
- Important shortcuts and how to find shortcuts for any particular Excel operation
- Analytics in Excel
- Regression, Linear programming (Minimization/Maximization), What-if Analysis (Goal Seek and Scenario Manager)
