Advanced Excel – In-Depth

Advanced Excel – In-Depth
Featured

Advanced Excel – In-Depth

Advanced Excel is a comprehensive tutorial that provides a good insight into the latest and advanced features available in Microsoft Excel. Tutorial with lots of screenshots that explain how to use a particular feature, in a step-by-step manner.

Audience

This tutorial has been designed for all those readers who depend heavily on MS-Excel to prepare charts, tables, and professional reports that involve complex data. It will help all those readers who use MS-Excel regularly to analyze data.

Prerequisites

The readers of this tutorial are expected to have a good prior understanding of the basic features available in Microsoft Excel.

Lessons

  1. What-IF Analysis

  2. Templates

  3. Charts Formatting Techniques

  4. Advanced Functions

  5. Data commands

  6. Manipulating Data & Named Ranges

  7. Auditing Worksheets

  8. Printing your worksheet

  9. Modifying the Pivot Table placement

  10. Pivot Charts

  11. Preparing to print a Worksheet

  12. Customizing Microsoft Excel

  13. Specific Formulas

  14. Creating custom number formats

  15. Named Ranges

  16. Form Controls

  17. Review of data and workbook protection

  18. Advanced Charts

  19. Preparing to print a Worksheet

  20. Excel Tips & Tricks Index

  21. Dates And Times In Excel

  22. Function & Formula Related

  23. Working with conditional formatting rules

No Comments

Post a Reply

Teachers