SCP
INFOTECH INSTITUTE
COURSE LIST
Advance Excel 2003 / 2007 / 2010/ 2013
This program is designed for executives who are already familiar
with the basics of Microsoft Excel, and who would like to work with more
advanced features of Microsoft Excel that help in improving their efficiency of
working with worksheets, analyzing data, creating MIS reports, and automating
various tasks.
TOPICS COVERD
Overview of the Basics
Customizing
common options in Excel
Absolute
and relative cells
Protecting
and un-protecting worksheets and cells
Working with Functions
Writing
conditional expressions (using IF)
Using
logical functions (AND, OR, NOT)
Using
lookup and reference functions (VLOOKUP, HLOOKUP)
Data Validations
Specifying
a valid range of values for a cell
Specifying
a list of valid values for a cell
Specifying
custom validations based on formula for a cell
Working with Templates
Designing
the structure of a template
Using
templates for standardization of worksheets
Sorting and Filtering Data
Sorting
tables
Using
multiple-level sorting
Using
custom sorting
Filtering
data for selected view (AutoFilter)
Using
advanced filter options
Working with Reports
Creating
subtotals
Multiple-level
subtotals
Creating
Pivot tables
Formatting
and customizing Pivot tables
Using
advanced options of Pivot tables
Pivot
charts
Consolidating
data from multiple sheets and files using Pivot tables
More Functions
Date
and time functions
Text
functions
Database
functions
Formatting
Using
auto formatting option for worksheets
Using
conditional formatting option for rows, columns and cells
Assignment & project Works
Course Duration
|
Fees (Indian Rs.)
|
|
20
Days
|
2000
|
1 hour
p.d.
|
No comments:
Post a Comment