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

 

 

 

Contact US:309-200-3848