Head Office Chabahil -7 4484097, 9851023208, 9801076620 info@blackhawk.edu.np

 Excel 2016 - Part 3

Excel 2016 - Part 3 Training in Kathmandu Nepal

1 - Working with Multiple Worksheets and Workbooks

  • Use Links and External References
  • Use 3-D References
  • Consolidate Data

2 - Using Lookup Functions and Formula Auditing

  • Use Lookup Functions
  • Trace Cells
  • Watch and Evaluate Formulas

3 - Sharing and Protecting Workbooks

  • Collaborate on a Workbook
  • Protect Worksheets and Workbooks

4 - Automating Workbook Functionality

  • Apply Data Validation
  • Search for Invalid Data and Formulas with Errors
  • Work with Macros

5 - Creating Sparklines and Mapping Data

  • Create Sparklines
  • Mapping Data

6 - Forecasting Data

  • Determine Potential Outcomes Using Data Tables
  • Determine Potential Outcomes Using Scenarios
  • Use the Goal Seek Feature
  • Forecasting Data Trends

Career Opportunity

Get your admission now!

Enroll