Kaizen.Personal computer work.

Microsoft Excel functions and useful formulas.

  • Home
  • Books
    • Power Automate Cloud flows(Books)
    • Power Automate Desktop(Books)
      • Table of Contents. Power Automate Desktop(Books)
      • Update History. Power Automate Desktop(Books)
  • ChatGPT
  • Google Bard
  • Microsoft Excel
    • Functions(Microsoft Excel)
      • Math & Trig(Microsoft Excel Functions)
      • Statistical(Microsoft Excel Functions)
      • Text(Microsoft Excel Functions)
      • Date & Time(Microsoft Excel Functions)
      • Lookup & Reference(Microsoft Excel Functions)
      • Logical(Microsoft Excel Functions)
      • Database(Microsoft Excel Functions)
      • Information(Microsoft Excel Functions)
      • Web(Microsoft Excel Functions)
    • Introduction(Microsoft Excel)
    • Office Scripts(Microsoft Excel)
    • Tips. Others.(Microsoft Excel)
    • Tips. XLOOKUP & VLOOKUP & HLOOKUP(Microsoft Excel)
  • Power Automate Desktop
    • Actions(Power Automate Desktop)
      • Word(Power Automate Desktop Action)
      • Variables(Power Automate Desktop Action)
      • System(Power Automate Desktop Action)
      • Workstation(Power Automate Desktop Action)
      • Flow control(Power Automate Desktop Action)
      • Run flow(Power Automate Desktop Action)
      • File(Power Automate Desktop Action)
      • Folder(Power Automate Desktop Action)
      • Scripting(Power Automate Desktop Action)
      • Compression(Power Automate Desktop Action)
      • UI automation(Power Automate Desktop Action)
      • HTTP(Power Automate Desktop Action)
      • Browser automation(Power Automate Desktop Action)
      • Excel(Power Automate Desktop Action)
      • Database(Power Automate Desktop Action)
      • Email(Power Automate Desktop Action)
      • Outlook(Power Automate Desktop Action)
      • Message boxes(Power Automate Desktop Action)
      • Mouse and Keyboard(Power Automate Desktop Action)
      • Clipboard(Power Automate Desktop Action)
      • Text(Power Automate Desktop Action)
      • Date time(Power Automate Desktop Action)
      • PDF(Power Automate Desktop Action)
      • OCR(Power Automate Desktop Action)
      • Cryptography(Power Automate Desktop Action)
      • Windows services(Power Automate Desktop Action)
      • FTP(Power Automate Desktop Action)
    • Introduction(Power Automate Desktop)
    • Tips(Power Automate Desktop)
  • Power Automate(Cloud flows)
    • Connectors(Power Automate Cloud flows)
      • Control Connector(Power Automate Cloud flows)
      • Date Time Connector(Power Automate Cloud flows)
      • Excel Online (Business) Connector(Power Automate Cloud flows)
      • Gmail Connector(Power Automate Cloud flows)
      • Google Drive Connector(Power Automate Cloud flows)
      • Google Sheets Connector(Power Automate Cloud flows)
      • Mail Connector(Power Automate Cloud flows)
      • Notifications Connector(Power Automate Cloud flows)
      • Offce365 Outlook Connector(Power Automate Cloud flows)
      • OneDrive For Business Connector(Power Automate Cloud flows)
      • SharePoint Connector(Power Automate Cloud flows)
      • SMPT Connector(Power Automate Cloud flows)
      • Text Functions Connector(Power Automate Cloud flows)
    • Functions(Power Automate Cloud flows)
      • Collection Functions(Power Automate Cloud flows)
      • Conversion Functions(Power Automate Cloud flows)
      • Date and time Functions(Power Automate Cloud flows)
      • Logical Functions(Power Automate Cloud flows)
      • Math Functions(Power Automate Cloud flows)
      • String Functions(Power Automate Cloud flows)
    • Introduction(Power Automate Cloud flows)
    • Tips.(Power Automate Cloud flows)
  • Self Description.
  • Sitemap
  • Web tools
  • Python
  • Privacy Policy
  • Contact Form.
  • JavaScript
  • 
  • 

    Menu

  • 

    Sidebar

  • 

    Prev

  • 

    Next

  • 

    Search

  • Japanese version.
  •   RSS 
  •   Feedly 
  1. Home>
  2. Microsoft Excel>
  3. Introduction(Microsoft Excel)

Introduction(Microsoft Excel)

01/25/202306/15/2024

  • Twitter
  • Facebook
  • Pin it
  • LinkedIn
  • Pocket
Contents
  • 1. Oparation
    • 1.1. Cut, Copy and Paste.
  • 2. Cell Format
    • 2.1. Line break in a cell.
  • 3. Formura
    • 3.1. Frequently used operators.
    • 3.2. Relative cell reference and Absolute cell reference.
    • 3.3. Name Manager. Name cell ranges and formulas.
    • 3.4. Advanced
      • 3.4.1. Array formula
      • 3.4.2. Spill. Usage, advantages and disadvantages of Spill. (Dynamic array formulas.)
  • 4. Data
    • 4.1. Data Validation
    • 4.2. Filter
    • 4.3. Table
    • 4.4. OCR

Oparation

Cut, Copy and Paste.

Cut, Copy and Paste.(Microsoft Excel)

Cell Format

Line break in a cell.

Line break in a cell.(Microsoft Excel)

Formura

Frequently used operators.

Frequently used operators.(Microsoft Excel)

Relative cell reference and Absolute cell reference.

Relative cell reference and Absolute cell reference.(Microsoft Excel)

Name Manager. Name cell ranges and formulas.

Name Manager. Name cell ranges and formulas.(Microsoft Excel)

Advanced

Array formula

Array formula.(Microsoft Excel)

Spill. Usage, advantages and disadvantages of Spill. (Dynamic array formulas.)

Spill. Usage, advantages and disadvantages of Spill. (Dynamic array formulas.)

Data

Data Validation

Data Validation.(Microsoft Excel)

Filter

Filter(Microsoft Excel)

Table

Table features and how to use it.(Microsoft Excel)

OCR

Read text and table data from images.(Microsoft Excel)

Please share!

  • Twitter
  • Facebook
  • Pin it
  • LinkedIn
  • Pocket

Categories

Recent Posts

  • Append cells in Excel worksheet Action(Power Automate Desktop)
  • Auto fill cells in Excel worksheet Action(Power Automate Desktop)
  • Get table range from Excel worksheet Action(Power Automate Desktop)
  • Read formula from Excel Action(Power Automate Desktop)
  • Copy Excel worksheet Action(Power Automate Desktop)

Copyright © 2025 Kaizen.Personal computer work. All Rights Reserved.

WordPress Luxeritas Theme is provided by "Thought is free".

  • 
    Home
  • 
    Menu
  • 
    Page Top
 PAGE TOP
Go to mobile version