Workshop On Advanced Microsoft Excel
In modern way of life either personal & professional, we cannot do without using information technology. The “Microsoft Excel” course is designed with a view to impart the technical concepts on MS Excel for the advanced level users. This hands on training would provide the participants with in-depth practical knowledge to enhance his/her productivity in work. Advanced Excel is more flexible and effective for our work solution.
This course aims to elevate the participant’s level in a way that he/she can align himself/herself to the modern day’s complex and competitive work environment.
Course Content
BASIC Operations in EXCEL
• Creating workbooks
• Using AutoFill and AutoSum
• Constructing formulae
• Absolute Cell References
• Formatting worksheets
Worksheet Techniques
• Renaming, Inserting And Deleting Worksheets
• Copying And Moving Worksheets
• Hiding And Unhiding A Worksheet
• Copying A Worksheet To Another Workbook
• Changing Worksheet Tab Colours
• Hiding and Unhiding Rows And Columns
• Freezing Rows And Columns
Data Linking
• Understanding Data Linking
• Linking Between Worksheets
Creating Charts
• Understanding The Charting Process
• Choosing The Chart Type
• Creating A New Chart
• Working With An Embedded Chart
• Resizing The Chart
• Dragging A Chart
• Printing An Embedded Chart
• Changing The Chart Type
• Changing the Chart Layout
• Changing The Chart Style
• Printing A Chart Sheet
• Deleting A Chart
Charting Techniques
• Understanding Chart Layout Elements
• Adding A Chart Title
• Adding Axes Titles
• Positioning The Legend
• Showing Data Labels
• Showing A Data Table
• Modifying The Axes
• Showing Gridlines
• Formatting The Plot Area
• Showing The Plot Area
• Adding A Trendline
• Adding Error Bars
• Adding A Text Box To A Chart
• Drawing Shapes In A Chart
Special Pasting
• Using Paste Special to Copy Values
• Add Values and Multiply Values
• Transpose Cells
Creating Charts and Graphics
• Creating Charts
• Customizing the Appearance of Charts
• Finding Trends in Your Data
• Creating Dynamic Charts Using
PivotCharts
• Creating Diagrams by Using SmartArt
Conditional Formating
• Understanding Conditional Formatting
• Highlighting Cells Containing Values
• Highlighting Cells Containing Text
• Highlighting Duplicate Values
• Using Top and Bottom Rules
• Using Data Bars
• Managing Rules
• Clearing Rules
Hyperlinks
• Hyperlinking Within A Workbook
• Using A Hyperlink
• Hyperlinking Between Applications
Sorting Data
• Understanding Lists
• Performing An Alphabetical Sort
• Performing A Numerical Sort
• Sorting On More Than One Column
• Sorting Numbered Lists
• Sorting By Rows
Working with Tables
• Creating a Table
• Inserting or Deleting Rows
• Modifying a Table
• Sorting Data in a Table
• Filtering
MsgBox & Input Box.
No comments