Advanced Excel Formula Techniques, Time-Saving Functions and Charting Tips

In this course you will learn and practice Advanced Excel Functions - Excel Formulas And Excel Charts Tips which are most important and commonly used functions in Excel. Which helps the learner to perform complicated calculations, data analysis, and lots more.

Productivity

4 Hours

Description

To help ensure that everyone who works on the same workbook can understand what formulas and calculations are doing, it is important to use cell and range names. While cell references can be used to identify where formulas are getting information to calculate data, it is not always obvious. Excel allows you to give individual cells and cell ranges names, and then use those names in formulas and functions. Then, you can tell at just a glance what data is being used.

While the basic functions in Excel cover the majority of use cases, there are some situations where a specialized function is more appropriate. In order to find and use specialized functions, you must be familiar with their syntax and understand how they work on a fundamental level.

While pure data can be analyzed by those familiar with this data and the tools that Excel provides, sometimes you need graphical assistance to help interpret it. Additionally, charts are an enormous help when people do not have time to study the data and only need a brief overview of the relevant information. Over the course of this topic, you will learn how to create charts of different types, using different methods.

Course Objectives

Apply range names

Use specialized functions

Use text functions

Use logical functions

Use lookup functions

Use date functions

Use financial functions

Create charts

Modify and format existing charts

Create a trendline

Create advanced charts

Target Audience

Any Professional who would like to save time by learning more about advanced formulas, functions and visualizing data/charting

Basic Understanding

Foundational Excel knowledge would be helpful for this course.

Course Content

No sessions available.

Simpliv Logo
Simpliv LLC
39658 Mission Boulevard,
Fremont, CA 94539, USA

Advanced Excel Formula Techniques, Time-Saving Functions and Charting Tips

Session 1: CREATING ADVANCED FORMULAS

  1. Apply Range Names

    Range Names

    Adding Range Names Using the Name Box

    Adding Range Names Using the New Name Dialog Box

    Editing a Range Name and Deleting a Range Name

    Using Range Names in Formulas

  2. Use Specialized Functions

    Function Categories

    The Excel Function Reference

    Function Syntax

    Function Entry Dialog Boxes

    Using Nested Functions

    Automatic Workbook Calculations

    Showing and Hiding Formulas

    Enabling Iterative Calculations

Session 2: ANALYZING DATA WITH LOGICAL AND LOOKUP FUNCTIONS

  1. Use Text Functions

    Text Functions

    The LEFT and RIGHT Functions

    The MID Function

    The LEN Function

    The TRIM Function

    The UPPER, LOWER, and PROPER Functions

    The CONCATENATE Function

  2. Use Logical Functions

    Logical Functions

    Logical Operators

    The AND Function

    The OR Function

    The IF Function

  3. Use Lookup Functions

    Lookup Functions

    The LOOKUP Function

    The VLOOKUP Function

    The HLOOKUP Function

  4. Use Date Functions

    The TODAY Function

    The NOW Function

    Serializing Dates and Times with Functions

  5. Use Financial Functions

    The PMT Function

    The IPMT Function

    The PPMT Function

    The NPV Function

    The FV Function

Session 3: VISUALIZING DATA WITH CHARTS

  1. Create Charts

    Charts

    Chart Types

    Chart Insertion Methods

    Resizing and Moving the Chart

    Adding Additional Data

    Switching Between Rows and Columns

  2. Modify and Format Charts

    The Difference Between Modifying and Formatting

    Chart Elements

    Minimize Extraneous Chart Elements

    The Chart Tools Contextual Tabs

    Formatting the Chart with a Style

    Adding a Legend to the Chart

  3. Create a Trendline

    Trendlines

    Types of Trendlines

    Adding a Trendline

    The Format Trendline Task Pane

  4. Create Advanced Charts

    Dual Axis Charts

    Creating Custom Chart Templates

    Viewing Chart Animations

Coupons

No offers available at this time.

Live Support

Call

+510-849-6155

Mail to

support@simplivlearning.com

Similar Courses

Our Trusted Clients