training@ipdc.co.id
+622150101483

Microsoft Office Excel 2016 Intermediate Course

No Date Location Register
1 27 - 27 Sep 2021 Please call us Register
2 25 - 25 Oct 2021 Please call us Register
3 29 - 29 Nov 2021 Please call us Register

PREREQUISITES

 

To ensure success, students should have completed Logical Operations’ Microsoft® Office Excel® 2016: Basic level or have the equivalent knowledge and experience.

OBJECTIVES

 

You will use advanced formulas and work with various tools to analyze data in spreadsheets. You will also present data as charts, and collaborate on worksheets. 

Upon successful completion of this course, students will be able to: 

 Working with Multiple Worksheets and Workbooks. 

       Analyze Data with Logical Functions. 

       Visualizing Data with Charts. 

       Using Text Functions. 

       Using Date and Time Functions. 

Analyzing Data with Lookup Functions. 

 

TARGET PARTICIPANTS

 

This course is designed for students who already have foundational knowledge and skills in Excel 2016 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.

COURSE CONTENTS

 

Lesson 1: Working with Multiple Worksheets and Workbooks 

Topic 1A: Moving or Copying Sheet to Other Workbooks 

Topic 1B: Creating and Editing a Range Name 

Topic 1C: Using Range names in a Formula 

Topic 1D: Calculate Data Across Worksheets 

Topic 1E: Consolidate Data 

Topic 1F: Linking Cells in Different Workbooks 

Topic 1G: Inserting Hyperlinks 

 

Lesson 2: Analyze Data with Logical Functions 

Topic 2A: Use IF Function 

Topic 2B: Use AND Function 

Topic 2C: Use OR Function 

Topic 2D: Combine the AND with IF Function 

Topic 2E: Combine the OR with IF Function  

 

Lesson 3: Visualizing Data with Charts 

Topic 3A: Create a Chart 

Topic 3B: Modify Charts 

Topic 3C: Format Charts 

 

Lesson 4: Using Text Functions 

Topic 4A: Functions to Convert between Upper and Lower Case 

Topic 4B: Cutting & Piecing Together Text Strings 

Topic 4C: Substituting Parts of a Text String 

Topic 4D: Removing Extra Spaces 

 

Lesson 5: Using Date and Time Functions 

Topic 5A: Using Current Date & Time 

Topic 5B: Extracting the Components of a Time 

Topic 5C: Extracting the Components of a Date

Topic 5D: Performing Calculations with Dates 

 

Lesson 6: Analyzing Data with Lookup Functions 

Topic 6A: VLookup Function 

Topic 6B: HLookup Function 

Topic 6C: Index and Match Function