Jose Camacho

When you want to fill a series, enter the first two values in the series and drag the fill handle to extend the series. #msexcel #curso #cursoexcel #powerbi #exceltips #motivation #datascience #microsoftoffice #aprenderexcel #planilhas #dicasexcel #windows #dashboard #cursos #ado #exceltraining #like #excelbasico #dataanalytics

1

The wait is almost over... Get ready! #ComingSoon #microsoft #dicasexcel #excelbasico #motivation #o #word #cursos #ado #cursoexcel #aprenderexcel #microsoftoffice #datascience #office #n #business #planilhas #msexcel #powerbi #like #dashboard #microsoftexcel #powerpoint #excel #cursodeexcel #exceltips #windows #data #curso #exceltraining #dataanalytics

2

There are no more excuses for not learning EXCEL. ⬇️📉💹🚀 #excel #superexcel #aprendeexcel #cursoexcel #excel365 #excelgratis #excelparatodos #googlesheet #cursoexcel #exceltips #exceltricks

1

New Certification 🤩 !! thanks Maven Analytics If you like Data Analysis, Data Visualization and Data Modeling I totally recommend taking this course!!

20

5 comentarios

Stop making classic tables in Power BI , Enhance your tables With SVG so Easy ! Tutorial Spanish : https://lnkd.in/e_EbCerE Tutorial English : https://lnkd.in/eBGc6iJB #powerbi #svg #excel #dataviz #datascience #dataanalyst

177

Power BI: Visualizing Percentages & Parts of a Whole Power BI Design

1

How to use Copilot in Excel for non-Excel tasks Copilot in Excel can help with a variety of everyday tasks for working with your data, such as adding conditional formatting or creating basic calculated columns. But did you know that you can also use Copilot in Excel for some non-Excel tasks? In this post, we'll explore how this works and see how it could actually help in your day-to-day activities as an analyst. We'll look at using Copilot in Excel to retrieve general knowledge, to summarize and proofread text, and to help with technical questions (including, paradoxically, how to work with DAX measures, Power Query M code, and more.). Check out the full post with free download file on my website: https://lnkd.in/gaHbCrut

11

4 comentarios

Excel Shortcuts Tips by SHAVETA KHULLAR

8

1 comentario

How to understand the difference between beginner, intermediate, and advanced Excel As an Excel trainer and consultant, I’ve often encountered skepticism about categorizing skills into beginner, intermediate, and advanced levels. It’s understandable—Excel is a vast program, and users employ it in myriad ways. It’s rare to find two people with identical skill sets, and even rarer to find someone who fits neatly into a conventional skill level like “intermediate.” However, the complexity of defining skill levels in Excel shouldn’t deter us from trying, much like George Box’s observation that all models are wrong, but some are useful. This post explains the benefits of classifying skill levels and then takes an attempt at doing so. While there might be disagreements on the specifics—again, not everyone uses Excel in the same way—these levels provide a useful framework for discussion and learning. By establishing a common language to describe Excel proficiency, educators can better design curricula, employers can more accurately assess skills for job roles, and users can set clearer goals for their learning journey. You can take a look at the full post on my website and leave a comment: https://lnkd.in/gyfqjVsA

16

4 comentarios

First steps of creating a lakehouse in Fabric ✅ Follow me for more Fabric in Power Bl content 📥 Save this post for later #powerbi #data #fabric #analytics

224

4 comentarios

Boring tooltips bores you? 😴 Want cool tooltips? Watch this short video of mine! 🚀 #PowerBI #DataViz #Tooltips #DashboardDesign #PowerBITips

5

Pivot tables are great at summarizing data and they can also compare values and calculate differences #msexcel #spreadsheet #spreadsheets #excel #pivottable #pivottables

3

Unlock the Power of CTEs: Simplify and Optimize Your SQL Queries Still using subqueries in your WHERE clause? It's time to upgrade your SQL game with Common Table Expressions (CTEs)! 🚀 Check this out...!!! A Common Table Expression (CTE) is a temporary result set that you can reference within a ‘SELECT’, ‘INSERT’, ‘UPDATE’, or “DELETE’ statement. CTEs are defined using the ‘WITH’ clause and can simplify complex queries, making them more readable and maintainable. They are useful to break down complex queries into more manageable queries and for recursive queries. CTEs Features: ·        Temporary Scope ·        Readability and Maintainability ·        Recursive queries ·        Named Expressions See an example how CTE can be used instead of sub-query: By Defining the average salary calculation in the CTE, you can avoid the recalculating the average salary for each row in the main query. Thus, CTE can improve its performance, especially for larger datasets. #SQL #CTE #DataScience #BigData #DataAnalysis #TechTips #SQLPerformance #DatabaseManagement #Programming #TechCommunity #DataEngineering #CodeOptimization #LearnSQL #TechTricks #DataManagement #SQLQueries #TechInnovation #DataInsights #DataOptimization

22

#ProgProX #PPX for improving #Microsoft #Excel #SplitIMG function with its many args

35

8 comentarios

"𝗜𝗡𝗧𝗘𝗥𝗩𝗔𝗟" 𝗶𝘀 𝗼𝗻𝗲 𝗼𝗳 𝘁𝗵𝗲 𝗸𝗲𝘆 𝗰𝗼𝗻𝗰𝗲𝗽𝘁 𝗶𝗻 𝗦𝗤𝗟 𝘁𝗵𝗮𝘁 𝗶𝘀 𝘂𝘀𝗲𝗱 𝗽𝗿𝗼𝗳𝗲𝘀𝘀𝗶𝗼𝗻𝗮𝗹𝗹𝘆 𝗼𝗻 𝗮 𝗳𝗿𝗲𝗾𝘂𝗲𝗻𝘁 𝗯𝗮𝘀𝗶𝘀. Checkout the video where we solve a TIKTOK SQL question using Interval. #tiktok #sql #excel #businessanalysis #dataanalysis

8

Excel Shortcuts Tips by SHAVETA KHULLAR

6

#ExcelTutorial | Have you ever used the CAMERA 📸 tool in Excel? The Camera tool allows us to take a snapshot of a range of data and paste the snapshot elsewhere. It’s similar to the screenshot utility BUT with one major difference - if the source data changes the snapshot automatically updates! This makes it super simple to use existing data in dashboards or reports that auto-updates but retains the original formatting. Find out where to find the Camera tool and how to use it below 👇 #excel #exceltips #microsoft365 #microsoftambassador

439

32 comentarios