@PowerAccessSQL➖#PowerQuery-like #SQL/#VBA Functions for #MicrosoftAccess➕#MSAccess ➔ #SQLServer/#Azure Auto Conversion Tools➕ #Finance｜#Analytics｜#BI📊Functions
Joined July 2017
- Tweets 715
- Following 1,450
- Followers 589
- Likes 941
10 Photos and videos
Pinned Tweet
Like #Blockchain｜#IoT
#PowerAccess empowers⚡#Data
1st＆Only #Microsoft #Access
✅Auto #Database Builder🔨
✅#Excel➡#MicrosoftAccess/#SQL Converter
✅#Git Source🔁
✅📝Track/Undo➕🚷#Security
✅#Cloud☁#Mobile📱
✅800 🆕#PowerQuery-like➕#VBA Functions
PowerAccess.net/MicrosoftAcc…
4
7
PowerSQL Functions for MS Access｜SQL Server｜Azure retweeted
Using #Excel 2016's 🆕 #Forecast Feature
@spreadsheetlabs
#Forecasting #Finance #Accounting #Data #Analytics #PowerBI #Spreadsheet
@MSExcel @MrExcel @OfficeInsider @MSTCommunity @ExcelAudit @TheBIccountant @TrumpExcel @excelytics_info @excelisfun @OzExcel
spreadsheetlabs.net/using-ex…
15
19
PowerSQL Functions for MS Access｜SQL Server｜Azure retweeted
Realize #Data💽 replaced🤺#Oil🛢as #MVP🥇#regulated resource，as enables #AI🤖＆#IoT📱❓
#RT❕#BigData #SQL #Tech
#DataScience
economist.com/news/leaders/2…
18
18
PowerSQL Functions for MS Access｜SQL Server｜Azure retweeted
How to use custom date formats in #Excel & #MSAccess.
Table, from @TomUrtis, shows meaning of each placeholder ("m", "mm", "d", "DD", etc) can use at:
In #MSExcel:
Select cells > right click > Format Cells (Ctrl 1) > Number > Format
In #MicrosoftAccess:…lnkd.in/gB_6UAu
12
15
PowerSQL Functions for MS Access｜SQL Server｜Azure retweeted
How to extract #Web #Data to #Excel #Spreadsheet for #Analytics📊& #DataScience with #PowerQuery #PowerBI
👉bradleysawler.com/engineerin…
#MSExcel #ExcelTips
CC @sawlerb @_Ivan_Bond @kpuls @powerbipro @msexcel @powerpivotpro @ExceleratorBI @Rad_Reza @EscobarMiguel90 @TheBIccountant
2
24
47
PowerSQL Functions for MS Access｜SQL Server｜Azure retweeted
How to use HTML.Table() in #PowerQuery for #Excel and #PowerBI for #WebScraping to extract #Data from webpages
From @cwebb_bi
blog.crossjoin.co.uk/2018/08…
5
5
PowerSQL Functions for MS Access｜SQL Server｜Azure retweeted
#MicrosoftFlow #Addin now available for #Microsoft #Excel, integrating #MSFlow allowing you to design & run #Automation #Workflows inside of Excel!
#Tutorial to get started:
👉 lnkd.in/gPkgncy
You can find & install the MS Flow add-in in #Micr…lnkd.in/gBh4_Jj
4
8
PowerSQL Functions for MS Access｜SQL Server｜Azure retweeted
"#Excel is dead" (vs #PowerBI, #MSAccess, #PowerApps)?
🆚 "Excel is alive" - kicking (#PowerQuery, #PowerPivot) & integrating (#CDS, #AzureML, #MSAccess, #JavaScript)?
@model_citizn provides an excellent #Recap of arguments for & against #ExcelIsDead.
Y…lnkd.in/gAGa8Re
1
16
19
PowerSQL Functions for MS Access｜SQL Server｜Azure 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
PowerSQL Functions for MS Access｜SQL Server｜Azure retweeted
7
8
PowerSQL Functions for MS Access｜SQL Server｜Azure 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
PowerSQL Functions for MS Access｜SQL Server｜Azure retweeted
Ultimate Beginners Guide to #Blockchain🔗
👉blockgeeks.com/guides/what-i…
#FinTech #Crypto #IoT #AI #InsurTech #BigData
@AmeerRosic @Blockgks
cc @PowerBlockchain @ahier @pierrepinna @chboursin @antgrasso @jblefevre60 @stratorob @Xbond49 @PetiotEric @psb_dc @JimMarous @SpirosMargaris
19
23
PowerSQL Functions for MS Access｜SQL Server｜Azure 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
PowerSQL Functions for MS Access｜SQL Server｜Azure retweeted
Excellent #video showing how to use #GoalSeek in #Excel.
#ExcelTips from @ObengBoateng57 lnkd.in/ecfPUFq
11
12
PowerSQL Functions for MS Access｜SQL Server｜Azure 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
PowerSQL Functions for MS Access｜SQL Server｜Azure retweeted
Microsoft Access Database reporting rechniques video from AUG Access User Group and @jsoto22.
#Microsoft #Access #MSAccess #MicrosoftAccess #Database #Reporting #Data #BigData #Analytics #Tutorial #Video #AUG lnkd.in/gcmjWcV lnkd.in/gYUetkA
9
12
PowerSQL Functions for MS Access｜SQL Server｜Azure retweeted
🆕 #WebScraping in #PowerBI & #PowerQuery #tutorial
Now supports CSS Selectors!
From Power BI & Power Query expert @EscobarMiguel90
#Web #Data #Analytics #MSBI
CC @powerbipro @PowerBITips @PowerQuery @PowerBITips @powerpivotpro
poweredsolutions.co/2018/05/…
12
14
PowerSQL Functions for MS Access｜SQL Server｜Azure retweeted
For those unfamiliar with it, #PowerQuery isn't a difficult to use, advanced #Excel feature, it's a incredible time- and headache-saving tool - complete with easy visual designer.
Power Query is capable of pulling data from whole folders of workbooks and…lnkd.in/e6Y-bSS
11
13
PowerSQL Functions for MS Access｜SQL Server｜Azure 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
PowerSQL Functions for MS Access｜SQL Server｜Azure retweeted
#VisualStudio2019: #AI-driven #refactoring and #LiveShare collaborative #coding & #debugging?!
Any other #coders unable to wait any longer - who and must get their hands on it now?
First GitHub acquisition, now days later this?
Apparently June is #Micro…lnkd.in/gBiZACi
10
11
PowerSQL Functions for MS Access｜SQL Server｜Azure retweeted
Now, at long last, #Microsoft's well known #Northwind #Sample #Database is available for easy download, as a #MicrosoftAccess #Template, and to non-English users!
Also, for those unaware, MS Access Templates are now available onli…lnkd.in/gGgt7sC lnkd.in/gRNhcPa
11
12