Microsoft（マイクロソフト）の表計算ソフト「Excel（エクセル）」には、「関数」という便利な機能が豊富に用意されています。関数を使うことで、手動では手間がかかる計算や複雑な計算、特定の文字列を抽出するといった作業を簡単に処理することができ ...

エクセルの操作をわかりやすく解説するYouTubeチャンネル「おさとエクセル」。今回紹介するのは、選択した数値を小さい順に数えてX番目の数値を抽出する関数「SMALL関数」です。先に勉強したLARGE関数との違いも理解しましょう。 SMALL関数の設定方法を説明 ...

As I showed in my first Excel functions article, the serious meat in any spreadsheet is the formulas and functions that perform the calculations. Excel offers functions that you can use to make the ...

Often when you’re working with Excel you will use a calculation that is not available as a built-in Excel function. If you make this calculation repeatedly, you can save having to write the ...

Excel has built-in functions for sine and cosine, the two core trigonometric functions, and for hyperbolic sine and hyperbolic cosine, their hyperbolic counterparts. It also has built-in functions for ...

Excel is a spreadsheet with a lot of power. The software can be used to track inventory, track and calculate payroll and a myriad of other calculations. An Excel formula is generally composed of ...

Microsoft has recently added a new feature to excel in the form of the extremely useful Scan Function. This guide aims to provide a quick overview of how you can get the most from this new function ...