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 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 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 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

·         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 Record a New Macro

·         How to Run a Macro 

·         How to Create A Run Macro Button

 

Contact US:309-200-3848