Essential Level Excel Training

Our most popular course. You will learn how to create templates for commonly used worksheets. Learn how to apply filters and sort data into key elements. Getting Excel to make decisions using the If function, Pivot Table and conditional formatting.

Existing Excel users whom have not had any formal training finds this course extremely useful, as it will bridge the gap in your knowledge of Excel.

Content:

• Introduction to Excel Screen Excel Ribbon
• Excel Ribbon
• Tabs, Contextual Tabs
• Quick Access Tool bar
• Overview of 2003, 2007, 2010, 2013
• Basics of Excel
• Various ways of Entering Data into Excel
• Cell, Rows, Columns, Range, Name Box
• Entering Formulas in Excel BODMAS Rule
• Alignment, Merge Cell, Wrap Text
• Text, Number Formatting
• Entering Data in Next Line within single cell
• Worksheets & Workbooks
• Insert, Delete, Move, Copy, Group Sheetsbr
• Insert, Delete Rows/Columns
• Freeze Headings
• Various ways of selecting Data
• Selecting Non Continuous Range
• Shortcuts & Techniques
• Basic Formulas & Functions
• Using sample formulas
• Using AutoSum, Average, Min and Max
• Fill Series
• Introduction to AutoFill
• Various ways to apply Fill Series
• Number Fill Series Based on Stop Value
• Inbuilt Fill Series for Text
• Custom based Text Fill Series
• Cell Referencing
• Core concept of Excel Cell Addressing Absolute Referencing Relative Referencing
• Sorting & Filtering
• Auto Filter - Shortcut
• Text Filter Begins With, Contains, Ends With
• Number Filter Top 10, Above Average
• Sorting Custom Sort
• Sort Based on Color, Multilevel Sorting
• Text & Date Functions
• UPPER, LOWER, PROPER, TRIM, CLEAN
• LEFT, RIGHT, MID
• Text to Columns
• DATE, YEAR, MONTH, DAY, TEXT
• TIME, HOUR, MINUTE, SECOND
• Lookup Function
• VLOOKUP Exact, Approximate Match
• Data Validation
• Restrict Values based on Number Drop-Down List for Text Restriction
• Pivot Tables
• Creating Pivot Table
• Sum, Average, Count Function in Pivot
• Hide/View Subtotal
• Report Filter
• Better way of representing Data in Pivot Table
• Working with Charts
• Inserting Chart Column Chart, Pie Chart
• Adding/Deleting Data in Chart
• Charting Option Legend, Axis, Layout, Styles
• Multiple Charting
• Working with Charts
• Savings in different Formats
• Saving with Password Protection
• Saving Excel Files
• Saving in different Formats
• Saving with Password Protection
• Printing Techniques
• Repeat the Rows/Columns in Multiple Pages
• Page Orientation
• Header/Footer
• View/Hide Grid Lines