RCollab on LinkedIn: rmarkdown-cheatsheet (2024)

Interested in a free Excel class where you can get practical help with specific issues? Please fill out this form to submit your questions or tasks and get them demystified! https://lnkd.in/dTRbYmtwThe class will be streamed live on my YouTube channel, so be sure to subscribe and turn on notifications to stay updated. The date and time will be shared publicly and with those who have completed the form. youtube.com/@iamcoachtheo#excel#diy#microsoftExcel#demystify#iamcoachtheo

6

1 Comment

A blinking gradient and an arrow flying around inside of a table in Power BI. How is it possible? What #PowerBI visual is it? Guess in a comment. I'll answer when there will be a bunch of comments. You'll be surprised.P.S. This exact implementation doesn't make much sense from a #datavisualization point of view. It's just a test of what is possible (and a colorful animated clickbait 😁 )Answer: HTML table formatted and animated using CSS and embedded into an SVG namespace using foreignObject. New Card visual.

19

5 Comments

🚀 Exciting News! 📊 I've just published a new article titled 'Excel Puzzles Solved in R - 329 - 333'. This piece dives into the fascinating world of solving complex Excel puzzles using the power of R programming. Whether you're a data enthusiast, an R aficionado, or just love a good challenge, this article offers insightful solutions and intriguing approaches. Check it out now and elevate your data manipulation skills! 💡🔍 #ExcelPuzzles #RProgramming #DataScience #rstats

2

1 Comment

While working on an analytics tool project, I noticed a common challenge: many engineers struggle with exporting Excel files effectively. To help anyone facing similar issues, I’ve put together a blog titled "Exporting Excel with SheetJS for Dummies".If you're finding yourself wrestling with Excel exports or just want to streamline your data handling, this post is for you! It’s designed to get you up to speed in just 10 minutes.👉 Check out the full blog here: https://lnkd.in/gb4zkgaG 👈I hope this helps simplify your workflow! Feel free to share your thoughts or reach out with any questions.#SheetJS #SoftwareDevelopment #Programming #TechTips #Coding

13

SVG experiments in Power BI Matrix visual.Map with highlighted areas. Value based highlighting of the area (fill-opacity).Multiple lines text with color highlighted substring and with superscripted characters.PBI Core Visuals Can we have color highlighted substrings and superscripted characters (and a few other formatting options for substrings) in titles? /HTML or BBCode or whatever will enable this functionality/[deleted previous post to update the screenshot]#PowerBI#pbicorevisuals#SVG

50

4 Comments

When you're working in spreadsheets, sometimes you'll have to add two or more numbers together.And there are many ways to do this in Excel.In this tutorial, Eamonn walks you through 9 ways to do addition in Excel - from simple to complex.

48

When you're working in spreadsheets, you'll often have to add two or more numbers together.And there are many ways to do this in Excel.In this tutorial, Eamonn walks you through nine ways to do addition in Excel - from simple to complex.

40

🚀 Unleash Your Creativity: New Episode of Puzzles Out Today! 🧠🎨Prepare for an episode of "R Solution for Excel Puzzles" that takes you on a wild ride through a kaleidoscope of challenges. This installment is not just about solving problems; it's about painting with the broad strokes of your imagination and the fine details of logic. 🖌️📊Ciphering: Decode hidden messages and discover secrets tucked away in the numbers.Colour Coding: Bring a splash of color to data, finding patterns that are as beautiful as they are informative.Drawing with Numbers: Convert raw numerical data into stunning visual representations.Jumping Through Spreadsheet Columns: Navigate Excel's columns with agility, linking data in a high-speed chase of logic.Magic Sentence of Numbers: Unravel a sentence crafted from an enigmatic sequence of numbers, where each digit holds the key to unlocking the message.🔗 Strap in and get ready to jump from cipher puzzles to artistic data displays and acrobatic spreadsheet maneuvers. This episode is sure to challenge your skills, delight your senses, and perhaps even reveal a little magic.#DataPuzzles #CreativeCoding #ExcelMagic #RChallenge #PuzzleAdventure #rstats #DataScience #TransformationSkills

2

𝐇𝐞𝐫𝐞 𝐢𝐬 𝐰𝐡𝐲 𝐈 𝐥𝐨𝐯𝐞 𝐛𝐚𝐫 𝐜𝐡𝐚𝐫𝐭𝐬...I have seen a lot of different visualisations and often find myself wondering, why overcomplicate it and not just use a bar chart?Bar charts are:1. Easy to understand, making data clear and accessible.2. Suitable for comparing a wide range of data types and categories.3. Effective for quick and accurate comparisons between groups.4. Suitable to handle both small and large datasets without clutter.5. Easy to customise in various ways to fit specific needs.Do you love bar charts as much as much as we do here at Sport Horizon UK? ;-)#SportHorizon #PowerBI#Tableau#Excel

15

#100daysofcodingchallenge... 🌟Day 38/100 .... 🚀Leetcode -79. word search... class Solution { public boolean exist(char[][] board, String word) { int m = board.length; int n = board[0].length; StringBuilder s = new StringBuilder(); boolean[][] vis = new boolean[m][n]; for(int r =0;r<m;r++){ for(int c=0;c<n;c++){ if(dfs(board , vis , word , r,c,s)) return true; } } return false; } private boolean dfs(char[][] board , boolean[][] vis,String word , int row,int col,StringBuilder s){ s.append(board[row][col]); vis[row][col] = true; if(s.length() == word.length()){ boolean hasFound = s.toString().equals(word); s.deleteCharAt(s.length()-1); vis[row][col]=false; return hasFound; } int m = board.length; int n= board[0].length; int[][] dirs = new int [] [] {{1,0},{-1,0},{0,1},{0,-1}}; for(int [] dir:dirs){ int newRow = row+dir[0]; int newCol = col + dir[1]; if(newRow >= 0 && newRow < m && newCol >= 0 && newCol < n &&!vis[newRow][newCol]){ if(dfs(board,vis,word,newRow,newCol,s)){ return true; } } } s.deleteCharAt(s.length()-1); vis[row][col] = false; return false; }}

9

1 Comment