To ensure success, students should have completed Logical Operations’ Microsoft® Office Excel® 2016: Basic level or have the equivalent knowledge and experience.
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.
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.
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
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
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
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
Topic 6A: VLookup Function
Topic 6B: HLookup Function
Topic 6C: Index and Match Function