Advanced Excel Training

Course details

Advance Excel Training course offers the thorough understanding of implementing Excel for complex calculation and data analysis tasks that need to be performed in any organization. As Excel has become one of the most popular applications being used in organizations worldwide, every professional need to have sound knowledge of it to perform most of the data oriented tasks and decision making. Thus, advance Excel training is to be pursued by managers, administrative staffs, account staffs, data analysts, researchers and all the other functional staffs for operational efficiency and enhanced performance.

Courses Outline- Advance Excel

Customizing the Excel Working Environment

• Set file properties
• Define custom properties
• Add a button to the Quick Access Toolbar
• Customize the Ribbon
• Change default number of worksheets, fonts and default view in workbook
• Protect Workbook
• Protect Sheet
• Set a password for a workbook
• Saving a worksheet as a PDF file

Essential Worksheet Operation

• Creating a new workbook is a straightforward process
• Rename a worksheet
• Copy a worksheet to another workbook
• Change the order of worksheets in a workbook
• Hide a worksheet
• Unhide a worksheet
• Make a sheet very hidden
• Delete a worksheet
• Change a row's height or column's width
• Insert a column or row
• Delete a column or row
• Hide a column or row
• Unhide a column or row
• Insert a cell
• Delete a cell
• Move a group of cells to a new location
• Zoom in or out to a specific zoom level
• Change to another open workbook
• Arrange all open workbooks in the program window
• Display copies of the same workbook
• Activate a worksheet
• change the color of a sheet tab
• create a hyperlink
• edit a hyperlink
• delete a hyperlink
• Comparing sheets side by side
• Splitting the worksheet window into panes
• Keeping the titles in view by freezing panes

Working with Data

• Entering data automatically with auto fill
• Selecting Ranges
• Selecting special types of cells
• Placing Information into multiple cells simultaneously
• check spelling
• Using AutoCorrect for shorthand data entry
• Hiding or grouping rows and columns
• Entering numbers with fractions
• Formatting numbers
• Formatting numbers using the Format Cells dialog box
• Changing text alignment
• create a name using name dialog box
• create a named range from a selection
• display the Name Manager
• edit a named range
• Working with dates and time
• Pasting in special ways
• Performing mathematical operations without formulas
• Skipping blanks when pasting
• Transposing a range
• Paste Link

Exploring Excel Database Feature

• Sort a data list
• Sort a data list by values in multiple columns
• Add a sorting level
• Delete a sorting level
• Sort worksheet data by a custom list of values
• Organize worksheet data into groups
• Show and hide levels of detail in a grouped data list
• Remove grouping levels from a data list
• Apply a filter to a worksheet
• Clear a filter
• Display the top or bottom values in a column
• Create a custom filter
• Special Filter for Dates, Text, and Numbers
• Advance Filter
• Calculating formulas across worksheets
• Import data from an external source

Data Table

• Create a data table
• Changing the Look of a Table
• Add new rows or columns
• Setting table options
• Removing duplicate rows from a table
• Multiple-column sorting
• Converting a table back to a range

Data Validations

• Data Validation
• Create a validation rule

Conditional Formatting

• Display data bars in one or more cells
• Display a color scale in one or more cells
• Display icon sets in one or more cells
• Apply a conditional format to a cell
• Edit a conditional formatting rule
• Delete a conditional formatting rule

Creating Dynamic Lists with PivotTables

• Create a PivotTable from a data list
• Pivot a PivotTable
• Show or hide the PivotTable Field List task pane
• Rename a PivotTable
• Control how and where subtotals and grand totals appear in your PivotTable
• Change the PivotTable summary function
• Filter a PivotTable
• Apply a number format to a PivotTable
• Apply a conditional format to a PivotTable
• Create a new PivotTable style
• Apply a PivotTable Style to a PivotTable
• Consolidate data with Pivot Table
• Change Pivot Table Calculations
• Make manual calculation in Pivot Table

Analyzing Alternative Data Sets

• Using auditing to diagram
• Using Evaluation in Excel
• Working with Goal Seek
• Using Scenarios in formula

Printing

• Printing row and column titles
• Scaling printed output
• Force Excel to print using a specific number of pages
• Printing cell gridlines
• Change the order in which worksheets print
• Print part of a worksheet
• Center material on the printed page
• Print a chart
• Add a header or footer to a worksheet
• Create an Auto Header
• Add an image to a header or footer
• Format an image in a header or footer

Collaborating with Colleagues

• Add a comment to a cell
• Edit a comment
• Delete a comment
• Adding Comments to Cells
• Changing a comment's shape
• Printing Comments

Creating Charts and Graphics

• Create a chart
• Choosing Chart types
• Change how Excel plots your data
• Remove a series from an axis
• Add a series to an axis
• Move a chart to its own worksheet
• Apply a Chart Style to a chart
• Apply a different layout to a chart
• Change the appearance of a chart's gridlines
• Select a chart element for formatting
• Select a data point in a series
• Format a chart element
• Save a chart as a chart template
• Add a trendline to a chart
• Create a PivotChart
• Change the chart type of a chart or PivotChart