excel

8 Articles 0 Followers


Demo - Baselining Excel with Baseledger and Trustmesh

10 Jun 2022 2 minute read 0 comments Dan

*** It is recommended that you do the "How to drop a proof" guide before attempting this one This is a simplified guide based on the instructions in the official Baseledger Docs https://docs.baseledger.net/howtos-1/how-to-sync-two-excel-sheets-with-b...

QSTICK indicator, use and construction with excel

23 Mar 2021 1 minute read 0 comments trade60

  The formula for calculating the qstick indicator with excel is as follows: moving average n periods of (closing-opening) This indicator was created by Tushar Chande and measures buying and selling pressure without considering volumes.When the price...

Principal Component Analysis - a short explanation

3 Mar 2021 2 minute read 1 comment Karina

  The principal component analysis is a procedure that uses an orthogonal transformation to convert a set of data that has correlated variables into a set of uncorrelated variables called principal components. This is used to get rid of redundant inf...

Top 10 Excel shortcuts I use to increase productivity!

18 Jan 2021 1 minute read 0 comments sicornel

Do you want to act “like a boss” using excel? Or significantly improve your speed when you work in excel? Just go through this simple shortcuts that can really make the difference in your daily job. CRTL + HOME: always bring user to cell A1 CRTL + E...

Excel Formulas: SUM

23 Jun 2020 1 minute read 0 comments MetaCryptoHunter

Today we are going to learn about the basic function of the SUM formula. This formula comes in handy when you need to add many cells within a table without having to manually add them yourself. See below for further details: SUM =SUM(value1,value2,va...

Introduction to Excel

23 Jun 2020 1 minute read 0 comments MetaCryptoHunter

Introduction to Excel What is Excel? Why will I ever use it? In this introduction to Excel I will be discussing various points on the practicality on using Excel and the many ways to improve your workbooks. Excel is a program belonging to the Micros...

Mastery Courses - Microsoft Excel, Word, Unlock Macros & VBA - FREE UDEMY COURSES

16 Jun 2020 1 minute read 1 comment Otek

  Hi guys, During a COVID-19 everyone have a hard time. Some of us lose their jobs, and almost whole economy is down. But in that situation is a one thing that is positive - we got so much more free time. How to use that time? In my opinion best opt...

Excel for Small Business

4 Jul 2019 2 minute read 0 comments Djmssr

                In earlier years predating the birth of the home computer, the most commonly know methods of tracking any given set of data was as simple as grabbing a legal pad or even a pad of graph paper, and charting of the basics of what ever it...