Excel is a powerful tool that has become entrenched in business processes and is becoming a key when looking for a job.

In the day-to-day life of a company, Excel can be used to carry out algebraic operations which, although they are easy from the mathematical point of view, are not, in most cases, free of complications.

Therefore, since the late seventies became more than necessary the use of spreadsheets that simplified greatly the task of carrying out tasks such as analyzing balance sheets and income statements, investment selection, calculation of the financial and commercial forecasts of income, expenses, and future sales of the company in a given fiscal year.

How to prevent two users from editing the same file at the same time with Excel VBA

In this video, I demonstrate a way to work [...]

How to make paths dynamic so that Power Query connections work on Dropbox shared files

Case Scenario: You have a file on a Dropbox folder [...]

Selecting all Columns of a spreadsheet with Power Query does not get dynamic

In this video, I will demonstrate that when you [...]

WEBINAR – Fundamentals with Tips & Tricks of POWER QUERY in Microsoft Excel – Celia Alves

On April 12, 2020, I was honoured to present to [...]

Go to Top