@LSEfinance

@LSEfinance

CheatSheets

@The_CheatSheets

How to alternate row colors in Excel!

🗂️ Don’t forget to save this post!

#excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials

Level up in Excel + AI in one hour!!! 💃🏼 You’re invited to a FREE live Excel + AI class with Miss Excel!

• Session 1 - Wed, May 31 at 9am EST: event.webinarjam.com/register/54/mg…
• Session 2 - Thur, June 1 at 2pm EST: event.webinarjam.com/register/55/6o…

Note: This tweet contains affiliate links

In this 1 hour power-packed session, you will learn our top Excel tricks + tips on how to leverage AI Tools like ChatGPT to save you hours in your week!

🗓️ Two date / time options (same content at each):
• Wed, May 31 at 9am EST
• Thur, June 1 at 2pm EST

Read 5 tweets

CheatSheets

@The_CheatSheets

How to make a dynamic calendar in Excel!

🗂️ Don’t forget to save this post!

#excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials

Level up in Excel in one hour!!! 💃🏼 You’re invited to a FREE live Excel class with Miss Excel!

🤍 Register Now + 24 Hour Replay: linktr.ee/CheatSheets

#excel #exceltips #exceltricks #ai #spreadsheets #corporate #accounting #finance #workhacks #tutorials

Read 5 tweets

CheatSheets

@The_CheatSheets

How to use the series tool in Excel!

🗂️ Don’t forget to save this post!

#excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials

Level up in Excel in one hour!!! 💃🏼 You’re invited to a FREE live Excel class with Miss Excel!

🤍 Register Now + 24 Hour Replay: linktr.ee/CheatSheets

#excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials

Read 5 tweets

CheatSheets

@The_CheatSheets

🎬 If you can’t make it live, replays will be available for 24 hours - however extra presents for those who come live!

✨ Once registered, remember to save the date into your favorite calendar app!

🍹 Have your computer and favorite drink ready! (This will be fun I promise!!!)

Read 4 tweets

CheatSheets

@The_CheatSheets

How to translate in Google Sheets!

🗂️ Don’t forget to save this post!

#excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials

Level up in Excel in one hour!!! 💃🏼 You’re invited to a FREE live Excel class with Miss Excel!

🤍 Register Now + 24 Hour Replay: linktr.ee/CheatSheets

#excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials

Read 5 tweets

Seed Captain

@SeedCaptainX

1/8📢Exciting news! Stefan Tanase, Senior consultant in Crypto Accounting will be one of the speakers at the upcoming #SeedCaptain Conference!

Don't miss his insights on the future of crypto and blockchain.

Check out more about his experience 🧵👇

#CryptoAccounting #MultiversX

2/8 💱Stefan works at JASILL Accounting Business. His work focuses on implementing fiscal policies and integrating them into the blockchain field. He has extensive experience in the emission and transaction of cryptocurrencies.

#cryptoregulation #Accounting

3/8 ⏳ Stefan worked in the financial domain for 7 years and has been involved in the crypto universe since 2018. Despite being a newcomer, he has structured and translated the transactional flow of the most renowned crypto exchange in Romania into accounting language.

#Finance

Read 8 tweets

Adil Abbasi

@adil_abbasiacma

As a #SmallBusiness owner, it's vital to stay on top of the latest trends in #Accounting and #Finance.

Here are the most important trends you should be aware of.

1/ One of the most significant trends is the increased focus on #Sustainability and #ESG reporting. Consumers...👇

and investors are placing greater importance on a company's impact on the environment and society, making sustainability reporting more crucial than ever.

2/ Another trend is the increased use of cloud-based solutions. With cloud-based accounting and...👇

finance software, businesses can store and access financial data from any location, allowing for greater collaboration and flexibility within teams.

3/ Data analytics is another trend that businesses should take note of. With the increasing availability of financial...👇

Read 7 tweets

Equitymaster

@Equitymaster

Smallcaps have a reputation of being risky, unlike their bigger peers. However, Richa Agarwal, Editor of Hidden Treasure (Equitymaster's smallcap recommendation service) and her team, have broken this myth. #smallcapstocks

Since inception in Feb 2008 until September 22, the verified IRR (Internal rate of return) for Hidden Treasureis at 26.9%, beating benchmark indices by almost 3x.Here's is what I expect for smallcaps in 2023. #SmallcapMultibaggers #topsmallcapsfor2023

Some reflections first…2022 was a challenging year with Russia Ukraine war, supply chain disruptions, inflationary pressures, tech meltdown, slowdown in global economies and locks downs in China. And the rough ride is not over.

Read 19 tweets

Ajay

@ajay_invests

Net Cash Flow is an important metric many investors look at when researching companies.

But do you know that cash flows can be easily manipulated?

Let's see how:

#investing #finance #FinancialFreedom #Accounting

The Cash Flow Statement is one of the three most important financial statements of a company.

The other two being P&L Statement and the Balance Sheet.

Balance Sheet shows us the assets and liabilities of the company and is very important to look at when analyzing cash flows.

Cash position of a company has an inverse relation with Assets and a direct relation with Liabilities.

For e.g., you BURN cash to acquire an Asset. So when Assets increase, the cash position DECREASES.

On the corollary, an increase in Liabilities INCREASES the cash position.

Read 7 tweets

The Secret CFO

@SecretCFO

1/ I’m new here so thought I’d introduce myself.

I’m a career corporate CFO.

I specialise in very large private businesses (10 figure+ revenue biz)

I’ve been lucky to work with billionaire entrepreneur CEOs, and some outstanding listed CEOs

#accounting #accountant #finance

2/ I started in the Big 4, then jumped out 2 days after I qualified.

Then moved into FP&A / commercial roles initially in very large corporates.

I became CFO of a $1bn revenue consumer business whilst still 30 and have since done 10 years as CFO of very large and businesses

3/ I’m currently a few years into a high profile turnaround of a global business with listed securities, hence the anon account.

Most of my career has been in retail, leisure, consumer or manufacturing.

As well as finance, I have run procurement, IT, supply chain, commercial.

Read 9 tweets

Risk Manager(ERM/Actuarial Sciences/Quant)

@SAH16928046

Should you pair #Finance with #Economics or #Accounting?
If you want to work in a general finance department, Accounting and Finance combination is beneficial, you can presumably learn a bit of financial auditing in this way.
@LSEfinance

If you want to work in Financial Markets, then Economics and Finance blend well.
But do note: that Economics is more mathematical.
Students who are weak at Maths, generally opt for Accounting or some other subject.

But having said that, if you don't like Maths at all, it might even be more difficult for you to do Quantitative Finance Modules at a higher level. So your aptitude and interests in Mathematics shall determine the outcome.

Read 5 tweets

Risk Manager(ERM/Actuarial Sciences/Quant)

@SAH16928046

Planning to do an #MBA without having any work experience.
Don't do it!
It's a sheer waste of money, time and energy.

In any case, you don't need to learn to invest $70,000+ in case studies, symposiums and business seminars.
If you have that much money, better opt for a specialized qualification which leads to skill development, or why not start your own venture using rational common sense?

By the way, have you ever asked your business studies professor if he or she has ever worked for a day in any organization on a full-time basis?
Most of these top-notch business studies/management science scholars have little to no practical experiences to share.

Read 6 tweets

PiggyBack

@PiggybackStocks

1 New to investing?

2 Confused by #fintwit jargon?

3 Do we trust people presenting “valuation” to know what they don't know?
(Hint: “my-laser-eyed-golden-skin-ape-pic-is-worth-at-least-twice-your-diamond-skin-ape-pic” = relative pricing. Not valuation)

Follow #PiggyBack🧵

1/X

Equity = Assets - Liabilities

But what asset and liability values are we going to use?

The answer as always: it depends on what we are going to use it for.

Here is a summary of equity metrics, from the most conservative:

2/X

Price/”Net-Net” Working Capital (P/NNWC)

Classic Graham/Dodd strategy

Assumes: Use only most liquid current assets, deduct subjective discounts.

Conditions (often missed in screens):
1) Not consuming assets (melting ice cube/negative cash-flow)
2) Historical profitability

3/X

Read 28 tweets

Outside Peek

@Outsidepeek_ng

Role: Chief Financial Officer
Location: Ikoyi, Lagos
Industry: Fashion and Lifestyle

Our client, a Fast growing retail business is looking to fill the role of a Chief Financial Officer

*Responsibilities*
*The Chief Financial Officer will perform a wide range of responsibilities.These may include, but are not limited to: .
* #Assess and evaluate the financial performance of the organization about long-term operational goals, budgets, and forecasts.

* #Provide insight and recommendations to both short-term and long-term growth plans of the organization.
* #Identify, acquire and implement systems and software to provide critical financial and operational information.
* #Evaluate departments and make suggestions for

Read 17 tweets

Risk Manager(ERM/Actuarial Sciences/Finance)

@SAH16928046

An Economics/Finance PhD is still probably one of the few degrees that provides you with an opportunity to start a career in either academia or elsewhere in the corporate sector, preferably Finance or the Govt Sectors.
But, always try to gain some practical experiences after BS

I don't like this concept of pushing students after undergrad level directly into a PhD program.
Especially, if the student has an opportunity to learn some practical skills in the real world.
Economics is that sort of profession, where many jump using the 3+1 research route.

I mean, what is the point of blindly doing a doctorate when you cannot operate basic IT Systems & Computing Packages that will help you work as an economist at banks, funds, etc
Attending colloquiums, seminars and conferences, co-authoring n publishing papers, etc won't help.

Read 7 tweets

Risk Manager(ERM/Actuarial Sciences/Finance)

@SAH16928046

Different professions require distinct applied skill sets
1. Working as a #quality systems controller in the dairy industry, a degree in total quality management will not suffice alone!
You need to have some awards in veterinary sciences & nutrition sciences or food science/tech

2. Working in the Insurance Industry with just a degree in Actuarial Sciences cannot help per se.
The Actuarial Risk Aspirants must develop an understanding of #Insurance Underwriting Methods, Insurance Business Models, Insurance Law & Accounting, in addition to Maths and Stats.

3. The same holds true for those who graduate with qualifications in Financial Engineering or FINTECH, etc.
Students must develop an understanding of financial products, laws, exchanges, etc
Blindly applying quantitative models to events or observable data won't take you anywhere

Read 18 tweets

Chris Hervochon, CPA, CVA

@ChrisHervochon

It's #RPA Sunday and I am going to Tweet along while I try to build a bot to solve a specific problem that I'm having with a client.

Thread 👇

#CPA #accounting #automation

Use case: I have a relatively new client with an OOC chart of accounts. The original P&L consisted of 218 accounts: 4 revenue, 129 COGS and 85 OPEX.

@QuickBooks

After some convincing, we were able to get COGS down to 6 accounts, but it took me about 3 hours to do YTD reclasses using the @QuickBooks "Reclassify" tool. That's what I am trying to avoid as we migrate the OPEX accounts to our template COA.

Read 24 tweets

Risk Manager(Banks,Asset Management,Insurance)

@SAH16928046

Most of the #MBA Finance students who attended my masterclass in Investments and Portfolio Management did not know how to use the #VLOOKUP or #VLOOKDOWN XLS Functions
Most of them completed graded courses in CS.
And then students complain about the standard of business education?

Not only that!
Most of the MBAs specializing in Finance that apply for Industrial Placement Programs or internships, struggle to read and understand financial statements.
Does that surprise you?
Not me!
Because Finance Majors are not necessarily good at using #Accounting or #IFRS

I am dead against an MBA Finance Degree.
its neither fish nor fowl
You cannot become a Financial Planner only by reading business case studies or solving a few exercises or writing project reports using standard formats
Better opt for an MS or MSc in Finance with a focus on Maths

Read 10 tweets

Risk Manager(Banks,Asset Management,Insurance)

@SAH16928046

There is an obscure problem when you join the BIG-4 Advisory or auditing, or consulting side of the profession within the services sector.
Most of the co-workers come from an #Accounting background, which makes things awfully difficult to communicate and interpret.

I remember working with an #Audit Expert, having a BIG-4 background.
The chap didn't understand anything except for debit, credit, and fraud risk.
The assignment required to be sophisticated Actuarial Finance, Mathematics, and Econometric Skill Sets to understand the GAPS.

Hence, the biggest problem in the Financial Risk Management, #ERM, Quantitative Risk Management, and other FE Financial Engineering related risk management processes, when working with a #BIG4 Firm, is the interaction with Accountants and Auditors who have their own Lingua Franca

Read 12 tweets

Risk Manager(Banks,Asset Management,Insurance)

@SAH16928046

@ABABankers

What are new graduates doing to be attractive to banks entry-level analyst programs?
@ABABankers @TheBanker @CIOonline @RiskDotNet @FT

Interesting question.
Banking sector MTO - Management Trainee Officers Program vary from country to country.
In my country Bank Staff Colleges train young graduates to become bankers.

The hired graduates have to undergo an intensive training course by attending several In-house boot camps or lecture hall workshops before they are moved into the formal workplace.

Read 38 tweets

Risk Manager(Banks,Asset Management,Insurance)

@SAH16928046

@PRMIA

Which are some interesting stylized facts about Risk Management and IAD Failures across global corporations?
@PRMIA @GARP_Risk @BIS_org

Quantitative Risk Management when turned into a profession, does not work in reality in most cases, as witnessed now outside the Insurance Sector!
Insurance is different because the profession is led by well-trained quantitative professionals such as Actuaries!

The multiple reasons for the failure of Risk Management and Auditing Departments at firms could be the following =>

Read 19 tweets

Discover and read the best of Twitter Threads about #Accounting

Most recents (24)

Related hashtags

Discover and read the best of Twitter Threads about #Accounting

Most recents (24)

Related hashtags

Did Thread Reader help you today?