Topic 1 - Make a Start with Excel
- A first look at Excel 2013
- Excel Rows and Columns
- Enter text and numbers in a Cell
- How to edit text in a Cell
- How to Centre text and numbers
- Font Formatting in Excel 2013
- How to change the color of a Cell
- How to save your work in Excel
- Currency Symbols in Excel 2013
- How to Merge & Center
- Review Number One
- Use Auto Correct Option
- Use Format painter
- Use All Shortcut & Trikes
Topic 3 - Excel 2013 Charts
- How to Sort Data in Excel
- Create an Excel Chart
- Move and Resize your Chart
- Chart Styles and Layouts
- Chart Titles and Series Titles
- Chart Layout Panel in Excel 2013
- The Format Chart Panel
- Create a Pie Chart in Excel
- Add Labels to a Pie Chart
- Format Pie Chart Segments
- Create a 2D Line Chart in Excel
- Format your Axis Titles
- Predict the future with a Trend line Chart
- Sparkline Charts
Topic 5 - Functions in Excel 2013
- The Average Function
- The Date Function
- Time Functions in Excel
- A Time Table Project
- Financial Functions
- The Student Averages Project
- Use Maximum & Minimum Formula
- Use Product Formula
- Use Mod for Reminder
- Mathematics Formula
Topic 7 - Processing Data in Excel
- Data Tables in Excel 2013
- A Second Data Table
- Excel Scenarios
- Goal Seek
- Absolute Cell References
- Named Ranges in Excel 2013
- Create a Custom Name in Excel
- Excel Pivot Tables
- Pivot Tables, Part Two
- Reference other Worksheets
- The LOOKUP Function
- The VLOOKUP Function in Excel
- Create a Business Invoice, Part One
- Excel Business Invoice, Part Two
- Business Invoice, Part Three
Topic 9 – MIS Report in Excel 2013
- Use Concatenate Condition Option
- Merge First name last name
- first name with Left & Find Condition
- LEN and FIND Condition
- How to change (UPPER, LOWER, PROPER)
- Insert Date & Time Formula & Shortcut
- Change Roman Counting
- Learn Formula (MATCH, CHOOSE, WEEKDAY FUNCTION, TEXT, NETWORK DAYS, WORKDAY,TRIM, VALUE, LEN)
