Description
Benefits of the course
- Build financial models from scratch (shown step-by-step)
- Format sheets and charts professionally
- Learn new keyboard shortcuts and be even faster in Excel
- Use Cell Styles and format spreadsheets easier and faster
- Writing Formulas and performing Calculations
- Create charts with Trend Lines, and Dual Axis
- Use Excel as a Database with Sort and Filter options
- How to avoid the most common Database Design flaws
- Increase productivity with functions: IF, PMT, VLOOKUP, FIND, SEARCH, MATCH, INDEX and much more…
- Updated to include the new FILTER, XLOOKUP, SORT & UNIQUE functions
- Learn to use Pivot Tables, Pivot Charts, Slicers and Time Lines for Interactive Excel Reports.
- MIS Reporting
- Power BI & Power Query for Automation
- Learn several hidden Excel tips and tricks
Topics for this course
EXCEL INTRODUCTION & ADVANCED PASTE SPECIAL TECHNIQUES
Excel Interface
Shortcut Keys
Customizing Excel
Paste Formats, Values, Formulas, Comment, Validations
Operation – Sum, Multiple, Subtract, Divide
Transpose Table
FORMULA REFERENCE
FORMATTING BASIC
FORMATTING ADVANCED
EXCEL BUILT IN FUNCTIONS
WORK GROUP COLLABORATIONS
SORTING AND FILTERING
SUMMARIZING DATA
DATA VALIDATION
WORKING WITH EXTERNAL DATA & DATA ANALYSIS TOOL
USING MACROS
ADVANCED ARRAY FUNCTIONS
LOOKUP MAHARAJ FUNCTIONS
PIVOT TABLES
Requirements
- Access to a good internet connection
- Laptop with Microsoft Office Installed
Your Instructors
Sajjad Hussain
MIS & Data Analytics
I am a pro in Excel, Power BI, MIS Reporting & Creating a Visual Dashboard with almost 7 years of corporate working experience.
Sajid Akram
SEO, SEM & Analytics
Sajid is the Practice Lead in Digital Marketing (SEO, SEM & Analytics) He has proven results in Performance Marketing from optimizing search engine marketing campaigns, including pay-per-click (PPC), YouTube Ads, Shopping Ads, GDN Ads, Remarketing campaigns, Quora, Reddit to social media marketing, and organic search engine optimization (SEO) and analytics to expose brands to highly discerning customers. In addition, He creates powerful digital marketing and media buying strategies that engage and attract audiences and drive conversions across the omnichannel approach. He has years of combined experience and expertise working with diverse clients in Healthcare, Energy, Telecom, Automobile, E-commerce, Education, Gaming, and FMCG throughout the globe. Hands on Experience with top clients - Abbott (FreeStyle Libre), Wolters Kluwer, Hathway Broadband, Paras Healthcare, Vikram Solar, Amplus Solar, Lohia Auto, Thermage, Diginerve, India@75, Zuju Kickoff, and Relevium.