際際滷

際際滷Share a Scribd company logo

Advance excel and powerpoint contents

Download as DOCX, PDF
A
aaalii

This document outlines a 14-day training course to advance skills in Excel and PowerPoint. The course covers conditional functions, formatting, lookups, sorting, filtering, charts, pivot tables, macros, templates, importing/exporting, animations, and customizing presentations. Participants will complete individual projects in Excel on days 9-10 and PowerPoint on days 13-14 to apply the skills learned.

Convert to study materialsBETA

Transform any presentation into ready-made study materialselect from outputs like summaries, definitions, and practice questions.

1 of 2
Download to read offline
ADVANCE EXCEL AND POWERPOINT CONTENTS DAY 1 CONDITIONAL FUNCTIONS,CONDITIONAL SUMS & AVERAGE AND TRIM DAY2 CONDITIONAL FORMATTING,LOOKUP,MATCH AND INDEX FUNCTIONS DAY 3 SORTING,SUBTOTAL,ADVANCE FILTER,CONSOLIDATION AND FORMS DAY 4 DATA VALIDATION AND DEPRECIATIONS DAY 5 GOAL SEEK,SOLVER AND SCENARIO DAY 6 FINANCIAL FUNCTIONS,NPV AND IRR DAY 7 FORMULA AUDITING,MACRO AND TRACK CHANGES DAY 8 CHARTS AND PIVOT TABLE DAY 9 & 10 PROJECT ON EXCEL 2007
DAY 11 TEMPLATES,THEMES,SLIDE MASTER,NOTES,HANDOUTS,SOUND AND VIDEO DAY 12 IMPORT AND EXPORT,CHART AND SMARTART,MOTION PATHS,ACTIONS BUTTON,CUSTOMISING SHOW AND PACKAGE FOR CD DAY 13 & 14 PROJECT ON POWERPOINT 2007

More Related Content

Advance excel and powerpoint contents

  • 1. ADVANCE EXCEL AND POWERPOINT CONTENTS DAY 1 CONDITIONAL FUNCTIONS,CONDITIONAL SUMS & AVERAGE AND TRIM DAY2 CONDITIONAL FORMATTING,LOOKUP,MATCH AND INDEX FUNCTIONS DAY 3 SORTING,SUBTOTAL,ADVANCE FILTER,CONSOLIDATION AND FORMS DAY 4 DATA VALIDATION AND DEPRECIATIONS DAY 5 GOAL SEEK,SOLVER AND SCENARIO DAY 6 FINANCIAL FUNCTIONS,NPV AND IRR DAY 7 FORMULA AUDITING,MACRO AND TRACK CHANGES DAY 8 CHARTS AND PIVOT TABLE DAY 9 & 10 PROJECT ON EXCEL 2007
  • 2. DAY 11 TEMPLATES,THEMES,SLIDE MASTER,NOTES,HANDOUTS,SOUND AND VIDEO DAY 12 IMPORT AND EXPORT,CHART AND SMARTART,MOTION PATHS,ACTIONS BUTTON,CUSTOMISING SHOW AND PACKAGE FOR CD DAY 13 & 14 PROJECT ON POWERPOINT 2007