Jump to content

Data Analyst Online Training


Recommended Posts

Posted
  • 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
  • H
  • 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

 

Contact US:309-200-3848

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...