Advanced Excel Training in Lahore
Microsoft Excel is a core skill that every financial professional should have. DETECH Training provides courses in financial and business modeling that focus on interactive and computer-based exercises which help in thorough learning. We enlighten you with a complete understanding of a wide range of MS Excel methods and techniques. To get better management budgeting and reporting skills, we provide you with a guide of all the possible tricks that you can do with Excel spreadsheets. Hundreds of formulas and functions, dozens of data analysis and reporting tools, and thousands of little tips and tricks, everything taught here keeping all your needs of professional spreadsheet analysis in mind.
This course will help you master all the essential features and functions of Microsoft Excel. After completion of this course, participants are able to use the full features of Microsoft Excel with complete efficiency from basics all the way to the advanced levels thus making them a valuable resource for their companies.
Advance Excel Training Program
Module 1: Getting Started with Spreadsheets
- Workings and navigations
- Selection, Drag and Move
- Paste Special and Transpose
- Cell References and Ranges
- Formatting and Sorting
- Fill Sequence Lists
- Row and Column Operations
- Arithmetic Operations
- Subtotals, Grand total, Grouping
- Mod, Int, Ceiling
- Filters and Basic Conditional Formatting
- Counting and Conditional Counting
- Relative and Absolute Cell References
- Named Ranges and Name Manager
Module 2: Conditional & Logical Operations
- If, Nested If,
- Sumif, Sumifs,
- Count, Countifs,
- And, Or, Not
- IsBlank, Iferror
- Randbetween
- Choose
- Cell Linking
- Advance Conditional Formatting
- Working between spreadsheets
- Data Validations
- Custom Data Validations
Module 3: Time, Date & Text Functions
- Today, Now, Hour, Minute, Month, Year
- Day, Len, Right, Left, Substitute,
- Upper, Lower, Proper, Concatenate
- EOMonth, Datedif, WorkingDays, Text, &
Module 4: Data Visualization
- Data Handling & Building Charts
- Column & Bar Charts
- Line Charts & Pie Charts
- Area Charts & Doughnut Charts
- Chart Formatting, design & layouts
Module 5: Data Lookup Functions
- Index & Match
- Vlookup & Hlookup
- Lookup Vector
- Exact Match & Approximate Match
Module 6: Dashboards & Business Intelligence
- Pivot Tables & Pivot Charts
- Slicers & Time Series
- Calculated Fields & Group Selection
- Pivot Refresh & Getpivot
- Sparkline Chart
- Macros, Command Buttons, Scroll Bar, List Boxes
- Advance Filters, Dsum, Dcount
Module 7: Forecasting & Budgeting
- What-if Analysis
- Goal Seek
- Data Tables
- Scenario Manager
- Scenario Summary
- Forecast Function
- Breakeven Analysis