MS Office Excel (Online Session (Zoom))

If you are looking for information on using Excel, look no further! We’ve designed a comprehensive one-level Office Excel Core Essentials programme that covers all the essentials of working with Excel.
Topics covered in this course include using basic formulas and functions; time-saving tools (like AutoFill, AutoComplete, AutoSum, and the new Flash Fill); PivotTables and PivotCharts; workbook formatting techniques; inserting objects (like SmartArt, charts,and text boxes); exporting a workbook as PDF or XPS; and customizing the interface.

CONTENT

Module 1: The Basics

  • Creating a New Workbook
  • Parts of a Workbook
  • Saving a Workbook
  • Opening a Workbook
  • Review Questions

Module 2: Your First Workbook

  • Selecting Data
  • Entering and Deleting Data
  • Using Undo and Redo
  • Using Cut, Copy, and Paste
  • Review Questions

Module 3: Working with Data

  • Inserting Rows and Columns
  • Merging and Splitting Cells
  • Moving Cells
  • Using Paste Special
  • Using Find and Replace
  • Hiding and Unhiding Cells
  • Review Questions

Module 4: Using Basic Excel Tools

  • Understanding Cell References and Formulas
  • Using Basic Formulas
  • Using Basic Functions
  • Using Advanced Functions
  • Using Spell Check
  • Using Sort and Filter
  • Review Questions

Module 5: Using Timesaving Tools

  • Using AutoFill
  • Using Flash Fill
  • Using AutoSum
  • Using AutoComplete
  • Using AutoCalculate
  • Review Questions

Module 6: Formatting Text

  • Changing the Font Face, Size, and Color
  • Applying Text Effects
  • Applying Borders and Fill
  • Using the Font Tab of the Format Cells Dialog
  • Clearing Formatting
  • Review Questions

Module 7: Formatting Data

  • Wrapping Text
  • Changing the Size of Rows and Columns
  • Adjusting Cell Alignment
  • Changing Text Direction
  • Changing Number Format
  • Review Questions

Module 8: Formatting the Workbook

  • Using Cell Styles
  • Formatting Data as a Table
  • Changing the Theme
  • Inserting Page Breaks
  • Adding a Background
  • Review Questions

Module 9: Inserting Art and Objects

  • Inserting SmartArt
  • Inserting Text Boxes
  • Inserting Pictures
  • Inserting Equations
  • Drawing Shapes
  • Review Questions

Module 10: Charting Data

  • Creating Sparklines
  • Inserting Charts
  • Inserting PivotTables
  • Inserting PivotCharts
  • Using Slicers
  • Creating Timelines
  • Review Questions

Module 11: Viewing, Printing, and Sharing Your Workbook

  • Using Views
  • Saving a Workbook as PDF or XPS
  • Printing a Workbook
  • E-Mailing a Workbook
  • Sharing Your Workbook on SkyDrive
  • Review Questions

Module 12: Customizing the Interface

  • Changing Ribbon Display Options
  • Customizing the Quick Access Toolbar
  • Hiding and Showing Ribbon Tabs
  • Creating Custom Ribbon Tabs
  • Resetting Interface Changes
  • Review Questions

Module 13: Working with Tables

  • What is a Table?
  • Creating Tables
  • Resizing the Table
  • Choosing a Table Style
  • Clearing the Table
  • Review Questions

Module 14: Working with Records and Fields

  • What are Records and Fields?
  • Adding Fields by Inserting Columns
  • Adding Records by Inserting Rows
  • Deleting Records or Fields
  • Review Questions

Module 15: Using Excel as a Database

  • Filtering with Wildcard Characters
  • Validating Your Data
  • Data Validation Using Lists
  • Data Validation Using Formulas
  • Using Database Functions
  • Review Questions

Module 16: Using Custom AutoFill Lists

  • Creating a Custom AutoFill List
  • Using a Custom AutoFill List
  • Modifying a Custom AutoFill List
  • Deleting a Custom AutoFill List
  • Review Questions

Module 17: Using Comments

  • Inserting Comments
  • Editing Comments
  • Navigating Through Comments
  • Deleting Comments
  • Review Questions

Module 18: Tracking Changes

  • Tracking Changes
  • Reviewing Changes
  • Setting Options for Tracking Changes
  • Stopping Tracking Changes
  • Review Questions

Find A Course

Testimonials

"The empathy and know your customer behind the design of the training is great!"

HR Manager, Strategic Thinking & Planning Course

empathy

"I am amazed by the quality of course"

Mr Michael, Supervisory Essentials Course

amazed

"Thank you for arranging for me to have this one-on-one class.  I think it was really the best option.  I was very happy with the day."

Ms Helen Redekopp, King Faisal Specialist Hospital & Research Centre - Business Succession Planning Course

happy

Special Offers

SPECIAL OFFER: Book today for Customer Care for Customers With Special Needs Programme and save 30% for in-house programme.

click here

SPECIAL OFFERBook two places and get the third booking on the same course free of charge.

Whoops, looks like something went wrong.

1/1 ErrorException in Filesystem.php line 81: file_put_contents(): Only 0 of 459 bytes written, possibly out of free disk space

  1. in Filesystem.php line 81
  2. at HandleExceptions->handleError('2', 'file_put_contents(): Only 0 of 459 bytes written, possibly out of free disk space', '/home/smarttra/public_html/vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php', '81', array('path' => '/home/smarttra/public_html/storage/framework/sessions/3c5117b0f93b3f3d76ec925f8d7c693539cf8e4b', 'contents' => 'a:5:{s:6:"_token";s:40:"bAuGxFG5MLF8QARvsuGaiPoPVjBZO1iHGtcBaxbQ";s:8:"laracart";a:2:{s:8:"instance";s:4:"cart";s:9:"instances";a:2:{i:0;s:7:"default";i:1;s:4:"cart";}}s:9:"_previous";a:1:{s:3:"url";s:119:"https://www.smart-trainingdxb.com/microsoft-office-courses-classroom-online-session/ms-office-excel-online-session-zoom";}s:9:"_sf2_meta";a:3:{s:1:"u";i:1639010337;s:1:"c";i:1639010337;s:1:"l";s:1:"0";}s:5:"flash";a:2:{s:3:"old";a:0:{}s:3:"new";a:0:{}}}', 'lock' => true))
  3. at file_put_contents('/home/smarttra/public_html/storage/framework/sessions/3c5117b0f93b3f3d76ec925f8d7c693539cf8e4b', 'a:5:{s:6:"_token";s:40:"bAuGxFG5MLF8QARvsuGaiPoPVjBZO1iHGtcBaxbQ";s:8:"laracart";a:2:{s:8:"instance";s:4:"cart";s:9:"instances";a:2:{i:0;s:7:"default";i:1;s:4:"cart";}}s:9:"_previous";a:1:{s:3:"url";s:119:"https://www.smart-trainingdxb.com/microsoft-office-courses-classroom-online-session/ms-office-excel-online-session-zoom";}s:9:"_sf2_meta";a:3:{s:1:"u";i:1639010337;s:1:"c";i:1639010337;s:1:"l";s:1:"0";}s:5:"flash";a:2:{s:3:"old";a:0:{}s:3:"new";a:0:{}}}', '2') in Filesystem.php line 81
  4. at Filesystem->put('/home/smarttra/public_html/storage/framework/sessions/3c5117b0f93b3f3d76ec925f8d7c693539cf8e4b', 'a:5:{s:6:"_token";s:40:"bAuGxFG5MLF8QARvsuGaiPoPVjBZO1iHGtcBaxbQ";s:8:"laracart";a:2:{s:8:"instance";s:4:"cart";s:9:"instances";a:2:{i:0;s:7:"default";i:1;s:4:"cart";}}s:9:"_previous";a:1:{s:3:"url";s:119:"https://www.smart-trainingdxb.com/microsoft-office-courses-classroom-online-session/ms-office-excel-online-session-zoom";}s:9:"_sf2_meta";a:3:{s:1:"u";i:1639010337;s:1:"c";i:1639010337;s:1:"l";s:1:"0";}s:5:"flash";a:2:{s:3:"old";a:0:{}s:3:"new";a:0:{}}}', true) in FileSessionHandler.php line 71
  5. at FileSessionHandler->write('3c5117b0f93b3f3d76ec925f8d7c693539cf8e4b', 'a:5:{s:6:"_token";s:40:"bAuGxFG5MLF8QARvsuGaiPoPVjBZO1iHGtcBaxbQ";s:8:"laracart";a:2:{s:8:"instance";s:4:"cart";s:9:"instances";a:2:{i:0;s:7:"default";i:1;s:4:"cart";}}s:9:"_previous";a:1:{s:3:"url";s:119:"https://www.smart-trainingdxb.com/microsoft-office-courses-classroom-online-session/ms-office-excel-online-session-zoom";}s:9:"_sf2_meta";a:3:{s:1:"u";i:1639010337;s:1:"c";i:1639010337;s:1:"l";s:1:"0";}s:5:"flash";a:2:{s:3:"old";a:0:{}s:3:"new";a:0:{}}}') in Store.php line 262
  6. at Store->save() in StartSession.php line 88
  7. at StartSession->terminate(object(Request), object(Response)) in Kernel.php line 155
  8. at Kernel->terminate(object(Request), object(Response)) in index.php line 58
  9. at require_once('/home/smarttra/public_html/public/index.php') in index.php line 21