Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

Intellezy Office 365 Excel

Video Introducing this tutorial


Introduction :
Introduction

Customizing Excel:
Customizing the Ribbon
Customizing the Quick Access Toolbar
Customizing the General and Formula Options
Customizing the AutoCorrect Options
Customizing the Save Defaults
Customizing Advanced Excel Options

Analyzing Data with Logical Functions:
Working with the Most Common Logical Functions
Understanding IF Functions
Evaluating Data with the AND Function
Evaluating Data with the OR Function
Creating a Nested IF Function
Using the IFS Function
Summarizing Data with SUMIF
Summarizing Data with AVERAGEIF
Summarizing Data with COUNTIF
Summarizing Data with MAXIFS and MINIFS
Using the IFERROR Function

Working with Lookup Functions:
What are Lookup Functions?
Using VLOOKUP
Using HLOOKUP
Using VLOOKUP with TRUE
Using HLOOKUP with TRUE
Using the Index Function
Using the MATCH Function
Combining INDEX and MATCH
Comparing Two Lists with VLOOKUP
Comparing Two Lists with VLOOKUP and ISNA

Using Text Functions:
What are Text Functions?
Using CONCAT, CONCATENATE, AND TEXTJOIN
Using Text to Columns
Using LEFT, RIGHT, and MID Functions
Using UPPER, LOWER, and PROPER Functions
Using the LEN Function
Using the TRIM Function
Using the SUBSTITUTE Function

Working with Date and Time Functions:
What are Date and Time Functions?
Using TODAY, NOW, and DAY Functions
Using NETWORKDAYS and YEARFRAC Functions

Formula Auditing:
Showing Formulas
Tracing Precedents and Dependents
Adding a Watch Window
Error Checking

What-If Analysis:
Using the Scenario Manager
Using Goal Seek
Analyzing with Data Tables

Worksheet and Workbook Protection:
Understanding Protection
Encrypting Files with Passwords
Allowing Specific Worksheet Changes
Adding Protection to Selected Cells
Additional Protection Features

Automating with Macros:
What are Macros?
Displaying the Developer Tab
Creating a Basic Formatting Macro
Assigning a Macro to a Button
Creating Complex Macros
Viewing and Editing the VBA Code
Adding a Macro to the Quick Access Toolbar

Working with Form Controls:
What are Form Controls?
Adding a Spin Button and Check Boxes
Adding a Combo Box

Ensuring Data Integrity:
What is Data Validation?
Restricting Data Entry to Whole Numbers
Restricting Data Entry to a List
Restricting Data Entry to a Date
Restricting Data Entry to Specific Text Lengths
Composing Input Messages
Composing Error Alerts
Finding Invalid Data
Editing and Deleting Validation Rules

Collaborating in Excel:
Working with Comments
Printing Comments and Errors
Sharing a Workbook
Co-Authoring in Excel
Tracking Changes in a Workbook
Working with Versions
Sharing Files via Email
Importing and Exporting Data to a Text File
Importing a Text File
Exporting Data to a Text File

Conclusion:
Course Recap1min