Data Analyst Online Training

[cssadhar]

Excel Course Content

Creating an Excel Workbook

What’s New in Office Excel?

How to Start Excel

How to Create a New Default Excel Workbook

How to Create A New Excel Workbook Using A Template

Becoming Familiar with the Excel Screen

How to Work with the Ribbon

How to Use Access Keys

How to Use the Office Button

How to Access the Shortcut Menu Using the Mouse

How to Show and Hide Workbook Elements

Getting Help and Maintenance

How to Search Help

How to Get Help from Office Online

How to Set the Auto Recover Options

How to Recover An Excel File

Moving Around Your Cursor

How to Activate a Cell Using the Mouse

How to Move to a Cell Using the Keyboard

How to Move around Using the Go to Command

How to Move to a Cell Using the Name Box

How to Move Within a Selected Range

How to Move to Other Sheets within a Workbook

Entering Data into Worksheet

How to Enter Text (Label) Into a Cell

How to Undo and Redo Changes

How to Enter Date into a Cell

How to Use AutoFill to Enter Text

How to Use AutoFill Options

How to Use AutoFill to Enter a Sequence Of Numbers

How to Save a Workbook for the First Time

How to Save another Copy Using `Save As’

How to Save With a Different File Format

How to Save To another Folder

How to Close the Current Workbook

How to Open a Workbook

How to Exit Excel

Performing Calculations

Using a Simple Formula

How to Resize the Formula Bar

How to Enter A Formula Using the Keyboard

How to Use AutoSum To Calculate Totals

Selecting a Range Of Cells in Workbook

How to Select a Single Cell

How to Select a Range of Cells

How to Select a Range of Cells Using <Shift>

How to Select an Entire Column

How to Select the Entire Row

How to Select the Entire Worksheet

How to Select Non-Adjacent Ranges

How to Select Multiple Worksheets

Managing Worksheets and Workbook Information

Managing Worksheet Information

How to Move Information Using Cut and Paste

How to Drag and Drop Information

How to Copy and Paste Information

How to Use Paste Options

How to Drag and Drop to Copy Information

How to Insert a New Row

How to Insert Multiple Rows

How to Delete Rows

How to Insert a New Column

How to Insert Multiple Columns

How to Delete Columns

How to Insert A Cell

Managing Workbook Information

How to Rename Worksheet

How to Add a New Worksheet

How to Rearrange Worksheets

How to Copy Worksheet

How to Hide and Unhide a Worksheet

How to Format a Worksheet Tab

How to Delete a Worksheet

Formatting Worksheets

Adjusting Column Width / Row Height

How to Adjust the Column Width Using the Mouse

How to Adjust the Column Width Using the Menu

How to Adjust the Row Height Using the Mouse

How to Adjust the Row Height Using the Menu

How to Hide / Unhide Rows / Columns

How to Freeze a Column / a Row

How to Split a Worksheet into Panes

Formatting Cells Using the Ribbons

How to Change the Font

How to Change the Font Size

How to Make Text Bold

How to Italicize Text

How to Underline Text

How to Change the Font Color

How to Align Data in A Cell

How to Merge Cells

How to Change Numbers to Percentages

How to Increase / Decrease Decimal Places

How to Copy a Format Using Format Painter

How to Set a Password to Open a Worksheet

How to Remove a Password from a Workbook

How to Set a Password to Modify a Worksheet

Using Conditional Formatting

How to Use the Conditional Formatting To Highlight Cells

How to Use the Data Bars

How to Use the Color Scales

How to Use the Icon Sets

How to Edit the Rules

How to Change the Precedence of the Rules

How to Stop a Rule

How to Clear the Rules

Linking Information from Different Worksheets and Workbooks

How To Link Information Using Copy And Paste Link

Using Logical functions

How to Use Logical Test

How to Use IF Function to Return A Text

How to Use IF Function to Return A Value

How to Use A Nested IF Function

How to Use the AND / OR Function

Formatting Cells Using the Format Cells Dialog Box

How to Align Cell Data Vertically

How to Wrap Text in a Cell

How to Format Dates

How to Change the Background Color of a Cell

How to Add an Outline Border

How to Add a Double Line Border

How to Draw a Border Using the Mouse

How to Format a Table Quickly

Creating a Chart

How to Insert a Chart

How to Move a Chart

How to Resize a Chart

How to Change the Chart Type

How to Add, Edit or Remove a Chart Data Source

How to Swap Labels in the Legend with the Horizontal Axis

How to Change the Order of a Data Series

How to Move an Existing Chart to a New Worksheet

Setting up a Page and Printing

Setting up a Page

How to Insert and Remove a Page Break

How to Set and Clear the Print Area

How to Change the Margin in the Page Layout View

How to Change the Scaling

How to Change the Paper Size

How to Change the Page Margin

How to Add A Header / Footer

Validating, Protecting and Auditing Forms & Templates

Using Data Validation and Tracing Invalid Data

How to Validate Data Input

How to Create an Error Alert Message

Protecting Worksheet Styles, Contents and Elements

How to Protect the Worksheet

How to Unprotect the Worksheet

How to Unlock Cells for Editing In a Protected Sheet

A Range without a Password

Protecting Workbook Contents

How to Use the COUNTIF Function

Using the Auto Filter

How to Enable / Disable the Auto Filter

How to Apply / Remove the Filter

How to Define the Criteria Range

How to Use the Advanced Filter

Excel Advanced Course

Working with Tables

Creating Tables

How to Create a Table

How to Change the Style of a Table

How to Create a New Table Style

How to Show or Hide Table Elements

How to Create a Calculation in a Table

How to Insert and Delete a Table Row

How to Resize a Table

How to Convert a Table to a Range

How to Sort the Data in a Table

How to Perform Multiple Sorts

How to Set Customize the Sort Order

Using the AutoFilter

How to Enable / Disable the AutoFilter

How to Apply / Remove the Filter

How to Customize the Filter

Using the Advanced Filter

How to Define the Criteria Range

How to Use the Advanced Filter

Using Simple Database Functions

How to Find the Sum of Specific Records Using the Insert Function Button

How to Find the Average of Specific Records

How to Find the Maximum / Minimum Value of Specific Records

Using the VLOOKUP Function

How to Use VLOOKUP to Find Data

How to Limit the Lookup Value for an Exact Match

Creating a Pivot table and Analyzing Data

Creating a PivotTable

How to Create A PivotTable

Updating a PivotTable

How to Update the Information in a PivotTabl

How to Change the Layout of a PivotTable

How to Add an Information Field to a PivotTable

How to Arrange Information in a PivotTable

How to Filter the Report in a PivotTable

How to Filter Specific Records

Working With Calculated Fields in a PivotTable

How to Change the Calculated Field Value Settings

How to Insert a Calculated Field

How to Delete Calculated Fields

How to Change a PivotTable Options

Using Workgroup Features

Using Comments

How to Add a Comment into A Cell

How to Show/Hide Comments Permanently

How to Show/Hide Comment Indicators

How to Inspect a Workbook

How to Apply Password Protection to the Editable Cells

Automating Routine Tasks with Macros

How to Record a New Macro

How to Run a Macro 

How to Create A Run Macro Button

 

 

Contact Us:309-200-3848