MS Office Tutorial (Blackhat Consulting)

blackhat consulting
j2_a1@yahoo.com (ym/email)
call us: 09167654649



Excel
- Basic principles, data entry and manipulation, workbook navigation
- Presentation techniques, table formatting, charts
- Excel common functions, aggregates, conditionals, financials
- Multiple workbooks, data linking, imports and exports
- Data cleaning and conversion
- Excel data management and statistical analysis
- Report automation
- Spreadsheet models and ‘What if . . . ?” analysis
- Introduction to macros and VBA
PowerPoint
- Instant text-based presentations, slide design and layout.
- Tables and charts, drawing objects, graphics and multimedia
- Animation effects, building complex slides
- Creating handouts
- Action settings, hyperlinks, seamless presentations
- Templates and the slide master
- Building complex slides
Word
- Personal productivity, auto text and auto correct
- Text manipulation, keyboard shortcuts
- Complex documents, tables, columns, sections
- Document automation, headers and footers, table of contents
- Navigation, hyperlinks, references
- Word templates, styles, form controls, protection
- Editing and reviewing tools
- Advanced Find and Replace techniques