Home About Us Courses Downloads Events Contact Us
about_us

excel_1

 

MS Excel 2010 Level 1    Price Per Person: R1100


Prerequisites:  Delegates must have computer literacy basics


Duration: 1 Day


•           Starting Excel
•           Spreadsheets and workbooks
•           Getting Help in Excel
•           Office assistant
•           Navigation in Excel
•           Keyboard shortcuts
•           Selecting items
•           Entering labels and values
•           Creating custom lists
•           Column and row headers
•           Spell check
•           Setting view options
•           File formats
•           File names
•           Formatting techniques
•           Gridlines and borders
•           Shading and patterns
•           Inserting and deleting
•           Cut, copy, paste and columns
•           Basic formulae and functions
•           Printing documents

 

level 2

 

 

 

 

 

MS Excel Level 2       Price Per Person: R 1100


Prerequisites:  Delegates must have completed MS Excel Level 1 or must be familiar with the basics of Excel.

Duration:  1 day
  
•           Tabbed workbooks
•           Entering data using 3D Formulas
•           Freezing panes in an Excel Window
•           Creating Workspaces
•           Text to columns
•           Sorting data
•           View data with auto filter
•           Creating auto subtotals
•           Hide and redisplay data
•           Auto correct
•           Import and Export data
•           Auto format
•           Charting
•           Creating Spark lines
•           Hidden columns
•           Working with Auto shapes, pictures and Clipart
•           Grouping objects
•           Working with Smart Art graphics

level 3

 

 

 

 

 

MS Excel Level 3      Price Per Person: R1100


Prerequisites:  Delegates must have completed the Excel Level 2 course, or be familiar with Excel.

Duration:  1 day

•           Pivot tables
•           Conditional Formatting with Smart Art graphics
•           Advanced Formulas
•           Goal seek
•           Date functions
•           Dialogue box options
•           Tables
•           VLookup
•           Customizing Excel
•           Adding menu options
•           Macros
•           Visual Basic toolbar
•           Validations
•           Protecting worksheets
•           Creating a Web Query

 

Sample Report Example - Created using excel

excel

home | about us | courses | downloads | events | contact us - copyright of Buzzword Corporate Training 2016