Excel(Basic+Adv)

Error message

Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in _views_slideshow_preprocess_views_slideshow() (line 73 of /home2/stravantechnolog/public_html/sites/all/modules/views_slideshow/theme/views_slideshow.theme.inc).
Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in _views_slideshow_preprocess_views_slideshow() (line 76 of /home2/stravantechnolog/public_html/sites/all/modules/views_slideshow/theme/views_slideshow.theme.inc).
Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in _views_slideshow_preprocess_views_slideshow() (line 76 of /home2/stravantechnolog/public_html/sites/all/modules/views_slideshow/theme/views_slideshow.theme.inc).
Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in _views_slideshow_preprocess_views_slideshow() (line 76 of /home2/stravantechnolog/public_html/sites/all/modules/views_slideshow/theme/views_slideshow.theme.inc).
Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in _views_slideshow_preprocess_views_slideshow() (line 73 of /home2/stravantechnolog/public_html/sites/all/modules/views_slideshow/theme/views_slideshow.theme.inc).
Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in _views_slideshow_preprocess_views_slideshow() (line 73 of /home2/stravantechnolog/public_html/sites/all/modules/views_slideshow/theme/views_slideshow.theme.inc).
Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in _views_slideshow_preprocess_views_slideshow() (line 73 of /home2/stravantechnolog/public_html/sites/all/modules/views_slideshow/theme/views_slideshow.theme.inc).
Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in _views_slideshow_preprocess_views_slideshow() (line 76 of /home2/stravantechnolog/public_html/sites/all/modules/views_slideshow/theme/views_slideshow.theme.inc).
Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in _views_slideshow_preprocess_views_slideshow() (line 76 of /home2/stravantechnolog/public_html/sites/all/modules/views_slideshow/theme/views_slideshow.theme.inc).
Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in _views_slideshow_preprocess_views_slideshow() (line 76 of /home2/stravantechnolog/public_html/sites/all/modules/views_slideshow/theme/views_slideshow.theme.inc).
Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in _views_slideshow_preprocess_views_slideshow() (line 76 of /home2/stravantechnolog/public_html/sites/all/modules/views_slideshow/theme/views_slideshow.theme.inc).
Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in _views_slideshow_preprocess_views_slideshow() (line 76 of /home2/stravantechnolog/public_html/sites/all/modules/views_slideshow/theme/views_slideshow.theme.inc).
Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in _views_slideshow_preprocess_views_slideshow() (line 76 of /home2/stravantechnolog/public_html/sites/all/modules/views_slideshow/theme/views_slideshow.theme.inc).
Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in _views_slideshow_preprocess_views_slideshow() (line 76 of /home2/stravantechnolog/public_html/sites/all/modules/views_slideshow/theme/views_slideshow.theme.inc).
Warning: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead in _views_slideshow_preprocess_views_slideshow() (line 76 of /home2/stravantechnolog/public_html/sites/all/modules/views_slideshow/theme/views_slideshow.theme.inc).

Basic EXCEL

Module 1:Getting Started with Excel

·An Overview of Excel

·Navigate in Excel

·Select Data

·Enter Data

·Save a Workbook

·Obtain Help

Module 2:Modifying a Worksheet

·Move and Copy Data Between Cells

·Fill Cells with Series of Data

·Edit Cell Data

·Insert and Delete Cells, Columns, and Rows

·Find, Replace, and Go To Cell Data

·Spell Check a Worksheet

Module 3: Performing Calculations

·Create Basic Formulas (+ - * /)

·Calculate with Functions (sum)

·Copy Formulas and Functions

·Create an Absolute Reference

Module 4:Formatting a Worksheet

·Change Font Size and Type

·Add Borders and Colour to Cells

·Change Column Width and Row Height

·Merge Cells

·Apply Number Formats

·Create a Custom Number Format

·Align Cell Contents

Module 5:Developing a Workbook

·Format Worksheet Tabs

·Reposition Worksheets in a Workbook

·Insert and Delete Worksheets

·Copy and Paste Worksheets

·Copy a Workbook

Module 6:Printing Workbook Contents

·Set a Print Area

·Create a Header and a Footer

·Set Page Margins

·Change Page Orientation

·Insert and Remove Page Breaks

·Print a Range

Module 7:Customizing Layout

·Freeze and Unfreeze Rows and Columns

·Hide and Unhide Rows and Columns

ADV EXCEL

Module 1:Creating and Applying Templates

·Create a Workbook from a Template

·Create a Custom Template

·Working with Comments

Module 2:Creating and Modifying Charts

·Create Basic Charts (column, line, bar,pie)

·Format Chart Items

·Change the Chart Type

·Create a Diagram

Module 3: Working with Graphic Objects

·Insert Graphics

·Create AutoShapes

·Format Graphic Objects

·Change the Order of Graphic Objects

·Group Graphic Objects

·Move, Copy, and Resize Graphic Objects

Module 4:Sorting and Filtering Data

·Sort Data Lists

·Filter Data Lists

·Create and Apply Advanced Filters

·Calculate with Database Functions

·Add Subtotals to a Worksheet

Module 5:Using Functions

·Combining Columns

·Splitting Columns

·Using database functions

·(DSum, DMin, DMax, DCount ,Vlookup,Hlookup)

Module 6:Creating a PivotTable

·Creating a Pivot Table

·Adding Fields to the Pivot Table

·Removing Fields from the Pivot Table

·Formatting a Pivot Table

Module 7:Working with a PivotTable

·Creating Charts from a Pivot Table

·Grouping results within a pivot table

·Calculating within a Pivot Table

·Analysing information within the pivot table

Module 8:Streamlining Workflow

·Create a Macro

·Edit a Macro

·Apply Conditional Formatting

·Add Data Validation Criteria

·Modify Excel's Default Settings

Module 9:Auditing Worksheets

·Trace Cell Precedents

·Trace Cell Dependents

·Locate Errors in Formulas

·Locate Invalid Data and Formulas

Module 10: Working with Multiple Workbooks

·Create and format data across multiple workbooks

·Perform calculations across multiple workbooks

·Create Linked Cells in Different Worksheets

·Create Linked Cells in Different Workbooks

Module 11:Calculating with Advanced Formulas

·Create and Apply a Name for a Range of Cells

·Calculate Across Worksheets

·Calculate with Date Functions(Today, Now, Day, Month, Year and working days)

·Calculate with Statistical Functions (Average, Min, Max, Count)

·Calculate with Lookup and Reference Functions(Hlookup, Vlookup, Transpose)

·Calculate with Logical Functions (If, And, Or)

·Perform What-If Analysis

Search form

ALL COURSES

Excel(Basic+Adv)

Error message