Pages

1. EXCEL ENVIRONMENT

i). Navigating the excel interface.
ii). Customizing excel through excel options
iii). Difference Between a formula & a function
iv). The Functions library
v). Golden Rules of Functions

2. BASIC WORKBOOK SKILLS

i). Creating a workbook
ii). Selecting cells and ranges
iii). Opening, closing and saving workbooks
iv). Entering data into cells
v). Entering values into ranges

3. KEY FORMULA CONCEPTS

i). Writing formulas in cells
ii). Using the Formula Bar
iii). Copying Formulas (Best Practices Modeling)
iv). Mixed & Absolute Referencing
v).Linking worksheets and Workbooks

4. NAMED RANGES

i). Naming a range of cells
ii). Jumping to a named range
iii). Using range names in formulas
iv). Re-defining and deleting range names
v). Creating from Selection
vi). Apply Names
vii). Using Autofill

5. DATE & TIME FUNCTIONS

i). Now & Today
ii). Month, edate, eomonth
iii).Day, week, year
iv). Datedif, Networking days
v). Text function

6.DATA CLEANING

i). Trim
ii). Upper, Lower, Proper
iii). Left, Mid, Right
iv). Value
v). Concatenate
vi). Find and Replace
vii).Replace function

7. CONDITIONAL FORMATTING

i). Use of Highlight cell rules
ii). Use of Icon sets
iii). Use of Colour sets
iv). Top Bottom rules
v). Data bars & Colour scales

8. BIG DATA TECHNIQUES

i). Summing through sheets
ii). Consolidating workbooks
iii). Linking MS suite for auto updates
iv). Sub-Total feature
v). Grouping & Ungrouping

9 FORMATTING & STYLES

i).Format Painter & Cell Styles
ii). Cells merging & Wrap Text
iii). Number Formatting
iv). Freezing Rows, Splits
v). Formatting Best Practices

10. PRINTING

i). Choosing what to print
ii). Previewing and printing
iii). Page Setup
iv).Headers and footers
v). Repeating column/row headings
vi). Page Break Preview
vii). Printing gridlines

11. HYPERLINKS

i). Text
ii). Text Box
iii). Icons
v). To Web Sites
vi). To Other Files
vii). Printing gridlines

12. INTRODUCING EXCEL TABLES

i). Table Vs Range
ii). How to write formulas in excel tables
iii). Introducing Pivot Tables
iv). Slicer & Timeline
v). Formatting the pivot table
vi). Grouping in pivot tables
vii). Pivot charts

Proggramming Courses