@PowerAccessSQL－Convert #Excel to #Microsoft #Access #Database｜AutoGen #SQL/#VBA｜Auto DB Build🛠｜XPrevRow｜800🆕#PowerQuery/XL func 4 Query📐｜User🚫Edit｜#iPad｜#Cloud
Joined July 2017
- Tweets 180
- Following 506
- Followers 297
- Likes 272
Photos and videos
Pinned Tweet
29 Jun 2018
Finally, 🆕 tools🛠 to empower🔋 #Microsoft #Access＆#Excel📊!
🔁 Convert #MSExcel ⏩ #MSAccess #database/#SQL ⏩ #Azure
🔎 #PowerSQL－#PowerQuery ➃ #MicrosoftAccess
👥 #PowerGit－#Git versioning ➃ #O365
⚙ #CodeGen ➃ #VBA
👉Get #PowerAccess⚡️
@ PowerAccess.net!
5
9
Excel 2 MSAccess｜SQL retweeted
22 Nov 2018
OK everyone repeat after me.
"Excel is not a database."
A client just lost a week of time trying to fix a ex-colleague's Excel hell.
2
4
Excel 2 MSAccess｜SQL retweeted
19 Sep 2018
DAX Guide is online! - The reference I had been wanting for years is online at dax.guide - not a book, just a complete function reference online - read more about it on my blog post! #dax #powerbi #powerpivot #ssas #tabular ow.ly/PJJU30lSJ9l
21
203
390
Excel 2 MSAccess｜SQL retweeted
10 Aug 2018
The hidden secrets of TOTALYTD (and why you should use CALCULATE and DATESYTD instead). ow.ly/iHMA30llHqE
37
92
Excel 2 MSAccess｜SQL retweeted
10 Aug 2018
SVG "Line" sparkline measure now available on the #PowerBI Quick Measures Gallery. community.powerbi.com/t5/Qui…
Up next: Column
3
36
90
Excel 2 MSAccess｜SQL retweeted
10 Aug 2018
MS Excel Data Validation for Accountants - #excel excelzoom.com/ms-excel-data-…
6
12
Excel 2 MSAccess｜SQL retweeted
10 Aug 2018
Run Macro Automatically on Open - #excel excelzoom.com/run-macro-auto…
3
4
Excel 2 MSAccess｜SQL retweeted
10 Aug 2018
#Microsoft Releases #Windows Community Toolkit Version 4.0 cc @CsharpCorner @Microsoft @Windows goo.gl/bTD6Fu
31
24
Excel 2 MSAccess｜SQL retweeted
9 Aug 2018
Check out our #PowerBI Desktop August 2018 feature summary, featuring #Python integration. Read the blog: msft.social/OtVV73
3
51
72
Excel 2 MSAccess｜SQL retweeted
Learn about 2018 alternatives to #AWA #Access Web Apps, including:
#PowerApps
(Canvas 🆚 Model @PowerApps compared)
MultiUser #MSAccess #database UI
#SQLServer/#AzureSQL backed DB
In @AccessUserGroup #AUG video
@jsoto22 @accessrepair1 @AccessWisdom
youtu.be/L5QLVzDPmbs
12
15
Excel 2 MSAccess｜SQL retweeted
Cost Comparison for #Database & #Analytics Solution #Development
#Excel：$500
🆚 #MicrosoftAccess：$3K
🆚 #MSAccess #MultiUser：$10K
🆚 AccDB 4 dept：$50K
🆚 .NET #Access：$200K
🆚 #SQLServer：$500K
👇Join discussion of cost & alternatives (#PowerBI ):
linkedin.com/feed/update/urn…
14
17
Excel 2 MSAccess｜SQL retweeted
Microsoft's #CommonDataService for #Analytics: The Good, the Bad, the Ugly.
#CommonDataService for Apps (#CDS for #Apps) is the first of two components in the new 2.0 replacement for #Microsoft's CDS #Azure-based data hostingfor…lnkd.in/gnkpdTa lnkd.in/g6kHwHC
9
10
Excel 2 MSAccess｜SQL retweeted
#Tableau, gets #ArtificialIntelligence!?
Tableau Software just acquired #AI company, Empirical Systems.
Attempting to compete with #PowerBI's monthly #YAPBIF (Yet Another Power BI Feature)?
How long do you think before Microsoft gives Power BI it's own #M…lnkd.in/gP652Pp
10
12
Excel 2 MSAccess｜SQL retweeted
How to format Millions into Thousands (K) in #Excel
#ExcelTips from #MSExcel MVP @ObengBoateng57
CC @TomUrtis, @MrExcel, @ArtTennick, @powerbipro, @Excelforo, Mike "excelisfun" Girvin, ExcelVBATips ., Consultant VBA Excel, @msexceltrainer,…lnkd.in/gsV7jij
10
13
Excel 2 MSAccess｜SQL retweeted
#IoT #Smart Solutions for #SmartCities
CC Ricardo Fernández, @evankirstel, @jonsteinberg, Helene Li, @SpirosMargaris, @MikeQuindazzi, @PetiotEric, @KirkDBorne, @andi_staub, @jblefevre60, @sebbourguignon, Christine Boursin
#InternetOfThings #AI #ML #Dr…lnkd.in/gRtx6ma
9
13
Excel 2 MSAccess｜SQL retweeted
#YAPBIF ("Yet Another Power BI Feature"):
🆕 #PowerBI just added #Dashboard #Theming 🎛🎨 for #PowerBIService (Embedded, Mobile & external to come), building on its Desktop Report Themes, enabling branding & customization with (eve…lnkd.in/eZN9UCf lnkd.in/ggbJR8f
10
12
Excel 2 MSAccess｜SQL retweeted
Excellent #video showing how to use #GoalSeek in #Excel.
#ExcelTips from @ObengBoateng57 lnkd.in/ecfPUFq
11
12
Excel 2 MSAccess｜SQL retweeted
#PowerPivot will be available in all #Excel edition SKUs, making feasible to use without worrying won't be installed or supported.
Thanks everyone who voted for this and thanks @msexcel team!
excel.uservoice.com/forums/3…
1
14
14
Excel 2 MSAccess｜SQL retweeted
#Microsoft #Office 2019
New & Updated Features in #Office2019:
#Excel－#PowerQuery #PowerPivot #PowerBI
#Access－#Charts📊
#Word－Sound
#Outlook－@'s
#PowerPoint－3D
#OneNote－#Ink2Text
@matt_dangelo45 @Office365 @BNDarticles
#MicrosoftOffice #Office365
businessnewsdaily.com/10905-…
13
16
Excel 2 MSAccess｜SQL retweeted
Did you know can auto-generate #VBA in #Excel w/ built-in #MacroRecorder?
To automate #MSExcel:
1. View > Record #Macro
2. Type shortcut
2. Perform steps
3. Go to next row/sheet
4. End
5. Use shortcut (Ctrl ?)
6. Watch auto repeat!
#ExcelTips @ExcelEasy
excel-easy.com/vba/examples/…
14
17
Excel 2 MSAccess｜SQL retweeted
Subscribe @ PowerAccess.net
for early access to
👉#PowerAccess｜#PowerGit｜#PowerSQL
🆕Modernize＆Extend #MicrosoftAccess
🆕Auto #Database Builder Tools
🆕#Excel-to-#MSAccess/#SQL Conversion
🆕Automate MS #Access
🆕Gen #VBA
🆕User Edit/View #Security
🆕#MultiUser #Mobile
13
15