Excel is the spreadsheet application in the Microsoft Office suite. This course will show you how to use the powerful tools in Excel for organizing, visualizing, and calculating your data.
Microsoft Excel is the most widely used productivity tool, allowing us to accomplish tasks in multiple ways. This results in more challenging tasks being accepted, leading to efficient and effective performance.
You will learn advanced features such as nesting IF statements, how to calculate the Mean of a group of numbers using AVERAGEIF, SUMIF, and more. You will also learn about performing lookups with HLOOKUP and VLOOKUP. This course also covers Sparklines and goes in-depth with Pivot Tables and Charts. Additionally, you will learn how to create and record your own Macros. Finally, you will learn how to put validation and protection on cells, protecting & hiding your workbook.
This advanced Excel training course is not for beginners. You should have a firm grasp of the basics before taking this course. By the conclusion of this advanced Excel training, you will have mastered the advanced features and functions of this software.
| Spreadsheets packages: what they are and how they work? |
| Application of Excel |
| User interface of Microsoft Excel |
| Applying formatting to numbers |
| Creating custom number formats |
| Alignment options |
| Looking at auto sum tricks |
| Utilizing fill handle tricks |
| Creating and using an array formula |
| Count(if), Sum(if), etc. |
| Logical functions |
| How to apply what-if analysis |
| Using SmartArt functions |
| Using different SmartArt options |
| Find current day, weekday, month & year |
| Calculate No of days b/w two dates |
| Sheets |
| Cells |
| Format painter |
| Define single and multiple criteria |
| Delete criteria |
| Paste link |
| Transpose |
| Display comments |
| Create, edit & delete comments |
| Simple sorting |
| Multiple column sorts |
| Custom sorts |
| Custom data filter |
| Advanced filtering |
| Extracting filtered data |
| Adding subtotals |
| Vlookup() & Hlookup() |
| Creating, Formatting & Modifying charts |
| Deciding what chart format to use |
| Show a time series with column or line charts |
| Using line chart accessories |
| Using bar charts to show comparisons |
| Using pie chart to whole analysis |
| Creating a list |
| Filtering lists |
| Recording macro |
| Running a macro |
| Trace precedents |
| Trace dependents |
| Tracing errors |
| Freeze titles |
| Creating pivot table |
| Consolidating data from multiple ranges into a pivot table |
| Grouping data in pivot tables |
| Insert slicer |
| Define the data validation |
| Define the warning message |
| Define the error message |
| Worksheet and cell protection |
| Hiding rows and columns |
| Workbook protection |
| Hiding worksheets & workbooks |
| Assigning a password |
Duration: 5 Days
Timing: 9:30 AM to 9:30 PM
Days: Five Days a Week (Monday to Friday)
Course Fee: Rs. 6,000/-
OraSoft Training Institute has been developing the IT workforce in Karachi and Pakistan for 26 years, focusing on facilities, technology, and people to uphold its reputation for excellence in technology training.
OraSoft Training Institute, Copyright © 1999 - 2025, All rights reserved.
Design By Visual Innovative
