UV Learn - Learning in Cloud made simple easy and effective

Excel Intermediate

1. Adjusting worksheet views

  1. Freezing and unfreezing panes
  2. Splitting screens horizontally and vertically
  3. Showing necessary information with the Outlining feature

2. Manage and Share Workbooks in Excel

  1. Share Workbooks
  2. Track Changes
  3. Accept and Reject Changes
  4. Formula Errors
  5. Error Tracking
  6. Assigning passwords to workbooks

3. IF, VLOOKUP, and Power Functions

  1. Using IF Functions and relational operators
  2. Getting approximate table data with the VLOOKUP function
  3. Getting exact table data with the VLOOKUP function
  4. Using the COUNTIF family of functions

4. Database Features

  1. Sorting data
  2. Inserting subtotals in assorted list
  3. Using filters
  4. Splitting data into multiple columns
  5. Removing duplicate records

5. Create and Manage Pivot Tables

  1. Pivot Tables
  2. Create Pivot Tables
  3. Recommended Pivot Table Buttons
  4. Format Pivot Tables
  5. Modify Field Headers
  6. Change the View of Data
  7. Group Records
  8. Calculated Field and Calculated Item
  9. Slicers
  10. View Chart Animations
  11. Install PowerPivot Add in
  12. Power Pivot
  13. Power Pivot Relationships
  14. Create Relationship between Tables
  15. Edit and Delete Relationship
  16. Create and Modify Power Pivot Hierarchy

6. Data Analysis Tools

  1. Using Goal Seek
  2. Using Solver
  3. Using Scenario Manager
  4. Using Data Tables

7. Introduction to Macros

  1. Definition and examples
  2. Creating a simple macro
  3. Running a macro

8. Conclusion

Coming soon..

Coming soon..

Coming soon..

© 2014 UV Learn. All rights reserved.