current location:Home > Technical Articles > Topics > excel

  • Excel LINEST function with formula examples
    Excel LINEST function with formula examples
    This tutorial explains the syntax of the LINEST function and shows how to use it to do linear regression analysis in Excel. Microsoft Excel is not a statistical program, however, it does have a number of statistical functions. One of such
    excel 471 2025-04-06 10:22:09
  • How to add a line in Excel graph: average line, benchmark, etc.
    How to add a line in Excel graph: average line, benchmark, etc.
    This short tutorial will walk you through adding a line in Excel graph such as an average line, benchmark, trend line, etc. In the last week's tutorial, we were looking at how to make a line graph in Excel. In some situations, however,
    excel 587 2025-04-06 10:21:09
  • IF AND in Excel: nested formula, multiple statements, and more
    IF AND in Excel: nested formula, multiple statements, and more
    This tutorial demonstrates how to combine Excel's IF and AND functions to evaluate multiple conditions within a single formula. The IF function's versatility is highlighted, showcasing its ability to handle various scenarios. Excel's IF and AND func
    excel 755 2025-04-06 10:16:10
  • How to subtract in Excel: cells, columns, percentages, dates and times
    How to subtract in Excel: cells, columns, percentages, dates and times
    The tutorial shows how to do subtraction in Excel by using the minus sign and SUM function. You will also learn how to subtract cells, entire columns, matrices and lists. Subtraction is one of the four basic arithmetic operations, and eve
    excel 251 2025-04-06 10:15:10
  • Linear regression analysis in Excel
    Linear regression analysis in Excel
    This tutorial explains the fundamentals of regression analysis and demonstrates several methods for performing linear regression in Excel. Imagine needing to predict your company's sales for next year, considering numerous influencing factors. Regre
    excel 461 2025-04-06 10:05:12
  • Find, label and highlight a certain data point in Excel scatter graph
    Find, label and highlight a certain data point in Excel scatter graph
    This tutorial demonstrates how to identify, highlight, and label specific data points within an Excel scatter chart, defining their precise x and y-axis positions. This is particularly useful when dealing with numerous data points, making it difficu
    excel 263 2025-04-06 09:48:10
  • TRANSPOSE function in Excel to change column to row with formula
    TRANSPOSE function in Excel to change column to row with formula
    This tutorial explains the Excel TRANSPOSE function, demonstrating its use in efficiently changing data orientation between rows and columns. Different users prefer different data arrangements, and TRANSPOSE offers a quick solution. - Understanding
    excel 241 2025-04-06 09:45:10
  • How to customize or stop AutoCorrect in Excel
    How to customize or stop AutoCorrect in Excel
    This tutorial shows you how to master Excel's AutoCorrect feature, from basic usage to advanced customization and disabling. AutoCorrect isn't just for spelling; it can transform abbreviations, insert symbols, and more. Let's explore its capabilitie
    excel 175 2025-04-06 09:36:13
  • Excel VALUE function to convert text to numbers
    Excel VALUE function to convert text to numbers
    This tutorial explains how Excel's VALUE function converts text strings into numerical values. While Excel usually handles number-as-text automatically, data in unrecognizable formats can remain as text, preventing calculations. The VALUE function
    excel 248 2025-04-06 09:29:08
  • Excel IF OR statement with formula examples
    Excel IF OR statement with formula examples
    This tutorial demonstrates how to use Excel's IF and OR functions together to evaluate multiple conditions. The IF function is powerful on its own, but combining it with logical functions like OR significantly expands its capabilities. IF OR Stateme
    excel 578 2025-04-06 09:27:12
  • How to use Goal Seek in Excel to do What-If analysis
    How to use Goal Seek in Excel to do What-If analysis
    This tutorial demonstrates how to use Excel's Goal Seek feature (available in Excel 365 and versions from 2010 onwards) to achieve a desired formula result by adjusting an input value. What-If Analysis, a powerful yet often underutilized Excel tool,
    excel 264 2025-04-06 09:17:09
  • Absolute value in Excel: ABS function with formula examples
    Absolute value in Excel: ABS function with formula examples
    This tutorial explains the concept of absolute value and demonstrates practical Excel applications of the ABS function for calculating absolute values within datasets. Numbers can be positive or negative, but sometimes only positive values are neede
    excel 476 2025-04-06 09:12:13
  • How to spell check in Excel
    How to spell check in Excel
    This tutorial demonstrates various methods for spell-checking in Excel: manual checks, VBA macros, and using a specialized tool. Learn to check spelling in cells, ranges, worksheets, and entire workbooks. While Excel isn't a word processor, its spel
    excel 1026 2025-04-06 09:10:10
  • How to make a line graph in Excel
    How to make a line graph in Excel
    This tutorial provides a comprehensive guide to creating and customizing line graphs in Excel. Learn how to leverage this versatile chart type to effectively visualize trends and data relationships. Line graphs, while simple, are powerful tools for
    excel 762 2025-04-06 09:07:08
  • Data table in Excel: how to create one-variable and two-variable tables
    Data table in Excel: how to create one-variable and two-variable tables
    This tutorial demonstrates how to leverage Excel's data tables for powerful What-If analysis. Learn to build one-variable and two-variable data tables to visualize the impact of input changes on your formulas, and discover how to analyze multiple fo
    excel 420 2025-04-06 09:05:09

Tool Recommendations

jQuery enterprise message form contact code

jQuery enterprise message form contact code is a simple and practical enterprise message form and contact us introduction page code.
form button
2024-02-29

HTML5 MP3 music box playback effects

HTML5 MP3 music box playback special effect is an mp3 music player based on HTML5 css3 to create cute music box emoticons and click the switch button.

HTML5 cool particle animation navigation menu special effects

HTML5 cool particle animation navigation menu special effect is a special effect that changes color when the navigation menu is hovered by the mouse.
Menu navigation
2024-02-29

jQuery visual form drag and drop editing code

jQuery visual form drag and drop editing code is a visual form based on jQuery and bootstrap framework.
form button
2024-02-29

Organic fruit and vegetable supplier web template Bootstrap5

An organic fruit and vegetable supplier web template-Bootstrap5
Bootstrap template
2023-02-03

Bootstrap3 multifunctional data information background management responsive web page template-Novus

Bootstrap3 multifunctional data information background management responsive web page template-Novus
backend template
2023-02-02

Real estate resource service platform web page template Bootstrap5

Real estate resource service platform web page template Bootstrap5
Bootstrap template
2023-02-02

Simple resume information web template Bootstrap4

Simple resume information web template Bootstrap4
Bootstrap template
2023-02-02

Cute summer elements vector material (EPS PNG)

This is a cute summer element vector material, including the sun, sun hat, coconut tree, bikini, airplane, watermelon, ice cream, ice cream, cold drink, swimming ring, flip-flops, pineapple, conch, shell, starfish, crab, Lemons, sunscreen, sunglasses, etc., the materials are provided in EPS and PNG formats, including JPG previews.
PNG material
2024-05-09

Four red 2023 graduation badges vector material (AI EPS PNG)

This is a red 2023 graduation badge vector material, four in total, available in AI, EPS and PNG formats, including JPG preview.
PNG material
2024-02-29

Singing bird and cart filled with flowers design spring banner vector material (AI EPS)

This is a spring banner vector material designed with singing birds and a cart full of flowers. It is available in AI and EPS formats, including JPG preview.
banner picture
2024-02-29

Golden graduation cap vector material (EPS PNG)

This is a golden graduation cap vector material, available in EPS and PNG formats, including JPG preview.
PNG material
2024-02-27

Home Decor Cleaning and Repair Service Company Website Template

Home Decoration Cleaning and Maintenance Service Company Website Template is a website template download suitable for promotional websites that provide home decoration, cleaning, maintenance and other service organizations. Tip: This template calls the Google font library, and the page may open slowly.
Front-end template
2024-05-09

Fresh color personal resume guide page template

Fresh color matching personal job application resume guide page template is a personal job search resume work display guide page web template download suitable for fresh color matching style. Tip: This template calls the Google font library, and the page may open slowly.
Front-end template
2024-02-29

Designer Creative Job Resume Web Template

Designer Creative Job Resume Web Template is a downloadable web template for personal job resume display suitable for various designer positions. Tip: This template calls the Google font library, and the page may open slowly.
Front-end template
2024-02-28

Modern engineering construction company website template

The modern engineering and construction company website template is a downloadable website template suitable for promotion of the engineering and construction service industry. Tip: This template calls the Google font library, and the page may open slowly.
Front-end template
2024-02-28