Session 01 Getting Started
• Starting Excel
• Understanding the Display Screen
• Exploring the Office Menu
• Opening a Workbook
• Managing Open Workbooks
• Using Excel Help
Session 02 Entering Data
• Moving the Cell Pointer
• Selecting a Range of Cells
• Creating a New Workbook
• Entering Constant Values
• Saving a Workbook
• Editing Cell Contents
• Clearing Cell Contents
• AutoFill and AutoComplete
• Working with Undo and Redo
• Closing a Workbook
• Exiting Excel
Session 03 Quick Access Toolbar
• Adding Icons to the QAT
• Removing Commands from the QAT
• Customizing the QAT
• Assigning VBA Macros to QAT
Session 04 Working with Ribbon (Home Tab)
• Working with Clipboard functions
o Cut, Copy, Paste, Format Painter
• Formatting Worksheets (Font & Paragraph)
o Formatting Numbers
o Changing the Font Format
o Aligning Cell Contents
o Merging Cells
o Adding Borders
o Applying Cell Styles
• Using AutoSum
o Potential Problems with AutoSum
o Special Tricks with AutoSum
o Using AutoAverage or AutoCount
o Function Reference Chapters
• Modifying Worksheets, Columns and Rows
o Changing Column Width and Row Height
o Using AutoFit
o Inserting and Deleting WorkSheets, Cells, Columns and Rows
o Hiding and unhiding WorkSheets, Columns or Rows
o Viewing, Renaming, and Color-coding Worksheets
o Using Custom Worksheet Views
o Editing Workbooks
o Using Find, Replace, Goto
o Sorting Columns
• Working with Conditional Formatting and Data Validation
o Creating, Modifying, deleting Formatting rules
o Using Data Validation
o Creating and Using Custom Formats
o Working with Auditing and Error Checking Tools
• Using Protection and Shared Workbook Features
o Protecting Workbooks and Worksheets
o Protecting a Workbook
o Protecting a Worksheet
o Allowing Users to Edit Ranges
o Working with Shared Workbooks
o Configuring a Workbook for Shared Use
o Highlighting Tracked Changes
o Creating the History Report
o Reviewing Shared Workbook Changes
o Merging Workbooks
Session 05 Working with the Ribbon (Insert Tab)
• Working with Tables
o Creating a Table
o Using AutoComplete
o Sorting a Table
o Filtering a Table
o Working with the Total Row
o Creating a Calculated Column
o Formatting a Table
o Changing table style
• Working with Shapes, ClipArts, SmartArts, Pictures
o Inserting, Resizing and Styling Shapes
o Insert & Resizing ClipArts, Pictures
• Working with Charts
o Creating Charts
o Changing the Chart Location and Size
o Changing the Chart Type
o Modifying Chart Elements
o Formatting Chart Elements
o Adding and Removing Data Series
o Printing Charts
• Working with Hyperlinks and Text
o Inserting & Modifying Hyperlinks
o Inserting textbox
o Adding Workart
o Inserting Objects
o Inserting Symbols
Session 06 Working with the Ribbon (Page Layout)
• Page Layout
o Setting Margin
o Setting WorkArea
o Adding Header & Footer
o Using Print Preview
o Using Page Setup Tools
o Printing Worksheets
Session 07 Working with the Ribbon (View)
• Working with Views
o Freezing and Unfreezing Panes
o Arranging Windows
o Splitting, Hiding and Unhiding windows
o Zoom In and Out
o Switch Windows
Session 08 Working with the Ribbon (Review)
• Proofing, Comments, Changes
o Protecting a Worksheet & Workbook
o Checking Spelling
What is special in this course compare to other trainers?
• 26+ Years real-time experienced Software Professional.
• Teaching from the basic to advanced topic in methodological way.
• Create complex functions with simple steps
• All concepts will be explained with realtime data
• On the spot practice
• Assignment for each concepts
• Online objective type test to check you knowledge
Who should take up Excel course?
Software Engineers and Data Analysts
Business Intelligence Professionals
Financial Specialist
HR Professionals
Students
Any one who wants learn excel basic level
What are the prerequisites?
Basic computer knowledge and installing software is required.