Advanced Excel
Microsoft Excel is one of the most simplest and powerful software applications available out there. It lets users do quantitative analysis, statistical analysis with an intuitive interface for data manipulation, so much so that its usage spans across different domains and professional requirements.
Advanced Excel is quite different from Basic Excel, the focus for the user is more on DSUM, DCOUNT, Pivot Table, Formulas, Functions, and Macros.
About the Course
Advanced Excel is quite different from Basic Excel, the focus for the user is more on DSUM, DCOUNT, Pivot Table, Pivot Chart, Formulas, Functions, and Macros. Some of the other important concepts to explore while working on Advanced Excel are: If Statements. Sum Products.
Some of the other important concepts to explore while working on Advanced Excel are:
- If Statements
- Sum Products
- VLOOKUP
- Concatenate
- Sum Ifs
- Pivot Tables
- Different types of Charts
- Macros, etc.
Book your Seat
Syllabus
- Creating a Basic Excel worksheet
- Identify the elements of the user interface
- Customize the Excel Interface
- Work with Cells
- Enter Data in an Excel Workbook
- Obtain Help In Excel
- Performing Calculations in an Excel worksheet
- Create Basic Formulas
- Calculate the Cell values by using functions
- Copy formulas and functions
- Creating a Basic Excel worksheet
- Identify the elements of the user interface
- Customize the Excel Interface
- Work with Cells
- Enter Data in an Excel Workbook
- Obtain Help In Excel
- Modifying an Excel Worksheet
- Manipulate Data
- Modify the worksheet elements
- Search for data in a worksheet
- Modify rows and columns
- Formatting an Excel worksheet
- Modify fonts
- Check a worksheet for spelling errors
- Apply number formatting
- Add borders and colors to cells
- Align the content in a cell
- Apply cell styles
- Printing Excel workbook
- Set the page layout options
- Set page breaks
- Print a workbook
- Managing an Excel workbook
- Format worksheet tabs
- Manage worksheets
- View worksheets and workbooks
- Advanced Excel Functions
- Methods and Uses of IF Condition
- Creation of multiple of conditions in one cell
- IF statements in Excel with AND, OR functions
- Sumif
- Sumifs
- Sumproduct
- Dsum
- Countif
- Coundifs
- Dcount
- Dcounta
- Iferror
- Various methods and uses of advanced excel formulas
- Vlookup
- Hlookup
- Choose
- indirect
- Iserror
- Isna
- Isnumber
- Isnotext
- Isblank
- Istext
- OR
- And
- Index
- Match
- Proper
- Len
- Mid
- Left
- Right
- Data and Datedif
- Advanced excel options
- Data Validation
- Introduction Data validation
- Validating Data
- Circle invalid Data
- List
- What if Analysis
- Scenario Manager
- Goal Seek
- Data Table
- Grouping
- Ungrouping
- Subtotal
- Protecting Worksheets
- Charts
- Introduction to Charts
- Type of Charts
- Changing Axis
- Primary Axis& Secondary Axis
- Charts Eye balling
- Charts options
- Combination Charts
- Pivot tables and chart
- Various methods and options of pivot table
- Using the pivot table wizard
- Changing the pivot table layout Subtotal and grand total Formatting
- Grouping items
- Inserting calculated fields
- Pivot table options
- Display and hide data in field
- Select, move & clear pivot data
- Creating and modifying pivot chart
- Advance use of functions
- Mixing function to get various MIS outputs
- Creating data table
- Advance data validation
- Macros
- Creating Excel Macro
- Running Macros and Editing