About Workshop
Microsoft Excel is most widely used productivity tool in today’s corporate world and education sector. Day to day corporate analysis and tools are prepared with Excel. It will be an advantage for course attendees to learn practical and advanced usages of Excel for office and academic activities. Excel allows us to accomplish a task in multiple ways which will be shown to attendees with Pros and Cons of the methods.
How participants will benefit after the course:
HANDS ON EXPERIENCES. Each widely practiced Excel topics are covered in the course syllabus with practical exercises. Excel Customization, Common Operations, Shortcuts, Cell References, Formatting, Styles, Sorting, Filtering, Comments, Charts, Functions, Printing and other required functionalities of this course will ensure participants high performance in their career and academics.
Workshop topics to be covered:
Excel Concepts
• Workbook, Worksheet, Row, Column, Cell, Range
• Ribbons (Tab>Group>Command)
• Quick Access Toolbar (QAT)
• Formula Bar, Name Box, Scroll Bar, Status Bar, Toolbar
Customization Options in Excel
• Popular Options
• Customize Options
Common Operations
• Workbook (New, Open, Save, Save As, Close)
• Worksheet (Insert, Modify, Move, Copy, Delete, Rename, Hide/Unhide, Color)
• Rows, Columns (Insert, Copy, Cut, Delete, Hide/Unhide)
• Cells & Range (Select, Copy, Cut, Paste, Delete)
Keyboard Short Cuts
• CTRL Combination Keys
• ALT Combination Keys
• SHIFT Combination Keys
Cell References
• Relative cell references (A1)
• Absolute cell references ($A$1)
• Mixed Row-Column Lock cell references
• Worksheet cell references
• Workbook cell references
Formatting, Style & Custom Formats
• Create, Copy and Clear Formats
• Cell Formatting
• Number Formatting
• Text Formatting
• Date Formatting
Sort
• Sorting Numbers (Smallest to Largest)
• Sorting Words A to Z in Single Column
• Sorting Words A to Z in Multiple Columns
Filter
• Turn on Filter
• Filter with One Criteria
• Remove Applied Filtering
• Filtering Texts
• Filtering Dates
View & Windows
• Freeze Panes
• Zoom windows and selection
Proofing
• Spell Check
Comments
• New comments
• Edit comments
• Show/Hide Comments
Charts
• Categories & Series
• Chart Types
Functions
• Insert functions
• How functions work
• Find functions
• Function help
Functions (Math)
• SUM Function – Adding all numbers in a range
• COUNT-COUNTA Function – Counting total number of words and numbers.
• MIN- MAX Function – Finding smallest and largest values
Printing
• Page Setup
• Print Preview
• Print Entire Workbook, Selected Sheets, Selected Range, Charts
• Print Repetitive Titles
• Margin
• Header/Footer
• Page Setup for Large Spreadsheets
• Set Print Area
![](Templates/"../images/bodyedge_tr.gif"width="2"){kind=small}
![](Templates/"../images/bodyedge_tl.gif"width="2"){kind=small}
