Welcoem to posts!!
in the future - u will be able to do some more stuff here,,,!! like pat catgirl- i mean um yeah... for now u can only see others's posts :c
CTRL + 9 - It hides the selected rows
Visit the website www.ExcelAndAdam.com/
Write adam@excelandadam.com
#excelhack #excel #exceltips #exceltutorial #exceltricks #exceltraining #shortcuts
#keyboardshortcuts
1 - 0
Ctrl + A – Select the entire sheet
Visit the website www.ExcelAndAdam.com/
Write adam@excelandadam.com
#excelhack #excel #exceltips #exceltutorial #exceltricks #exceltraining #shortcuts
#keyboardshortcuts
1 - 0
Main pitfalls when using Power Query. Watch out for them!
➡ Automatic steps - with every file import, Power Query performs a series of actions without our interference. All of these steps are contained in a formula that refers to all columns. If one is delet-ed, an error will occur.
➡ Modifying column names - if you change the name of a column in the data source, Power Query may not be able to import it or it will return an error because it did not find the previous name and does not know which column to transform.
Visit the website www.ExcelAndAdam.com/
Write adam@excelandadam.com
#excelandadam #excel #exceltips #exceltutorial #exceltricks #exceltraining
1 - 0
What is a cell in Excel?
A cell is a single rectangular element 😉 of a worksheet in Excel, which is determined by the inter-section of a column and a row. Each cell can contain various types of data, such as numbers, text, formulas, dates, times, and even images or charts.
In Excel, each cell has a unique address determined by the column letter and row number, for ex-ample, "A1" denotes the cell in the first column and first row. Data can be entered directly into a cell or formulas can be used to calculate the value in the cell based on other data.
Visit the website www.ExcelAndAdam.com/
Write adam@excelandadam.com
#excelandadam #excel #exceltips #exceltutorial #exceltricks #exceltraining
2 - 0
Benefits of using Power Query:
Power Query tool imports data from various sources, combines them, transforms them, and displays them as a report tailored to your needs.
➡ After importing, you can refresh data, make additional changes, and remove data from external sources.
➡ It allows data to be transferred or merged, allowing you to save disk space and avoid overloading the processor.
➡ It enables you to perform transformations with a few clicks, which were previously only available to advanced users, making Excel more accessible to you.
➡ All actions performed in this tool are recorded, giving you the ability to modify them at any time.
Visit the website www.ExcelAndAdam.com/
Write adam@excelandadam.com
#excelandadam #excel #exceltips #exceltutorial #exceltricks #exceltraining
2 - 0
There are many possibilities for conditional formatting in Excel, and some of the most popular ones include:
1. Value-based formatting - allows you to specify a format for values that meet a certain nu-merical condition, such as greater than, less than, equal to, not equal to, etc.
2. Date-based formatting - allows you to specify a format for date values that meet a certain condition, such as before, after, between, etc.
3. Text-based formatting - allows you to specify a format for text values that meet a certain condition, such as contains, does not contain, starts with, ends with, etc.
4. Formula-based formatting - allows you to incorporate formatting based on more complex calculations, such as mathematical or logical formulas that result in a true or false value or values equivalent to them.
Visit the website www.ExcelAndAdam.com/
Write adam@excelandadam.com
#excelandadam #excel #exceltips #exceltutorial #exceltricks #exceltraining
2 - 0
The History of Power Query in Excel, or Many Changes Over the Years.
➡ Power Query was created by Microsoft when they noticed they were falling behind in the de-velopment of technology that allows for data transformation.
➡ Initially, this method of data transformation was an add-on to another add-on, Power Pivot.
➡ Starting with Excel 2016, Power Query became an integral part of Excel, meaning we don't have to install a separate add-on. This feature exists as a group of commands called "Get & Transform Data" on the Data tab.
Visit the website www.ExcelAndAdam.com/
Write adam@excelandadam.com
#excelandadam #excel #exceltips #exceltutorial #exceltricks #exceltraining #history #PowerQueryhistory
2 - 0
ALT + ENTER – Inserting a new line of text in the same cell with text.
Visit the website www.ExcelAndAdam.com/
Write adam@excelandadam.com
#exceltips #exceltutorial #exceltricks #exceltraining #shortcuts #keyboardshortcuts #ex-celshortcuts
2 - 0
What is and what is the use of the Bubbles tool?
➡It is an add-in that allows you to surprise your clients or colleagues with interesting data visualization.
➡As the name suggests, this extension allows you to create bubble charts.
➡This way of presenting data is a great idea when we need to present a given population or regional trends.
➡You can install this add-in in newer versions of Excel by clicking on the "Get Add-ins" command on the Insert tab and searching for it by its name
Visit the website www.ExcelAndAdam.com/
Write adam@excelandadam.com
#excelandadam #excel #exceltips #exceltutorial #exceltricks #exceltraining
2 - 0
Excel shortcuts
CTRL + V ➡ Allows pasting of copied or cut text/formula or cell range
Visit the website www.ExcelAndAdam.com/
Write adam@excelandadam.com
#exceltips #exceltutorial #exceltricks #exceltraining #shortcuts #keyboardshortcuts #ex-celshortcuts
2 - 0
Hello, this is an Excel lover and Microsoft Most Valuable Professional - Adam Kopeć.
This channel will help you learn about Excel and its related programs:
Power Query
VBA
Power BI
Power Pivot
If you have a question, ask them under the video or write to adam (at) ExcelAndAdam.com