info@excelprodigy.com
+91 893989 8008 / +91 80720 78791
Basic Excel Training
Course Overview & objectives:
This training programme has been designed for beginners to understand the usage of excel in data analysis. Exploring the environment and to learn basic functions and formulas to bring the insights from the data for making better decisions. It is designed in such a manner that people will handle the application very well for their day to activity, also they can be confident to improvise themselves for advanced concepts.
Introduction to excel spreadsheet
- UI elements and objects
- Workbook versions and updates
- Simple data entry and formatting
- Filling series and autofill options
- Difference between formulas and inbuild functions
- Sequence of operations
- Working with sheets (adding, inserting, navigating)
- Rows and columns (inserting, deleting, hide, unhide
Editing, Copy and Paste Techniques, shortcuts
- Editing and over writing, undo redo
- Copy and paste techniques
- Paste special – Value, formula, format, transpose
- Basic short cuts on cells and worksheets
Statistical function
- Basic arithmetic function Sum, Average, MAX, MIN, Large, small
- Countif and SUMIF
Reference
- Relative and absolute reference
Logical function
- If function dealing with numerical, text and blank inputs and outputs
Filters & sorting
- Creating custom auto filter
- Text, numeric and date filters
- Sort on more than one field
Date time functions
- Using Today, Now, Date functions
- DATEDIF and NETWORKDAYS, EOMONTH functions
Lookup functions
- VLOOKUP and HLOOKUP
- Matching the exact values and approximate values
Text functions
- Left/Right/MID functions related to text length
- Upper/Lower/Proper – case sensitive functions
- Trim/Clean
Validation
- Defining cell input using data validation
- Creating dropdown
- Customising Input message, error alerts
Printing Simple Printing/Previewing
- Page Setup & Orientation
- Creating and Formatting Page Headers/Footers
- Custom view
Charts
- Importance of data visualisation
- Basic visuals and its properties
- Column, line, pie, and its properties
Pivot
- Creating, Formatting Simple PivotTables
- Page Field in a PivotTable
- Formatting a PivotTable
- Creating/Modifying a PivotChart