#ProgramaçãoGlobal #VBA #Python #PowerBI #DAX #Dashboard
Buy the books in this series.
Below you will find ALL articles published up to December 17, 2025:
1. Dashboard | Asanahe: A Dashboard Review by AI
2. Dashboard | Ideal Dashboard and AI-Powered Critique
3. Dashboard | CRM and Dashboard Critique by AI
4. Dashboard | Dashboard User Interface Kit and AI-Powered Dashboard Critique
5. Dashboard | MaterialM and the AI-Powered Dashboard Critique
6. Dashboard | Modernizing and Critique of Dashboards by AI
7. Dashboard | Responsive and Adaptive Design and Dashboard Critique by AI
8. Dashboard | Google Analytics PPC Dashboard and AI-Powered Dashboard Critique
9. Dashboard | Social Media Dashboard and AI-Powered Dashboard Critique
10. Dashboard | What is a KPI Dashboard for e-Commerce and an AI-powered Dashboard Critique
11. Extraction and Aggregation of Prescription Data in Power BI: A DAX Solution for Pharmaceutical Market Analysis
12. 📍Article Series with Database
13. 📍Series of Articles with MS Access
14. 📍Article Series with Downloads
15. 📍Python Article Series
16. 📍Power BI Article Series
17. 📍DAX Article Series
18. 📍VBA PIECE OF CAKE Article Series
19. 📍VBA Tips Article Series
20. 📍VBA Outlook Article Series
21. 📍VBA DONUT Article Series
22. Automating Web Scraping in Excel: How to Extract Data from HTML Tables with VBA
23. STRUCTURAL VULNERABILITIES IN GLOBAL DIGITAL CRITICAL INFRASTRUCTURE: ANALYSIS OF SYSTEMIC DEPENDENCIES AND ASSOCIATED RISKS
24. Customer Churn Risk Indicator with DAX
25. Power BI | Time Control Panel - Example Dashboard for Precise Insights
26. Power BI | Trading Dashboard - Example of a Dashboard for Precise Insights
27. Practical List of Brazilian States: Abbreviations, Capitals, and Regions in a Simple Way
28. Dynamic KPI Calculation with DAX
29. 📊 List of Keyboard Shortcuts used in Microsoft Access
30. Brazilian States in Minutes: Abbreviations, Capitals, and Regions for Quick Reference
31. ✔ GLOBAL® Programming
32. Comparison of Budget vs. Actual with Color Coding in DAX
33. VBA Access - MS DOS Commands in VBA - Microsoft DOS Commands in VBA - Opening a Website in the Default Browser
34. Year-to-date sales with seasonal adjustment in DAX
35. 3-Month Moving Average for Sales with DAX
36. The Evolution of the Corporate Browser into an Autonomous Agent and Its Regulatory Implications
37. Prompt Injection Attacks on Corporate Browsers – Anatomy of a Silent Compromise
38. Regulatory Impact and Compliance – AI-Enabled Browsers and the Evolution of HIPAA 2025
39. Technical Defense Mechanisms – Isolation, Filtration, and Layered Sanitization
40. Implementation Roadmap – From Pilot Projects to Enterprise Deployment in Pharmaceutical Environments
41. Discover the Capitals and Abbreviations of the Brazilian States with This Quick Guide
42. Weighted Average Calculated with DAX
43. Brazilian States: Everything You Need to Know About Abbreviations, Capitals, and Regions
44. 📒 List of Keyboard Shortcuts used in Microsoft OneNote
45. ✔ GLOBAL® Programming
46. Comparison of Sales with the Same Period of the Previous Year in DAX
47. VBA Access - MS DOS Commands in VBA - Microsoft DOS Commands in VBA - Listing Files in a Folder
48. Competitive Benchmarking Score with DAX49. Understanding Google Search Grounding
50. Trend-Based Sales Forecasting Model with DAX
51. BATCH | Command Chaining
52. BATCH | Conditional Logic in Tasks
53. BATCH | System Information Collection
54. BATCH | Scripts de Logon
55. Batch | Task Scheduling
56. BATCH | Creating Custom Shortcuts and Simple Menus
57. BATCH | Software Installation and Execution
58. Batch | System Administration and Maintenance
59. Batch | Automation of Repetitive Tasks
60. Batch | File and Folder Management
61. From A to Z: Abbreviations and Capitals of Brazilian States in a Complete List
62. Multidimensional Region Segmentation with DAX
63. States of Brazil: The Definitive List of Abbreviations, Capitals, and Regions for You
64. Alert System for Dashboard with Dynamic Conditions in DAX
65. 📧 List of Keyboard Shortcuts used in Microsoft Outlook
66. ✔ GLOBAL® Programming
67. VBA Access - MS DOS Commands in VBA - Microsoft DOS Commands in VBA - Automatically Shutting Down the PC
68. DAX and M Language: The Power BI Revolution in Data Analysis
69. Power BI | Power Automate eliminates the barrier of manually updating the Semantic Model.
70. DAX | 📈 Predictive Intelligence: Revenue Forecasting with Linear Trend71. 💡 Polynomial Regression: A Powerful Tool for Analyzing Nonlinear Data
72. Abbreviations, Capitals, and Regions of Brazilian States: All in One Article
73. Cumulative Sum with Variable Window in DAX
74. 🎤 List of Keyboard Shortcuts used in Microsoft PowerPoint
75. Brazilian States: Learn the Abbreviations, Capitals, and Regions Without Complications
76. ✔ GLOBAL® Programming
77. Trade Category in the Pharmaceutical Industry: How to Sell Better within the Right Channel
78. 🎤 List of Keyboard Shortcuts used in Microsoft Word
79. 🌐 List of Keyboard Shortcuts used in Microsoft SharePoint (via browser)
80. IQVIA™ DDD® - Drugs Distribution Data - Automating Updates in BI
81. Public Databases | Trade Balance and Foreign Trade Statistics of Brazil - Ministry of Development, Industry, Trade and Services
82. Public Databases | INEP - National Institute of Educational Studies and Research Anísio Teixeira
83. Public Databases | FIRJAN Index – Municipal Statistics
84. Public Databases | Statistical Panels of the STF - Supreme Federal Court
85. Public Databases | Criminal Statistics from the Ministry of Justice and Public Security
86. Public Databases | Socioeconomic Databases of the IBGE - Brazilian Institute of Geography and Statistics
87. Public Databases | TSE - Electoral Statistics
88. Public Databases | DataSebrae - Statistics on Micro and Small Businesses
89. Public Databases | IPEA Economic Indicators
90. Public Databases | DATASUS - Statistics from the Ministry of Health
91. Public Databases | Employment/Unemployment Statistics from the Ministry of Labor and Employment
92. Public Databases | SGS - Central Bank Time Series Management System
93. Public Databases | Brazilian Open Data Portal and National Data Catalog
94. Public Databases | FEBRABAN - Brazilian Federation of Banks - Economic and Banking Statistics - Special Credit Survey
95. DAX | 🗓️ Smart Calendar: Foundation for High-Impact Dashboards!
96. DAX | 🎉 Personalized Dynamic Greeting with Insights in Power BI
97. Everything about the States of Brazil: Abbreviations, Capitals, and Regions Organized for You
98. Add a Simple Login and Password Layer Directly in Power BI
99. Brazilian States from A to Z: Complete Guide with Abbreviations, Capitals and Regions
100. ChatGPT Prompts for Microsoft Excel: Integrating Machine Learning and AI
101. ChatGPT Prompts for Microsoft Excel: Statistical Functions and Analysis
102. ChatGPT Prompts for Microsoft Excel: Techniques to Save Time
103. ChatGPT Prompts for Microsoft Excel: Keyboard Shortcuts and Quick Commands
104. ChatGPT Prompts for Microsoft Excel: Importing and Exporting Data
105. ChatGPT Prompts for Microsoft Excel: Data Cleaning and Processing
106. ChatGPT Prompts for Microsoft Excel: Home Management
107. ChatGPT Prompts for Microsoft Excel: Event Planning
108. ChatGPT Prompts for Microsoft Excel: Gamification and Fun Projects
109. Calculation of Comparative Growth Percentage in DAX
110. ✔ GLOBAL® Programming
111. ALL ITEMS UNTIL 30/Sep/2025
112. ChatGPT Prompts for Microsoft Excel: Educational Purposes
113. ChatGPT Prompts for Microsoft Excel: Integration with Tools
114. ChatGPT Prompts for Microsoft Excel: Custom Formulas and Add-ins
115. ChatGPT Prompts for Microsoft Excel: Business and Sales
116. ChatGPT Prompts for Microsoft Excel: Personal Productivity
117. ChatGPT Prompts for Microsoft Excel: Project Management
118. ChatGPT Prompts for Microsoft Excel: Financial Modeling
119. ChatGPT Prompts for Microsoft Excel: Collaboration and Sharing
120. ChatGPT Prompts for Microsoft Excel: Automation and Scripting
121. ChatGPT Prompts for Microsoft Excel: Data Analysis and Visualization
122. ChatGPT Prompts for Microsoft Excel: Advanced Formulas
123. ChatGPT Prompts for Microsoft Excel: Data Entry and Formatting
124. ChatGPT Prompts for Microsoft Excel: Basic Formulas
125. Excel | How to determine the display format of a cell in the row above?
126. Excel | How to determine the data type of a cell in the row above and fill it in the row below.
127. Abbreviations and Capitals: The Complete List of Brazilian States for You to Consult
128. Customer Segmentation by Lifetime Value with DAX
129. State, Abbreviation, Capital and Region: Find Everything about the States of Brazil Here
130. ✔ GLOBAL® Programming
131. VBA Access - MS DOS Commands in VBA - Microsoft DOS Commands in VBA - Checking the Internet Connection
132. Power BI | Top Books
133. The History of the ALGOL Programming Language: A Biography of Structure and Influence
134. The History of the LISP Programming Language: A Biography of Flexibility and Innovation
135. History of the COBOL Language: The Programmer of Business
136. The History of the Assembler Programming Language: A Biography Close to the Machine
137. The History of the Pascal Programming Language: A Biography of Simplicity and Structure
138. The History of the BASIC Programming Language: A Biography of Accessibility and Democratization
139. The History of the FORTRAN Programming Language: A Technological Biography
140. The History of the PL/I Programming Language: A Biography of Versatility and Ambition
141. The History of the Logo Programming Language: A Biography of Creativity and Education
142. History of the C Language: The Biography of the Programming Legend
143. The History of the Simula Programming Language: A Biography of the Object-Oriented Pioneer
144. 2025 | Essential Programming Languages
145. Dynamic Product Ranking in DAX
146. How to Resolve Replication and Synchronization Errors in Microsoft Access: An Essential Guide
147. How to Correct Query and Data Manipulation Errors in Microsoft Access: Practical Solutions
148. How to Resolve Permission and Security Errors in Microsoft Access: A Practical Guide
149. How to Solve Database Access Problems in Microsoft Access: Common Errors and Solutions
150. How to Fix Table and Index Management Errors in Microsoft Access: A Complete Guide
151. How to Fix External Data and ODBC Errors in Microsoft Access: Practical Solutions
152. How to Fix System Resource and Configuration Errors in Microsoft Access: A Technical Guide
153. How to Correct Data Validation and Integrity Errors in Microsoft Access: A Practical Guide
154. How to Fix SQL Query Errors and Advanced Syntax in Microsoft Access: Advanced Guide
155. How to Correct Syntax Errors in Microsoft Access: A Complete Guide to Queries
156. 5 Reasons Why Microsoft Fabric Will Revolutionize Your Data Projects | 5 Reasons Why Microsoft Fabric Will Revolutionize Your Data Projects
157. Complete Guide to Brazilian States: Abbreviations, Capitals, and Regions in One Place
158. ✔ GLOBAL® Programming
159. VBA Access - MS-DOS Commands in VBA - Microsoft DOS Commands in VBA - Clearing Temporary Files
160. Metric | Non-Targeted and AB Call Realization%
161. Metric | Daily Visits (Calls per day)
162. Metric | (Cost per call)
163. Metric | Cost per Call (Sales Force Headcount Ratio%)
164. Metric | Sales Force Effectiveness Ratio % (Compound Annual Growth Rate (CAGR))
165. Metric | Compound Annual Growth Rate (CAGR) (Coaching per Rep & Development plan per Rep & Dual call days in the field)
166. Metric | Coaching per Representative and Development Plan per Representative and Dual Call Days in the Field
167. Metric | Inventory Turnover Rate and Average Days of Inventory
168. Metric | Span of Control
169. Metric | Forecast Accuracy %
170. Metric | % of Approved Emails - % of Emails Reviewed on Open - % of Phone Calls - % of Webcast Attendees
171. Metric | % of Remote Detailing
172. Metric | Contribution to Growth % / Share of Growth %
173. Metric | Coaching Score Index
174. Metric | Closed Loop Marketing Rate (CLM%)
175. Metric | Sales Bonus Budget Realization %
176. Metric | Estimated End of Cycle Realization
177. Metric | Daily Average Sales
178. Metric | Prescription Drug Market Share - MS% Prescribed and Prescription Drug Growth - PPG% Prescribed (Prescription Market Share - Rx MS% & Prescription Growth - Rx PPG)
179. Metric | Delta Growth
180. Metric | Customer Lifetime Value - CLV
181. Metric | % of Incentivized Sales Force
182. Metric | Vacancy Rate %
183. Metric | Long-term cumulative profitability (LTIC) and Return on Additional Investment (IROI)
184. Metric | % of the Concentration Curve (Concentration Curve%)
185. Metric | Business Opportunity Index / Potential Index / Workload Index
186. Metric | Response Curve
187. Metric | Sales Ramp-up
188. Metric | Customer Acquisition Cost - CAC
189. Metric | % of Turnover Rate (Churn Rate%)
190. Profit Variance Analysis: Actual vs. Target in DAX
191. Metric | Percentage of Days in the Field (Days in the field %)
192. Metric | Strike Rate
193. Metric | % of Geographic Share (Geo Share%)
194. Metric | Voluntary Sales Force Turnover Ratio%
195. Metric | % of Time Spent on Coaching in FLSM (% of FLSM Time Spent on Coaching)
196. Metric | Share of Voice
197. Metric | Free Goods Ratio %
198. Metric | Drop Size
199. Metric | Customer Prevalence Rate
200. Metric | Coverage
201. Metric | Sales per Representative
202. Metric | Carryover Effect
203. Metric | Target Call Frequency Achievement - TCFA%
204. Metric | Growth Index
205. Metric | Market Index
206. Metric | Market Share
207. Metrics | Measures
208. Metric | Periods
209. Metric | Incremental Sales
210. Metric | Sales Growth
211. Metric | Realization%
212. Integrating GPT | Extending Excel using REST API calls
213. AI Agreements in the Gulf: Innovation or Risk to Global Security?
214. Unveiling the Gulf's Trillions: What Lies Behind the Economic Agreement with Qatar?
215. Is Data STILL the New Oil in 2025? Behind the Billion-Dollar Gulf Deals: Truth or Exaggeration?
216. Unveiling the Gulf Billions: The True Impact of AI and Aviation Deals
217. Beyond the Headlines: Unveiling the Gulf's Trillions
218. Is this data STILL the New Oil in 2025?
219. Complex Conditional Formatting with Multiple Criteria in DAX
220. E-book: Project Dax - Mathematical and Statistical Functions - André-Louis Bernardis
221. Electronic Book: DAX Project - Mathematical and Statistical Functions - André Luiz Bernardes
222. Electronic Book: DAX PROJECT - Mathematical and Statistical Functions - André Luiz Bernardes
223. e-Book: DAX PROJECT - Mathematical and Statistical Functions - André Luiz Bernardes
224. e-Book: DAX PROJECT - Mathematical and Statistical Functions - André Luiz Bernardes
225. e-Book: DAX PROJECT - Logical Functions - André Luiz Bernardes
226. e-Book: DAX PROJECT - Text Functions - André Luiz Bernardes
227. e-Book: DAX PROJECT - Date and Time Functions - André Luiz Bernardes
228. e-Book: DAX PROJECT - Relational Aggregation Functions - André Luiz Bernardes
229. e-Book: DAX PROJECT - Filter Functions - André Luiz Bernardes
230. e-Book: DAX PROJECT - Table Functions - André Luiz Bernardes
231. Give Your Spreadsheets a Boost by Eliminating Invisible AI-Generated Characters
232. Dynamic Analysis of Monthly Growth with DAX
233. Key Global Healthcare Technology Trends to Watch - Telemedicine: Transforming Healthcare in 2024
234. Revolutionize Your Text Editing with VBA: Eliminate Invisible AI Characters in Word!
235. Invisible Characters - Identifying
236. Invisible Characters - Bidirectional Direction Control Characters
237. Invisible Characters - Additional Control Characters
238. Invisible Characters - Deprecated or Problematic Characters
239. Invisible Characters - Common in AI-Generated Texts
240. Invisible Characters - Space and Formatting Characters
241. Table of Demonyms for Brazilian States and Capitals: Discover What Each Brazilian Is Called!
242. Everything You Need to Know About the States of Brazil: Abbreviations, Capitals, and Regions
243. Dynamic Filter for the Top 5 Products in DAX
244. Microsoft Fabric: 5 Reasons Why This Platform Will Revolutionize Your Data Projects | Microsoft Fabric: 5 Reasons Why This Platform Will Revolutionize Your Data Projects
245. Complex Aggregation with EARLIER and CALCULATE in DAX
246. ✔ GLOBAL® Programming
247. How to Measure VBA Code Execution Time in Excel – A Practical Guide
248. Automation in Excel with VBA: How to Increase Efficiency in Repetitive Tasks
249. How Can AI Quickly Detect Errors in Excel VBA?
250. Mastering Automation in Excel: Powerful Tips with Power Query and VBA
251. VBA Access - MS DOS Commands in VBA - Microsoft DOS Commands in VBA - Changing the Name of a Folder
252. Integrating Microsoft Fabric with Azure: Tips and Best Practices | Integrating Microsoft Fabric with Azure: Tips and Best Practices
253. GPT CHAT: Prompt to create image - Create an image, a comic strip, summarizing the basic phases of the ETL process.
254. GPT CHAT: Prompt to create image - Create an image with a 6-panel comic strip telling the story of Greek Civilization.
255. State, Abbreviation, Capital, and Region: Everything about the Brazilian States in One Place
256. ✔ GLOBAL® Programming
257. Essential Excel Automation Tool - Numerous.ai
258. Essential Excel Automation Tool - XLTools
259. Essential Excel Automation Tool - Sheetgo
260. Essential Excel Automation Tool - Ablebits
261. Essential Excel Automation Tool - Microsoft Power Automate
262. Essential Excel Automation Tool - Zapier
263. Essential Excel Automation Tool - Office Scripts
264. Essential Excel Automation Tool - Datylon ChartRunner
265. Essential Excel Automation Tool - Prompt Loop
266. Essential Excel Automation Tool - Formula Bot
267. VBA Access - MS DOS Commands in VBA - Microsoft DOS Commands in VBA - Checking the Windows Version
268. Power BI. | Tabular Editor - How can I list and export all the measures from a PBIX file?
269. Power BI | DAX Studio - How can I list and export all measures from a PBIX file?
270. VBA PowerPoint | Cracking Passwords - Understanding PowerPoint VBA Passwords
271. VBA PowerPoint | Cracking Passwords - Why you might need to crack a PowerPoint VBA password
272. VBA PowerPoint | Cracking Passwords - Methods for cracking PowerPoint VBA passwords
273. VBA PowerPoint | Password Cracking - Ethical Considerations Regarding Password Cracking
274. VBA PowerPoint | Cracking Passwords - Step-by-step guide: trying out free methods
275. VBA PowerPoint | Password Cracking - Professional tools for PowerPoint VBA password recovery
276. VBA PowerPoint | Password Cracking - Choosing the right tool for password recovery
277. VBA PowerPoint | Cracking Passwords - Protecting your own VBA code
278. VBA PowerPoint | Cracking Passwords - Frequently Asked Questions
279. Optimizing SQL Query: Filter First, Then Join!
280. POWER BI | M Language: Function to Extend Numeric Values to Brazilian Real and US Dollars
281. Integrating Microsoft Fabric with Azure: Tips and Best Practices | Integrating Microsoft Fabric with Azure: Tips and Best Practices
282. ✔ GLOBAL® Programming
283. VBA vs. Python: Will Python in Excel replace VBA?
284. VBA Access - Microsoft DOS Commands in VBA - Displaying the Computer's IP Address
285. 🚀 The 7 SQL Joins Every Data Professional Should Know! 🚀
286. Automating Daily Tasks Using Excel VBA287. Power BI Desktop | How to disable the three dots (context menu) that appear in the upper corner of Power BI visualizations, as they are necessary for exporting data?
288. Power BI | 📌 Automation via PowerShell: Using a Script to Send Reports by Email - Automation via PowerShell: Using a Script to Email Reports
289. Mastering Microsoft Fabric: A Guide for Developers | Mastering Microsoft Fabric: A Guide for Developers
290. Here are the 10 M Functions in Power Query that every analyst should know | Here Are the Top 10 M Functions in Power Query Every Analyst Should Know
291. Power BI | 📈 Measure: Analyzing Market Share Percentage Variation
292. Power Query Message: 🔍 The Preview Refresh Was Cancelled
293. Microsoft Fabric: The Future of Real-Time Data Integration and Analytics | Microsoft Fabric: The Future of Real-Time Data Integration and Analytics
294. ✔ GLOBAL® Programming
295. TOP Question about VBA Excel - Advanced Level - What is a collection in VBA and how can it be used?
296. TOP Question about VBA Excel - Advanced Level - What is the difference between ThisWorkbook and ActiveWorkbook?
297. TOP Question about VBA Excel - Advanced Level - What is the Find method and how to use it in spreadsheets?
298. TOP Question about VBA Excel - Advanced Level - What is a dynamic array and how to resize it in VBA?
299. TOP Question about VBA Excel - Advanced Level - How to create a custom event handler in VBA?
300. TOP Question about VBA Excel - Advanced Level - How to manipulate folders and files with FileSystemObject in VBA?
301. TOP Question about VBA Excel - Advanced Level - How to use nested loops in VBA to iterate through ranges?
302. VBA Access | 🖨️ How to Automate Print Settings in Reports
303. VBA Access | 🖨️ How to List Printer-Supported Paper Types and Trays
304. VBA Access | 🖨️ How to List All Installed Printers
305. VBA Access | 🖨️ How to Handle No-Data Reports Using VBA
306. VBA Access | 🖨️ How to Open Filtered Reports Efficiently
307. How to Connect VBA to a Database: A Comprehensive Guide for Automation Developers and Beginners in Office 365
308. Paradox (Delphi) | Advanced Code - Batch Record Update - Updating Records in Batch with Delphi: A Practical Guide - Advanced Code: Bulk Record Update & Practical Guide to Batch Processing in Delphi
309. Paradox (Delphi) | Advanced Code - Deleting Records with Criteria - Exploring Advanced Programming Techniques: Database Management with Delphi - Advanced Code: Deleting Records with Criteria & Mastering Database Management in Delphi
310. Paradox (Delphi) | Advanced Code - Batch Record Insertion - Bulk Record Insertion in Delphi: An Optimized Approach - Advanced Code: Bulk Record Insertion & Optimized Mass Data Handling in Delphi
311. Basic Code for Paradox Connection (Delphi) - Connecting to a Paradox Database in Delphi
312. Paradox (Delphi) | Advanced Code - Creating a New Table - Creating Tables in Delphi: Best Practices and Improved Approaches - Advanced Code: Creating New Tables & Best Practices for Table Design in Delphi
313. Paradox (Delphi) | Advanced Code - Performing queries with filters - Exploring queries in Delphi with parameters and performance improvements - Advanced Code: Querying with Filters & Enhancing Performance in Delphi with Parameters
314. TOP Question about VBA Excel - Advanced Level - How to automate sending emails with VBA and Outlook?
315. TOP Question about VBA Excel - Advanced Level - How to use DoEvents to release control to the operating system?
316. VBA Access - Basic Example of Executing a Stored Procedure - Execute a Stored Procedure in Sybase with VBA Access in Sybase
317. VBA Access - Executing Stored Procedures with Input Parameters - Execute Stored Procedures in Sybase with VBA Access in Sybase
318. VBA Access - Capturando Resultados de uma Stored Procedure - Execute Stored Procedure in Sybase with VBA Access in Sybase
319. VBA Access - Executing Stored Procedures with Output Parameters - Execute Stored Procedures in Sybase with VBA Access in Sybase
320. VBA Access - Executando Stored Procedure e Capturando Erros - Execute Stored Procedure in Sybase with VBA Access in Sybase
321. VBA Tips: How to Convert Between ASCII, EBCDIC, and UNICODE
322. Why Do You Need to Understand ASCII, EBCDIC, and UNICODE When Programming in VBA?
323. ASCII Table in VBA: How to Solve Encoding Problems
324. ASCII in VBA: A Quick Guide for Beginners in Character Encoding
325. VBA vs. Python: Will Python in Excel replace VBA?
326. VBA vs. Python: 5 Reasons Why the Future of Automation is Clear
327. TOP Question about VBA Excel - Advanced Level - How to debug VBA code with "Breakpoints" and the "Immediate" window?
328. TOP Question about VBA Excel - Advanced Level - How to handle errors efficiently using On Error?
329. TOP Question about VBA Excel - Advanced Level - How to create custom functions (UDFs) in VBA?
330. Does it Make Sense to Learn VBA in 2025? Is it Still Essential for Excel Users and Data Analysts?
331. Transforming Dates into Readable Formats: The VBA Function You Need to Know!
332. VBA Access - MS DOS Commands in VBA - Microsoft DOS Commands in VBA - Checking Disk Space 💾
333. VBA Access - MS DOS Commands in VBA - Microsoft DOS Commands in VBA - Listing Files in a Folder🔎
334. VBA Access - MS DOS Commands in VBA - Microsoft DOS Commands in VBA - Deleting Files 💻
335. VBA Access - MS DOS Commands in VBA - Microsoft DOS Commands in VBA - Creating Folders Automatically 📁
336. VBA Access - MS DOS Commands in VBA - Microsoft DOS Commands in VBA - Copying Files Quickly 📋
337. VBA Access - MS DOS Commands in VBA - Microsoft DOS Commands in VBA - Renaming Files ✏️
338. VBA Access - MS DOS Commands in VBA - Microsoft DOS Commands in VBA - Running External Programs🚀
339. DOWNLOAD FREE | LIST OF BRAZILIAN MUNICIPALITIES: Municipalities, States of Brazil - IBGE 2022
340. TOP Question about VBA Excel - Advanced Level - How to use the Application.Match method to search for values?
341. TOP Question about VBA Excel - Advanced Level - How to use the Dictionary in VBA and what are its advantages?
342. TOP Question about VBA Excel - Advanced Level - How to protect worksheets using VBA?
343. ✔ GLOBAL® Programming
344. Power BI | DAX: Time Period Analysis - Sales by Custom Period - Power BI with DAX: Custom Time Period Sales Analysis for Advanced BI Insights
345. Power BI | DAX: Time Trend Analysis for Sales Insights
346. Excel | Extract a specific word from a cell
347. IQVIA DaaS | Example 3 - Basic SQL queries using IQVIA PharMetrics® Plus tables
348. IQVIA DaaS | 2nd Example - Obtain a List of HCPs from IQVIA® OneKey
349. IQVIA DaaS | Example 1 - Obtain the number of prescriptions from healthcare providers using IQVIA® Xponent
350. IQVIA DaaS | Using Data as a Service
351. Data Modeling | What is a Fact Table?
352. Data Modeling | The Complete Theoretical Guide to Understanding the Essential Process in the Information Age
353. Power Query | DAX vs Linguagem M - Power Query vs DAX: Comparing M Language and DAX for Data Modeling and BI Insights
354. Power Query | Quando devo usar Power Query M, Power BI, ETL, DAX, Linguagem M, Power Query M, PBI, e quando devo usar DAX? - Power Query vs DAX: When to Use M Language, Power BI, ETL, and DAX for Optimal BI Solutions
355. Power Query | The Steps of a Project in a Power BI Data Processing Process - Power Query | Step-by-Step Guide to Data Processing in Power BI Projects
356. Power Query | O que é a Linguagem M? - What is M Language and How to Use It in Power BI?
357. Power Query | What's the Difference Between DAX and M Language?
358. Power Query | Date.DayOfWeekName – Function M: Returns the Day of the Week Name
359. Power Query | Date.AddDays – M function to add or subtract days from a date.
360. Power Query | Text.Combine: Used to combine multiple values into a single text value.
361. Power BI | Working with Colors and Transparencies in Hexadecimal
362. Power BI | Working with Colors Through Color Names
363. Power BI | Working with Colors Using the RGB Code
364. Power BI | Working with Colors Using Hexadecimal Code
365. Power BI | Working with Colors Using the RGBA Code
366. Excel | Remove empty spaces
367. Power BI Dashboard | EXAMPLE: How to Navigate Between Tabs Using the Main Menu?
368. Power BI | Key Answers to Common Interview Questions: What are columns, measures, and calculated tables in Power BI?
369. Power BI | Key Answers to Common Interview Questions: What is DAX in Power BI?
370. Power BI | Key Answers to Common Interview Questions: Understanding Relationships and Cardinality in Power BI
371. Power BI | Key Answers to Common Interview Questions: What is Data Modeling in Power BI?
372. Power BI | Key Answers to Common Interview Questions: What's the Difference Between a Power BI Report and a Dashboard?
373. Power BI | Key Answers to Basic Interview Questions: Explain the Power BI Dashboard - Key Answers to Common Interview Questions: What is a Power BI Dashboard?
374. Power BI | Key Answers to Basic Interview Questions: What is Power Query in Power BI?
375. Power BI | Key Interview Questions Answered: How to Connect Power BI to Various Data Sources?
376. Power BI | Key Answers to Basic Interview Questions: What are the key components of Power BI?
377. Power BI | Key Answers to Basic Interview Questions: What is Power BI? - Top Interview Questions: What Is Power BI and How Does It Work?
378. Excel Spreadsheet | DOWNLOAD - 2025 CALENDAR
379. 2025 Edition - Global Programming Links to over 1,500 Articles
380. VBA in Sybase | Creating a Stored Procedure
381. VBA in Sybase | Execute a Stored Procedure with a Parameter
382. VBA in Sybase | Updating Data Using a Stored Procedure
383. VBA in Sybase | Deleting Records with a Stored Procedure
384. VBA in Sybase | Transactions Using Stored Procedures
385. VBA in Sybase | Retrieve Multiple Results
386. VBA Excel - Execute Stored Procedure with VBA in Sybase
387. Tracking Active Customers in the Last Year with DAX in Power BI - Tracking Active Customers in the Last Year with DAX in Power BI
388. Optimizing Lead-to-Sale Conversion Rate in Power BI with DAX
389. How to Calculate Year-to-Date Performance with DAX in Power BI
390. How to Calculate Operating Expenses in Power BI Using DAX
391. Formatting ZIP Codes Correctly in Power BI: A Must-Know Guide for Developers
392. Identifying the 10 Most Profitable Products with DAX in Power BI - Correctly Formatting ZIP Codes in Power BI: An Essential Guide for Developers
393. How to Calculate Average Inventory of Products in Power BI with DAX
394. How to Identify Repeat Customers Using DAX in Power BI
395. How to Calculate Cash Flow in Power BI Using DAX
396. How to Calculate Total Revenue by Product Category in Power BI Using DAX
397. How to Calculate Gross Profit from Sales Using DAX in Power BI
398. How to Calculate Days in Inventory in Power BI for Efficient Stock Management
399. How to Calculate Product Price Variation Over Time in Power BI for Data Analysis
400. Power BI | DAX: Financial Analysis - Operational Expenses Calculation
401. O Conceito de RLS (Row-Level Security) é usado apenas no Power BI? - Is Row-Level Security (RLS) Only Used in Power BI? Understanding Its Applications Across BI Tools
402. Excel | Send Excel spreadsheet to MS Word
403. Power BI | Usando o Azure Log Analytics - Power BI | Integrating Azure Log Analytics for Advanced Data Insights
404. Power BI | Mastering Row-Level Security (RLS) for Precise Data Control and Access Management
405. Power BI | Understanding RLS (Row-Level Security): Importance and Implementation Guide for Data Protection
406. Transforming Data into Decisions: How RDL and Report Builder Revolutionize Report Creation in SSRS
407. Power BI | Deepening Data Analysis and Visualization - Mastering Data Analysis and Visualization for Enhanced Insights
408. Power BI | Control Your Data with Precision - Master Data Control with Precision for Accurate Insights
409. Power BI | DAX: Financial Analysis - Cash Flow Calculation and Insights
410. TOP Question about VBA Excel - Advanced Level - How to implement an advanced reporting interface using dynamic charts in VBA?
411. TOP Question about VBA Excel - Advanced Level - How to program an interactive macro wizard using VBA?
412. TOP Question about VBA Excel - Advanced Level - How to use `Dictionary` to store key-value pairs in VBA?
413. Excel | Highlight duplicate values
414. Power BI | Implementing RLS - Row Level Security - Implementing RLS (Row-Level Security) for Enhanced Data Protection
415. Power BI | How Do I Enable Multi-Selection in Reports? - How to Enable Multi-Selection in Reports for Better Data Insights
416. TOP Question about VBA Excel - Advanced Level - How to work with records and CSV files using VBA?
417. TOP Question about VBA Excel - Advanced Level - How to perform complex financial calculations using VBA?
418. TOP Question about VBA Excel - Advanced Level - How to use `Select Case` to simplify conditional logic?
419. TOP Question about VBA Excel - Advanced Level - How to create a data table using VBA and the `ListObject` object?
420. TOP Question about VBA Excel - Advanced Level - How to use the `InputBox` function to collect user input?
421. TOP Question about VBA Excel - Advanced Level - How to integrate VBA with other programming languages?
422. TOP Question about VBA Excel - Advanced Level - How to use `Range.Formula` to manipulate formulas programmatically?
423. TOP Question about VBA Excel - Advanced Level - How to use `Application.CutCopyMode` to manipulate the clipboard in Excel?
424. TOP Question about VBA Excel - Advanced Level - How to implement debugging techniques in VBA?
425. TOP Question about VBA Excel - Advanced Level - How to use `DoEvents` to allow user interaction while code is running?
426. TOP Question about VBA Excel - Advanced Level - How to create and manipulate text files using VBA?
427. TOP Question about VBA Excel - Advanced Level - How to create a VBA application that generates reports from data from multiple sources?
428. TOP Question about VBA Excel - Advanced Level - How to control the execution of other macros with `Application.Run`?
429. TOP Question about VBA Excel - Advanced Level - How to handle VBA code execution during worksheet events?
430. TOP Question about VBA Excel - Advanced Level - How to create series charts with VBA based on dynamic data?
431. TOP Question about VBA Excel - Advanced Level - How to use the Windows API to extend VBA functionality?
432. TOP Question about VBA Excel - Advanced Level - How to use `Error Handling` in VBA to manage errors?
433. TOP Question about VBA Excel - Advanced Level - How to manipulate data in real time in Excel using VBA?
434. TOP Question about VBA Excel - Advanced Level - How to use UserForms to create rich interfaces in Excel?
435. TOP Question about VBA Excel - Advanced Level - How to perform complex data validation in UserForms using VBA?
436. TOP Question about VBA Excel - Advanced Level - How to use VBA to interact with web APIs?
437. TOP Question about VBA Excel - Advanced Level - How to record and play back complex macros using VBA?
438. TOP Question about VBA Excel - Advanced Level - How to use sorting and searching methods in arrays with VBA?
439. TOP Question about VBA Excel - Advanced Level - How to use nested loops to manipulate data in multidimensional arrays in VBA?
440. TOP Question about VBA Excel - Advanced Level - How to work with dates and times in VBA?
441. TOP Question about VBA Excel - Advanced Level - How to use Application.OnTime to schedule tasks in VBA?
442. TOP Question about VBA Excel - Advanced Level - How to record and replay a bulk formatting process using VBA?
443. What is the future of VBA in 2025?
444. Comparing Python and VBA in MS Excel for Data Analysis: Which to Use in 2025?
445. Python vs. Excel VBA: When Python is Superior for Data Analysis
446. Does Excel VBA outperform Python in enterprise environments?
447. Python or Excel VBA: Which is the Best Tool for the Future of Automation?
448. Power BI | DAX: Financial Analysis - Revenue by Category
449. Power BI | Data Masking in Power BI: Intelligently Protecting Your Sensitive Data
450. Power BI | Unlocking the Power of Power BI: What Are Data Insights and How to Use Them to Transform Your Data Analysis
451. Power BI | 50 Questions and Answers: Basic Level - 50 Essential Beginner Questions and Answers for Power BI Mastery
452. Power BI | 50 Questions and Answers: Intermediate Level - 50 Intermediate Questions and Answers to Enhance Your Power BI Skills
453. Power BI | 50 Questions and Answers: Advanced Level 1 - 50 Advanced Questions and Answers for Expert-Level Power BI Mastery
454. Power BI | 50 Questions and Answers: Advanced Level 2 - 50 Advanced Questions and Answers: Mastering Power BI at Expert Level 2
455. Power BI | 50 Questions and Answers: Expert-Level Mastery 3
456. Power BI | DAX: Financial Analysis - Gross Profit - Calculating Gross Profit
457. Excel | Send all Excel charts to a PowerPoint presentation
458. Excel | Highlight the top ten values459. MS Access | Applying the Concatenation Function to Values in Query Fields
460. MS Access | Using SendKeys Efficiently
461. MS Access | Automating Database Compaction
462. MS Access | How to Manage Table Links
463. MS Access | Wrap Text at Maximum Line Length
464. MS Access | Monitoring User Connections
465. MS Access | Mapping 3,500 Errors by Creating Error Tables
466. MS Access | Code for Log Registration
467. MS Access | 17 Essential Steps to Improve Your VBA Code
468. MS Access | VBA Code for Backing Up All Tables (Commented)
469. Power BI | DAX: Product Analysis - Days in Stock - Product Analysis - Calculating Days in Stock
470. Power BI | DAX: Product Analysis - Price Variation by Product
471. Excel | Attach the active workbook to an email
472. Excel | Highlight values greater than
473. VBA Excel | How to obtain geographic coordinates (latitude and longitude) using the Google Geocoding API474. QlikView | Qlik Sense: Loading Script using QlikView Scripting Language makes calls to the Google Geocoding API and processes the XML response.
475. Power BI | DAX: Calculated value filtering on column in matrix - Filtering Calculated Values in a Matrix Column
476. Power BI | DAX - Brazilian ZIP Code - How to Format the ZIP Code - Creating a Calculated Column?
477. Power BI | DAX - Brazilian ZIP Code - How to Format the ZIP Code - Creating a Measure?
478. Power BI | DAX - Brazilian ZIP Code - How to Format ZIP Codes - Handling Non-Numeric Data?
479. Power BI | DAX - Brazilian ZIP Code - How to Format the ZIP Code - With Conditional Masking?
480. Power BI | Pipeline de Projetos no Power BI - Project Pipeline Management in Power BI: Best Practices and Techniques
481. IMPORTANT LIST | Economic Lists in CSV Format - States with the Highest GDP - Gross Domestic Product - Ranking of Brazilian States and their contribution to the National Economy
482. IMPORTANT LIST | List of Brazilian States by Population in CSV Format - Classified according to their total population, based on IBGE data.
483. IMPORTANT LIST | Brazilian States and their Capitals in CSV Format - A basic list that includes the 26 states and the Federal District, with their respective capitals.
484. Data Visualization - Dynamic Charts Machine | VBA Prompt in ChatGPT that Changes the Game for Data Professionals
485. Data Manipulation - Fuzzy Correspondence | VBA Prompt in ChatGPT that Changes the Game for Data Professionals
486. Data Analysis - Custom Function Creator | VBA Prompt in ChatGPT that Changes the Game for Data Professionals
487. Data Visualization - Conditional Formatting Rules | VBA Prompt in ChatGPT that Changes the Game for Data Professionals
488. Data Analysis - Statistical Analysis Engine | VBA Prompt in ChatGPT that Changes the Game for Data Professionals
489. Reports and Dashboards - Automated Report Generator | VBA Prompt in ChatGPT that Changes the Game for Data Professionals
490. Reports and Dashboards - Interactive Dashboard Builder | VBA Prompt in ChatGPT that Changes the Game for Data Professionals
491. Data Manipulation - Mass Data Transformation | VBA Prompt in ChatGPT that Changes the Game for Data Professionals
492. Data Collection and Cleansing - Data Cleansing Wizard | VBA Prompt in ChatGPT that Changes the Game for Data Professionals
493. Integration and Automation - Salesforce Data Synchronization | VBA Prompt in ChatGPT that Changes the Game for Data Professionals
494. Integration and Automation - Automated Email Reports | VBA Prompt in ChatGPT that Changes the Game for Data Professionals
495. Data Collection and Cleaning - Web Scraping Assistant | VBA Prompt in ChatGPT that Changes the Game for Data Professionals
496. 2024 | 100 Best Books for Excel
497. List of All Brazilian States - Latitude and Longitude
498. VBA Access | How to Copy All Tables Contained in the ACCDB File
499. VBA Access | How to Auto-Compress the ACCDB File
500. Power BI | DAX: Product Analysis - Identifying High-Profit Products
501. VBA and ChatGPT - Tricks and Lessons Learned
502. 10 Examples of Requests to Make to ChatGPT to Accelerate VBA Development
503. VBA | Learn Essential Prompt in ChatGPT for Coding - Develop a Custom VBA Function
504. VBA | Learn Essential Prompts in ChatGPT for Coding - Make VBA Code More Readable
505. VBA | Learn Essential Prompts in ChatGPT for Coding - Optimize existing VBA code
506. VBA | Learn Essential Prompt in ChatGPT for Coding - Automate Sending Outlook Emails
507. VBA | Learn Essential Prompt in ChatGPT for Coding - Create a VBA macro to automate reports in PowerPoint
508. VBA | Learn Essential Prompts in ChatGPT for Coding - Write VBA code to automate Excel tasks
509. VBA Excel | Automate Cycle Control in Excel with Custom VBA Function
510. VBA Excel | Function that Sums All Numbers in Parentheses in a Cell Range
511. Power BI | DAX: Product Analysis - Average Inventory - Product Analysis - Calculating Average Inventory
512. Excel | Create a Pivot Table
513. Excel | Highlight cells with misspelled words
514. Power BI | DAX: How to add calculated column (Ratio) in matrix visuals - Adding Calculated Column (Ratio) to Matrix Visuals for Enhanced Analysis
515. Excel VBA - Removing accents from words in cells
516. Removing accents and special characters in Excel
517. Function to remove accents in Excel
518. How to remove accents in Excel?
519. How to correct words with accents in Excel?520. How to remove accents in Excel VBA?
521. Power BI | DAX: Customer Analysis - Recurring Customers - Customer Analysis - Identifying Recurring Customers
522. VBA Excel | VBA Function - Return 'Yes' if all contents of a Range are filled, otherwise return 'No'.
523. Power BI | DAX: Customer Analysis - Customer Lifetime Value (CLV) - Customer Analysis - Calculating Customer Lifetime Value (CLV)
524. Excel | Highlight cells with comments
525. Power BI | DAX: Customer Analysis - Lead Conversion Rate - Calculating Lead Conversion Rate
526. Power BI | DAX: Customer Analysis - Active Customers - Customer Analysis - Identifying Active Customers
527. Power BI | DAX: Performance Analysis - Year-to-Date (YTD) Performance Calculation
528. Power BI | DAX: Performance Analysis - Profit Margin by Product
529. Power BI | DAX: How to Insert Target Information from Another Table into a Matrix in PBI? - How to add target information from another table to a matrix in Power BI
530. Power BI | DAX: Annual Growth Calculation - How to Calculate Annual Growth in Power BI
531. Power BI | DAX: 3-Month Moving Average - How to Calculate a 3-Month Moving Average in Power BI
532. Power BI | DAX: Vendas Acumuladas no Ano - How to Track Year-to-Date Sales Using Advanced DAX Formulas
533. Power BI | DAX: Year-End Performance Comparison - Comparing Current Performance with Previous Year Using Advanced DAX
534. Power BI | DAX: Customer Segmentation by Revenue Range for Advanced Data Analysis
535. Power BI | DAX: Identifying Inactive Customers Using Advanced DAX Formulas
536. Power BI | DAX: Customer Retention Analysis Using Advanced DAX Techniques
537. Power BI | DAX: Cálculo de Ticket Médio - How to Calculate Average Ticket Value Using DAX Formulas
538. Power BI | DAX: Identifying Best-Selling Products Using DAX Formulas
539. Power BI | DAX: Profit Margin Calculation - How to Calculate Profit Margin Using DAX Formulas
540. Power BI | DAX: Sales Analysis - Monthly Sales Percent Change Using DAX
541. Power BI | DAX: Sales Analysis - Average Sales per Customer Using DAX
542. Power BI | DAX: Sales Analysis - Sales Contribution by Product Using DAX
543. Power BI | DAX: Sales Analysis - Top Growing Products by Sales Growth Using DAX
544. Power BI | DAX: Performance Analysis - Performance by Region - Performance Analysis – Regional Performance Insights Using DAX
545. Power BI | DAX: Performance Analysis - Ranking Sales by Salesperson - Sales Performance Analysis – Ranking Sales by Salesperson Using DAX
546. Power BI | Pull Goals into a Matrix, then do calculations
547. eBook - PT - DONUT PROJECT Series - Volume 08 - VBA TOP 50 Most Important Codes - Project — André Luiz Bernardes
548. eBook - PT - DONUT PROJECT Series - Volume 09 - VBA TOP 50 Most Important Codes - Word — André Luiz Bernardes
549. VBA TOP 50 Most Important Codes - Access
550. VBA TOP 50 Most Important Codes - Excel
551. VBA TOP 50 Most Important Codes - Outlook
552. VBA Access | Calculating Distance using Longitude and Latitude
553. Encrypt or Decrypt | Excel VBA Module for Simple Password Obfuscation
554. Encrypt or Decrypt | A text string into a character string based on a user-specified encryption key.
555. Some of the many possible applications for those who know how to program in Visual Basic for Applications (VBA)
556. Excel | Protect your workbook
557. Excel | Copy data from one file to another
558. VBA Excel | Remove Empty Spaces
559. VBA Excel | Sort Numbers
560. VBA - Visual Basic for Applications | Polimorfismo
561. VBA - Visual Basic for Applications | Debugging Step-by-Step Through the Code
562. Developing Customized Solutions with Pentaho
563. Pentaho and Big Data: Analysis and Processing of Large Volumes of Data
564. What does Pentaho do?
565. What are the main components of the Pentaho solution?
566. Advanced Data Visualization with Pentaho
567. What are the advantages of Pentaho?
568. What is Pentaho?
569. Integrating Pentaho with Non-Traditional Data Sources
570. Implementing Pentaho in Small and Medium-Sized Enterprises
571. MS Access | How to Export Each Individual Record to PDF?
572. MS Access | Exporting MS Access Database to MS Excel with All Data
573. MS Excel | Creating Animations
574. VBA MS Access | 15 Examples of VBA Access Code that Interact with APIs - Application Programming Interface
575. Visual Basic for Applications | Using a VBA script to connect to an SQL database used by Microsoft Dynamics GP
576. Programming in Visual Basic for Applications (VBA) offers a number of benefits.
577. VBA Outlook - Using VBA in Outlook - Using Visual Basic for Applications in Outlook - Connecting to the Database using ADO
578. VBA Outlook - Usando o VBA no Outlook - Using Visual Basic for Applications in Outlook - Executando uma Consulta SQL (Executing an SQL Query)
579. VBA Outlook - Using VBA in Outlook - Using Visual Basic for Applications in Outlook - Reading Recordset Data
580. VBA Outlook - Using VBA in Outlook - Sending an email to each customer
581. VBA Outlook - Using VBA in Outlook - Closing the Connection
582. VBA Outlook - Usando o VBA no Outlook - Using Visual Basic for Applications in Outlook - Tratando Erros (Handling Errors)
583. VBA Outlook - Using VBA in Outlook - Using Visual Basic for Applications in Outlook - Using Parameters in SQL Queries
584. VBA Outlook - Using VBA in Outlook - Using Visual Basic for Applications in Outlook - Using Transactions
585. VBA Outlook - Using VBA in Outlook - Using Visual Basic for Applications in Outlook - Using a Disconnected Recordset
586. VBA Outlook - Using VBA in Outlook - Using Visual Basic for Applications in Outlook - Using DAO instead of ADO
587. eBook - PT - PUDIM PROJECT 2024 - Python Volume 11 - Automating Posts on Social Networks and Platforms - PUDIM PROJECT Series — André Luiz Bernardes
588. eBook - PT - PUDIM PROJECT 2024 - Python Volume 10 - Automating Posts on Social Networks and Platforms - PUDIM PROJECT Series — André Luiz Bernardes
589. eBook - PT - PUDIM PROJECT 2024 - Python Volume 09 - Automating Posts on Social Networks and Platforms - PUDIM PROJECT Series — André Luiz Bernardes
590. eBook - PT - PUDIM PROJECT 2024 - Python Volume 08 - Automating Posts on Social Networks and Platforms - PUDIM PROJECT Series — André Luiz Bernardes
591. eBook - PT - PUDIM PROJECT 2024 - Python Volume 07 - Automating Posts on Social Networks and Platforms - PUDIM PROJECT Series — André Luiz Bernardes
592. eBook - PT - PUDIM PROJECT 2024 - Python Volume 06 - Automating Posts on Social Networks and Platforms - PUDIM PROJECT Series — André Luiz Bernardes
593. eBook - PT - PUDIM PROJECT 2024 - Python Volume 05 - Automating Posts on Social Networks and Platforms - PUDIM PROJECT Series — André Luiz Bernardes
594. eBook - PT - PUDIM PROJECT 2024 - Python Volume 04 - Functions for Automation - PUDIM PROJECT Series — André Luiz Bernardes
595. eBook - PT - PUDIM PROJECT 2024 - Python Volume 03 - Automating Posts on Social Networks and Platforms - PUDIM PROJECT Series — André Luiz Bernardes
596. eBook - PT - PUDIM PROJECT 2024 - Python Volume 02 - Essential Functions - PUDIM PROJECT Series — André Luiz Bernardes
597. eBook - PT - PUDIM PROJECT 2024 - Python Volume 01 - Essential Functions - PUDIM PROJECT Series — André Luiz Bernardes
598. PUDIM PROJECT 2024 | Python - Learn to Encrypt and Decrypt Passwords Using Python
599. PUDIM PROJECT 2024 | Python - YAML and JSON Validation: Ensure Data Integrity in Kubernetes with These Simple Tools
600. PUDIM PROJECT 2024 | Python - Easily Copy File Contents to the Clipboard
601. PUDIM PROJECT 2024 | Python - Learn to Manipulate Dates and Times with the Pendulum Package in Python: Practical Examples
602. PUDIM PROJECT 2024 | Python - Simplify your Routine with These 8 Python Scripts to Automate Daily Tasks
603. The Top 12 Advanced Features of MS Excel in 2024604. AI Data Ingestion is not appealing, but its content IS - Bridging the Gap between Data and Meaning in Generative AI
605. Proficiency in Visual Basic for Applications (VBA) programming.
606. Are You Using ChatGPT Correctly?
607. DONUT PROJECT 2024 - VBA - Returns the Value of the System Clipboard Contents
608. DONUT PROJECT 2024 - VBA - Returns the Operating System Version on which Excel is running.
609. DONUT PROJECT 2024 - VBA - Development of Risk Analysis Tools
610. DONUT PROJECT 2024 - VBA - Development Obtain Operating System Version Information
611. DONUT PROJECT 2024 - VBA - Automating Engineering and Design Tasks
612. DONUT PROJECT 2024 - VBA - Automating Distance Measurement Processes in Google Maps
613. DONUT PROJECT 2024 - VBA - Automating Marketing Email Processes with Gmail
614. DONUT PROJECT 2024 - VBA - Marketing Email Process Automation
615. DONUT PROJECT 2024 - VBA - How to protect and hide formulas in an Excel spreadsheet using VBA
616. DONUT PROJECT 2024 - VBA - Code Exports data and updates the stock quantities of a specific product in the "Stock" spreadsheet.
617. Create Custom Functions with Visual Basic for Applications (VBA) for Business Data Analysis
618. eBook - DONUT PROJECT 2024 - Volume 03 - Financial Functions - André Luiz Bernardes
619. eBook - DONUT PROJECT 2024 - Volume 01 - André Luiz Bernardes
620. eBook - DONUT PROJECT 2024 - Volume 02 - Connecting Databases - André Luiz Bernardes
621. How to use Microsoft Copilot in the Chrome browser
622. How to use Microsoft Copilot on your mobile phone.
623. e-Book - Your Audience Cares: Make sure you talk about what your audience wants to know - André Luiz Bernardes and Ana Cláudia Santos Bernardes
624. e-Book - SPEAK IN PUBLIC +13 Tips - André Luiz Bernardes and Ana Cláudia Santos Bernardes
625. e-Book - SPEAK IN PUBLIC - 10 Tips - André Luiz Bernardes and Ana Cláudia Santos Bernardes
626. e-Book - 10 Tips for Public Speaking: Communicating through Oratory - André Luiz Bernardes and Ana Cláudia Santos Bernardes
627. Almost Everything Excel Can Do
628. 20 Terms Explained about Artificial Intelligence
629. Excel Keyboard Shortcuts
630. Box | Top 75 SaaS Companies You Need to Know
631. CrowdStrike | Top 75 SaaS Companies You Need to Know
632. Elastic NV | Top 75 SaaS Companies You Need to Know
633. Jamf | Top 75 SaaS Companies You Need to Know
634. KnowBe4 | Top 75 SaaS Companies You Need to Know
635. Okta | Top 75 SaaS Companies You Need to Know636. Proofpoint | Top 75 SaaS Companies You Need to Know
637. Rapid7 | Top 75 SaaS Companies You Need to Know
638. Splunk | Top 75 SaaS Companies You Need to Know
639. Wiz | Top 75 SaaS Companies You Need to Know
640. Chegg | Top 75 SaaS Companies You Need to Know
641. Coursera | Top 75 SaaS Companies You Need to Know
642. Duolingo | Top 75 SaaS Companies You Need to Know
643. Kahoot! | Top 75 SaaS Companies You Need to Know
644. Udemy | Top 75 SaaS Companies You Need to Know
645. Download | Online Sales Tracking Dashboard in Excel
646. Download | Marketing Analytics Dashboard in Excel
647. Download | Project Management Dashboard in Excel
648. Download | Operational Dashboard in Excel
649. Download | Human Resources Excel Dashboard
650. Data Analysis | Roadmap with FREE Resources! ⚡ 📊
651. Power BI | Roadmap and Preparation Resources for Certification - Certification Roadmap and Prep Resources for BI Professionals
652. Excel Power Query | Separating Cell Text into Rows
653. Google Trends | - Blogs 1
654. Google Trends | - Blogs 5
655. Google Trends | - Blogs 4
656. Google Trends | - Blogs 3
657. Google Trends | - Blogs 2
658. Google Trends | Understanding how it can help your business - What is it and how does it work?
659. Google Trends | Understanding how it can help your company - Why use this tool?
660. Google Trends | Understanding how it can help your company - How to use Google Trends?
661. Google Trends | Understanding how it can help your company - How to analyze the information?
662. Data Observability | Data Observability is Essential for DataOps
663. Data Observability | Why is Data Observability Important?
664. Data Observability | Key Features of Data Observability Tools
665. Data Observability | Data Observability versus Data Testing
666. Data Observability | Data Observability versus Data Pipeline Monitoring
667. Data Observability | Data Observability versus Data Quality
668. Data Observability | Data Observability versus Data Reliability Engineering
669. Data Observability | Data Quality versus Data Reliability
670. Data Observability | Signs that YOU need a Data Observability Platform
671. Data Observability | The Future of Data Observability
672.7 Terms Regarding Data Explained
673. What is Data Observability? 5 Key Pillars to Know
674. Use a shortcut to create a table - EXCEL TIPS FOR ADVANCED USERS
675. Import and update web data into Excel - EXCEL TIPS FOR ADVANCED USERS
676. See a formula evaluated step by step (Windows only) - EXCEL TIPS FOR ADVANCED USERS
677. Search for data using INDEX MATCH - EXCEL TIPS FOR ADVANCED USERS
678. Create multiple pivot tables for a category column - EXCEL TIPS FOR ADVANCED USERS
679. 'Non-dynamic' data - EXCEL TIPS FOR ADVANCED USERS
680. Sort the data in a pivot table - EXCEL TIPS FOR ADVANCED USERS
681. Create a summary cell that changes when you filter a table - EXCEL TIPS FOR ADVANCED USERS
682. Filter table data using slicers - EXCEL TIPS FOR ADVANCED USERS
683. Easily select columns and rows - EXCEL TIPS FOR ADVANCED USERS
684. Add a summary row to a Table - EXCEL TIPS FOR ADVANCED USERS
685. Google Sheets | Adding Subscript and Superscript to Spreadsheet Cells - How To Add Subscript and Superscript in Google Sheets
686. Google Sheets | 2030 - DOWNLOAD - LIST WITH ALL THE DAYS OF THE YEAR
687. Google Sheets | 2029 - DOWNLOAD - LIST WITH ALL THE DAYS OF THE YEAR
688. Google Sheets | 2028 - DOWNLOAD - LIST WITH ALL THE DAYS OF THE YEAR
689. Google Sheets | 2027 - DOWNLOAD - LIST WITH ALL THE DAYS OF THE YEAR
690. Google Sheets | 2026 - DOWNLOAD - LIST WITH ALL THE DAYS OF THE YEAR
691. Google Sheets | 2025 - DOWNLOAD - LIST WITH ALL THE DAYS OF THE YEAR
692. Google Sheets | 2024 - DOWNLOAD - LIST WITH ALL THE DAYS OF THE YEAR
693. Google Sheets | 2023 - DOWNLOAD - LIST WITH ALL THE DAYS OF THE YEAR
694. Google Sheets | 2022 - DOWNLOAD - LIST WITH ALL THE DAYS OF THE YEAR
695. Google Sheets | 2021 - DOWNLOAD - LIST WITH ALL THE DAYS OF THE YEAR
696. Google Sheets | 2020 - DOWNLOAD - LIST WITH ALL THE DAYS OF THE YEAR
697. Google Sheets | Inserting Barcodes
698. The Fundamental Journey of a URL
699. What is Object Databases?
700. What is Document Databases?
701. What is Time-series Databases?
702. What is Columnar Databases?
703. What is Graph Databases?
704. What is SQL (RDBMS|SGDBRDMS)?
705. What is NewSQL?
706. What is Ledger Databases?
707. What is Spatial Databases?
708. What is a Key-Value Database?
709. 10 Types of Databases
710. Excel | Using the New LineBreak Function - Transposing and Sorting Data
711. Excel | Using the New LineBreak Function - Creating Random Groups
712. Excel | Using the New BreakRows Function - Splitting a Data List into Columns
713. Excel | Using the New BreakColumns Function - Breaking Columns for Printing
714. Excel | New BreakCols Function
715. Excel | New Line Break Function
716. Cheat Sheet para o Chat GPT 002 - The Chat GPT Cheat Sheet - KDnuggets
717. Cheat Sheet para o Chat GPT 002 - The Chat GPT Cheat Sheet - Max Rascher
718. Cheat Sheet para o Chat GPT 001 - The Chat GPT Cheat Sheet
719. What is Python, and does it have advantages over VBA - Visual Basic for Applications?
720. Will Python kill VBA - Visual Basic for Applications?
721. Is it Worth Learning VBA - Visual Basic for Applications?
722. Which VBA (Visual Basic for Applications) learning curve is shorter?
723. Should a Systems Developer focus on learning VBA - Visual Basic for Applications?
724. Do many companies still use VBA - Visual Basic for Applications - to automate their processes?
725. Is VBA - Visual Basic for Applications - already installed in Office?
726. What is VBA - Visual Basic for Applications?
727. What is GPT-3? Everything you need to know about this language model.
728. GPT-3 and the Future of Content Writing: What to Expect?
729. GPT-3 and Chatbots: A Powerful Combination for Customer Service
730. GPT-3 and the Creation of Dialogues: A New Era for Interactive Games and Narratives
731. The Ethical and Legal Challenges of Using Language Models such as GPT-3
732. How to Train and Customize GPT-3 for Specific Tasks
733. GPT-3 and the Evolution of Automated Writing: Advantages and Disadvantages
734. GPT-3 and SEO: How to Optimize the Use of the Model to Obtain the Best Search Results
735. The Impacts of GPT-3 on Content Production for Social Networks736. How GPT-3 is helping in the Diagnosis and Treatment of Mental Illnesses
737. GPT-3 and the Creation of Smarter Virtual Personal Assistants
738. The Influence of GPT-3 on Machine Learning and Artificial Intelligence
739. How GPT-3 is helping in the development of multilingual chatbots
740. The Implications of GPT-3 in the Publishing and Journalism Industry
741. The Potential of GPT-3 to Transform How We Learn and Consume Information
742. Excel function to calculate travel time and distance using the Google Maps API with VBA
743. DOWNLOAD | LIST WITH ALL THE DAYS OF 2023
744. Data Pipeline
745. FREE COURSES | Data Scientist Training - Google
746. Alt codes for uppercase letters, lowercase letters, numbers, and keyboard symbols.
747. Alt Codes for Emoji and other fun characters
748. Alt Codes – How to type special characters and keyboard symbols in Windows using the Alt keys
749. Generating Symbols with the Keyboard
750. The 6 Essential Data Analysis Books
751. Excel Shortcut Keys - Excel Shortcuts Quick Reference
752. Data Driven - Data-Oriented Culture
753. Data Driven - The Transformation of Data
754. Data Driven - Data for everyone!
755. Data Driven - Technology Is Not the End Game756. HTML CheatSheet - As Tags Mais Importantes
757. Security Researchers | 21 - Internet Data Search Mechanisms
758. MYSQL Cheatsheet - Join Types
759. MS Access | Detectando e Extraindo Caracteres Invisíveis - UDF for Excel and Access that Extracts all Invisible and Special Characters
760. BRAZILIAN STATES | Respective Capitals and Abbreviations - By Geographic Region
761. DOWNLOAD CSV: LIST OF BRAZILIAN MUNICIPALITIES | AND Additional Information
762. DOWNLOAD CSV: LIST OF BRAZILIAN STATES | AND Additional Information
763. LIST OF BRAZILIAN STATES | Use of their respective definite articles
764. Excel - How to Format Negative Percentage Numbers in Red in Excel
765. KNIME - TOP Data Analysis Tools for Data Analysts
766. Tableau - TOP Data Analysis Tools for Data Analysts
767. Microsoft Power BI - TOP Data Analysis Tools for Data Analysts - Top Data Analysis Tools Every Data Analyst Should Know
768. SAS - Statistical Analysis System - TOP Data Analysis Tools for Data Analysts
769. Apache Spark - TOP Data Analysis Tools for Data Analysts
770. Jupyter Notebook - TOP Data Analysis Tools for Data Analysts
771. R Language - TOP Data Analysis Tools for Data Analysts
772. Python - TOP Data Analysis Tools for Data Analysts
773. Microsoft Excel - TOP Data Analysis Tools for Data Analysts
774. 08.07.22 | Internet Macros will be blocked by default in Office
775. Interactive Data Visualization | Parameterization Filters - 1st of FOUR Ways to Do It
776. Interactive Data Visualization | Parameter Binding - 2nd of FOUR Ways to Do It
777. Interactive Data Visualization | Drill-down with Linking - 3rd of FOUR Ways to Do It
778. Interactive Data Visualization | Dynamic Display of the Parameter Panel - 4th of FOUR Ways to Do It
779. SQL Cheat Sheet
780. TOP 9 Data Analysis Tools for Data Analysts
781. RARE STAMP Series - Copy Data from One File to Another
782. RARE STAMP Series - Show Hidden Lines
783. RARE STAMP Series - Delete Empty Rows and Columns
784. RARE STAMP Series - Find Blank Cells
785. RARE STAMP Series - Replace Empty Cells with a Value
786. RARE STAMP Series - Sort Numbers
787. RARE STAMP Series - Remove Empty Spaces
788. RARE STAMP Series - Highlight: Duplicate Values
789. RARE STAMP Series - Highlighting the Top 10 Values
790. RARE STAMP Series - Compare and Highlight a Value Greater Than Other Values
791. RARE STAMP Series - Highlight Cells with Comments
792. RARE STAMP Series - Highlight: Cells with Poorly Written Words
793. VBA Cheat Sheet
794. VBA - Visual Basic for Applications - Cheat Cheets, Cheat Sheet for MS Microsoft Excel
795. Python For Data Science Python Basics
796. 2022 | Como conectar Excel com Access? Create a data connection between MS Excel and MS Access
797. Python 3 Cheatsheet (the Basics)
798. Translating Functions in Excel Itself
799. Excel Formulas / Functions: English vs. Portuguese800. 10 Quick SQL Tips - Avoid DISTINCT if possible
801. 10 Quick SQL Tips - SQL Formatting
802. 10 Quick SQL Tips - Don't forget about window functions
803. 10 Quick SQL Tips - Watch Out for Dates
804. 10 Quick SQL Tips - Debugging
805. 10 Quick SQL Tips - Using SUM and CASE WHEN together
806. 10 Quick SQL Tips - CTE - Common Table Expression - Subqueries
807. 10 Quick SQL Tips - Dealing with NULL and DISTINCT
808. 10 Quick SQL Tips - Finding Examples in a Duplicate Record
809. 10 Quick SQL Tips - Checking for Distinct Counts in a Table
810. Shark Tip - VBA Excel | VBA Code to Search on Google
811. Shark Tip - VBA Excel | Insert Multiple Worksheets
812. Shark Tip - VBA Excel | Resize All Charts in a Worksheet
813. Shark Tip - VBA Excel | Unprotect Worksheet
814. Shark Tip - VBA Excel | Protect Worksheet
815. Shark Tip - VBA Excel | Protect all Worksheets Instantly
816. Shark Tip - VBA Excel | Highlight Unique Values
817. Shark Tip - VBA Excel | Highlight Cells with Comments
818. Shark Tip - VBA Excel | Create a Backup of the Current Workbook
819. Shark Tip - VBA Excel | Save Each Worksheet as a Single PDF
820. Shark Tip - VBA Excel | Delete all Blank Worksheets
821. Shark Tip - VBA Excel | Sort Worksheets
822. VBA Excel | Extracting the Date from a Cell with Date and Time - Remove Date from Date and Time
823. VBA Excel | Convert All to Uppercase - Convert to Upper Case
824. VBA Excel | Counting Words in a Spreadsheet - Word Count from Entire Worksheet
825. VBA Excel | Removing Decimals from Numbers - Remove Decimals from Numbers
826. VBA Excel | Multiply all the Values by a Number
827. VBA Excel | Calculating the Cube Root
828. VBA Excel | Adding Letters A through Z - Add AZ Alphabets in a Range
829. VBA Excel | Converting Roman Numerals to Arabic Numbers - Convert Roman Numbers into Arabic Numbers
830. VBA Excel | Convert all Negative Numbers to Positive Numbers - Remove Negative Signs
831. VBA Excel | Fill Blank Cells with Zeros - Replace Blank Cells with Zeros
832. eBook: Smarter Analytics Series: 5 Big Data Predictions - Author: André Luiz Bernardes
833. eBook: Data Science Series: Big Data, How? - Author: André Luiz Bernardes
834. eBook: DONUT PROJECT 2015 Series: Visual Basic for Applications Projects and Code - Author: André Luiz Bernardes
835. eBook: VBA Tips Series: Track Your Dashboards, Scorecards, Reports, Spreadsheets, and Applications - Tips and Code - Author: André Luiz Bernardes
836. eBook: Powerful Functions Series: 13 Powerful Functions in MS Excel - Author: André Luiz Bernardes
837. eBook: Visual Basic for Applications Series: Creating Access Logs: Tips and Code for Visual Basic for Applications - Author: André Luiz Bernardes
838. eBook: Top 10 Functions Series: Top 10 VBA Functions for Microsoft Excel - Author: André Luiz Bernardes839. DONUT PROJECT 2021 - VBA Function: Extracting the First Name or First Word from a Sentence
840. DONUT PROJECT 2021 - VBA Function: Extracting the Middle Name from a Full Name or the Second Word from a Sentence
841. DONUT PROJECT 2021 - VBA Function: Extracting the Last Surname from a Full Name or the Last Word from a Sentence
842. DONUT PROJECT 2021 - VBA Function: Decomposing a Name into the Dimensions of an Array843. DONUT PROJECT 2021 - VBA Function: Perform Google Searches From a Cell in MS Excel - Search Google From a Cell
844. DONUT PROJECT 2021 - VBA Function: How to Make a Form Transparent in MS Excel?
845. DONUT PROJECT 2021 - VBA Function: Converting a Matrix to a Vector
846. DONUT PROJECT 2021 - VBA Function: Create Acronyms from Text Strings
847. DONUT PROJECT 2021 - VBA Function: Do you know how to send data to Google Sheets from MS Excel using VBA on a MacBook?
848. DONUT PROJECT 2021 - VBA Function: How to Track Google Maps (Geographic Coordinates) in VBA Excel?
849. ApexSQL Documentation Series: The Best Database Documentation Tools
850. RedGate SQL - Series: The Best Database Documentation Tools
851. dbForge Documenter - Series: The Best Database Documentation Tools
852. Dataedo - Series: The Best Database Documentation Tools
853. DBScribe - Series: The Best Database Documentation Tools
854. SentryOne DOC xPress - Series: The Best Database Documentation Tools
855. Database Note Taker - Database Note Taker - Series: The Best Database Documentation Tools
856. Innovasys DocumentX - Series: The Best Database Documentation Tools
857. Genesis One T-SQL Source Code Separator - Series: The Best Database Documentation Tools
858. VBA - ConvertUTF8 Function - Converts the data contained in the cell to the UTF8 standard.
859. VBA - ReturnNthElement function - Extracts a position within a delimited data field.
860. VBA - Transaction Function - When MS Excel is not case sensitive
861. Python | Required Books
862. Batch File | How to Split a Text File into Multiple Smaller Text Files
863. C# | How to Split a Text File into Multiple Smaller Text Files
864. LinkedIn and Python | STEP 1 - Explore, Visualize, and Analyze Sentiments in Your Connections
865. CD: 1st of the TEN Most Productive Tricks, Shell Commands in the Command Line
866. Shell History: 2nd of the TEN Most Productive Tricks, Shell Commands in the Command Line
867. sl: 3rd of the TEN Most Productive Tricks, Shell Commands in the Command Line
868. Cowsay: 4th of the TEN Most Productive Tricks, Command Line Shell Commands
869. Oneko: 5th of the TEN Most Productive Tricks, Command Line Shell Commands
870. ASSOC: 6th of the TEN Most Productive Tricks, Shell Commands in the Command Line
871. FC: 7th of the TEN Most Productive Tricks, Shell Commands in the Command Line
872. IPCONFIG: 8th of the TEN Most Productive Tricks, Shell Commands in the Command Line
873. NETSTAT: 9th of the TEN Most Productive Tricks, Shell Commands in the Command Line
874. SYSTEMINFO: 10th of the TEN Most Productive Tricks, Shell Commands in the Command Line
875. COURSES - Creating Automation Applications with MS Office Excel
876. COURSES - Creating Professional Applications with MS Office Access
877. COURSES - Creating Professional Documents with MS Office Word
878. COURSES - Creating Professional Presentations in MS Office PowerPoint
879. ✔ VBA Brazil Specialist®
880. LIST OF BRAZILIAN STATES: Structure of the Brazilian Telephone System
881. Google Sheets vs Microsoft Excel: Part 1 - Which is better for your business?
882. Google Sheets vs Microsoft Excel: Part 2 - Which is better for your business?
883. VBA - I develop solutions: Excel, Access, Word, and Outlook applications.
884. DONUT PROJECT 2018 - VBA - 12 - Increase your Productivity
885. DONUT PROJECT 2018 - VBA - 11 - The Benefits of Version Control
886. DONUT PROJECT 2018 - VBA - 10 - Loop For-Each
887. DONUT PROJECT 2018 - VBA - 09 - Método Count
888. DONUT PROJECT 2018 - VBA - 08 - Referencing Ranges
889. DONUT PROJECT 2018 - VBA - 07 - Macro Sample
890. DONUT PROJECT 2018 - VBA - 06 - Additional Resources
891. DONUT PROJECT 2018 - VBA - 05 - Recording the First Macro
892. DONUT PROJECT 2018 - VBA - 04 - Solution Options
893. DONUT PROJECT 2018 - VBA - 03 - Requirements and Preparation
894. DONUT PROJECT 2018 - VBA - 02 - Remains Skeptical
895. DONUT PROJECT 2018 - VBA - 01 - Maximizing Your Efficiency
896. DONUT PROJECT 2018 - Excel - When Recording a Macro, Change the SELECT Method to RANGE
897. DONUT PROJECT 2018 - What We Developers Can Learn from Michael Jordan
898. DONUT PROJECT 2018 - Excel - Macros - Changing the Mindset
899. DONUT PROJECT 2018 - Excel - Speeding Up Macros - Disabling Update Features
900. What is Sway?
901. Microsoft Lync, Microsoft Office Communicator ou Skype for Business?
902. What is Microsoft Azure?
903. What is Yammer?
904. What is the Microsoft Graph?
905.3 - Microsoft Office Delve Analytics - Office Delve is Microsoft's new feature that intelligently lists useful information.
906.2 - Microsoft Office Delve Analytics - Transforming Data into Insights Without Compromising Privacy
907.1 - Microsoft Office Delve Analytics - What is it?
908. PIECE OF CAKE - MS Excel - Ziping - Compress to Zip format using the default Windows program - Zip file(s) with the default Windows zip program (VBA)
909. PIECE OF CAKE - MS Excel - Zipping - Open a window and choose the files you want to compress - Browse to the folder you want and select the file or files
910. PIECE OF CAKE - MS Excel - Ziping - Choose a Folder and Compress Everything in It - Browse to a folder and zip all files in it
911. PIECE OF CAKE - MS Excel - Ziping - Compress all files contained in the folder specified in the code - Zip all files in the folder that you enter in the code
912. PIECE OF CAKE - MS Excel - Zipando - Compactando a Planilha Atual - Zip the ActiveWorkbook
913. PIECE OF CAKE - MS Excel - Zipando - Compactando e Enviando por e-Mail - Zip and mail the ActiveWorkbook
914. PIECE OF CAKE - Connecting to Oracle 12g with Excel VBA
915. PIECE OF CAKE - Extract Path From String
916. PIECE OF CAKE - Detects if File Exists
917. PIECE OF CAKE - MS Excel - Finding Last Row
918. PIECE OF CAKE - Obtaining an IP Address
919. PIECE OF CAKE - Creating an External Text File
920. PIECE OF CAKE - Criando Tabelas no SQL Server a partir do MS Excel - Create SQL Server Tables from Excel Data – Free Tool
921. PIECE OF CAKE - Hungarian Notation
922. PIECE OF CAKE - A&A - Data or Information?
923. PIECE OF CAKE - Sempre Use Stored Procedures - Always Use Stored Procedures
924. PIECE OF CAKE - Microsoft Access - Removing Prefixes from Tables
925. PIECE OF CAKE - MS Access and MS Word - Automation Technique
926. PIECE OF CAKE - MS Access - Five Manual Repair Methods
927. PIECE OF CAKE - Metrics Correction - For Subscripts, Superscripts, and Common Types
928. PIECE OF CAKE - Converting Text to an Image - Convert Text to an Image using the VBA Windows API
929. PIECE OF CAKE - Excel - Manipule o Google Maps em sua Planilha - Put a Google Map in your Spreadsheet
930. PIECE OF CAKE - VBA Excel - Traduzindo Planilhas - MS Excel VBA Script to Translate worksheets using the Google Translate API
931. PIECE OF CAKE - Defina a Latitude e a Longitude - Find Latitude and Longitude of any address using Google Map API and VBA
932. 10 Data Visualization and Analysis Tools
933. OffCAT - Microsoft Office CAT - Configuration Analyzer Tool
934. Generating QR Codes with a Third-Party Library
935. VBA Excel - Changing the Spreadsheet Icon
936. VBA Tips Series - Application Access Log
937. VBA Word - VBA Cloth Capture
938. Main Trends in Data Analysis in 2017
939. Expose the secrets of the WMI API system with VBA
940. VBA Word - Formatting Text
941. Connecting to DB2
942. Connecting to Oracle
943. Conectando-se ao SQL Server - Connect to SQL Server
944. LIST OF BRAZILIAN STATES: Abbreviations, State, Capital, and Region - Complete List of Brazilian States: Abbreviations, Capitals, Regions, and More for BI and Data Analysis
945. VBA OFFICE - EXCEL, ACCESS, OUTLOOK, POWERPOINT
946. VBA Outlook - Exporting Fields to Excel
947. Holidays 2016 - 2017
948. VBA - 8 Tips to Reduce Errors During Development949. Index 2016 - 100 Artigos ✔ VBA Brazil Specialist®
950. Using Executive Dashboards for Hospital Management
951. VBA Access - Documenting Application Objects MS Access - Code Documenter
952. Ranking: DB-Engines - Database Management System Ranking
953. LinkedIn - SenseiDB
954. VBA OFFICE - EXCEL, ACCESS, OUTLOOK, POWERPOINT
955. How to Insert VBA Code Directly into Excel 2016
956. Access 2016 - Shell Function
957. Excel VBA - Saving Worksheets - Part 01 - Versions between 97-2003 and 2007-2016 - Use VBA SaveAs in Excel 97-2016
958. Save Spreadsheets with VBA - Part 02 - From version 2007 to 2016 - Use VBA SaveAs in Excel 2007-2016
959. Opening the VBA Editor in MS Excel 2016 - Open VBA Editor
960. Run a Macro in Excel 2016 for Mac - Run a Macro in Excel 2016 for Mac
961. Create or Delete Macros in Excel 2016 - How to Create or Delete Macros in Excel 2016 for Mac
962. VBA OFFICE - EXCEL, ACCESS, OUTLOOK, POWERPOINT
963. VBA OFFICE - EXCEL, ACCESS, OUTLOOK, POWERPOINT
964. VBA Excel - GMAIL - Sending 10,000 emails - Step 1
965. VBA Excel - GMAIL - Sending 10,000 emails - Step 2
966. VBA Excel - GMAIL - Sending 10,000 emails - Step 3
967. VBA Excel - GMAIL - Sending 10,000 emails - Step 4
968. VBA Excel - GMAIL - Sending 10,000 emails - Step 5
969. VBA Excel - GMAIL - Sending 10,000 emails - Step 6
970. VBA Excel - GMAIL - Sending 10,000 Emails - Step 7
971. VBA Excel - GMAIL - Sending 10,000 emails - Step 8
972. VBA OFFICE - EXCEL, ACCESS, OUTLOOK, POWERPOINT
973. VBA OFFICE - EXCEL, ACCESS, OUTLOOK, POWERPOINT
974. Rarely Used VBA Tricks - Protect Workbook
975. Rarely Used VBA Tricks - How to Log in to HTTPS Websites Using VBA in Excel
976. Rarely Used VBA Tricks - Using the Same Variables
977. Rarely Used VBA Tricks - Displaying Messages in the Status Bar
978. Rarely Used VBA Tricks - Don't Get Caught in the Loop
979. VBA Excel - What's new in Office 2016?
980. VBA Access - What's new in Office 2016?
981. VBA Outlook - What's new in Office 2016?
982. VBA Project - What's new in Office 2016?
983. VBA PowerPoint - What's new in Office 2016?
984. VBA Vision - What's new in Office 2016?
985. VBA Word - What's new in Office 2016?
986. 2016 Magic Quadrant for Business Intelligence e Analytics Platforms Report - Overview
987. Respect - A brief consideration
988. Microsoft Office 365 - Excel API - Microsoft Releases Access to Data
989. Intermediate Excel VBA - Using VLOOKUP in VBA - How to use the HLOOKUP Function - RetHLookup
990. Intermediate VBA - Function to Convert a Range to a String - Range to String - Function ConRngInStr
991. Intermediate VBA - Function that converts a Range to a String separated by [Enter] - Convert my Range Array to Single Cell String
992. Intermediate VBA - Function to Convert a Range to an Array - Range to Array - Function ConRngArray
993. EVERYTHING IN EXCEL SPREADSHEETS!
994. IMPROVE YOUR DATABASES AND MS ACCESS APPLICATIONS
995. Intermediate Excel VBA - Exporting TWO Ranges Simultaneously to PowerPoint
996. Intermediate Excel VBA - Exporting a Range to PowerPoint
997. Intermediate Excel VBA - How to Turn Off MS Excel Menus, Maximizing Dashboard View? - Hide/Show Ribbon Programmatically
998. e-Book: Demystifying Dols
999. SANDWICH PROJECT 2016 - VBA Excel - Force Caps Lock on Entry
1000. SANDWICH PROJECT 2016 - VBA Excel - Copy a Master Worksheet
1001. SANDWICH PROJECT 2016 - VBA Access - Importing Photos from a Directory
1002. SANDWICH PROJECT 2016 - VBA Excel - Breaking the Protection of a Protected Worksheet
1003. 30 Reasons to Never Give Up
1004. Office 2016 - Office Training Center
1005. Office 2016 - Quick Start Guides
1006. Intermediate Excel VBA - Changing the Reference of Multiple Charts at the Same Time
1007. VBA Excel Basic - Chart - Changing all Fonts of all Objects in all Charts
1008. VBA Excel Basic - Application.StatusBar Property
1009. VBA Excel Basic - Using the ScreenUpdating Property
1010. A&A - In Any Place
1011. DONUT PROJECT 2015 - Excel - Formatting a Pivot Field's Data
1012. DONUT PROJECT 2015 - Excel - Formatting a Pivot Table's Data
1013. DONUT PROJECT 2015 - Excel - Expand/Collapse Entire Field Detail - Expanding PivotTable Fields in Detail
1014. eBook - VBA Tips Series - DONUT PROJECT - VBA Projects and Code
1015. eBook - VBA Tips Series - Track Your Dashboards, Scorecards, Reports, Spreadsheets, and Applications - Book 3
1016. eBook - VBA Tips Series - 13 Powerful Functions in MS Excel - Book 4
1017. eBook - VBA Tips Series - Creating Access Logs - Book 1
1018. SANDWICH PROJECT 2016 - VBA Excel: Navigating between tabs
1019. SANDWICH PROJECT 2016 - VBA Excel - Chart - Redefine bubble size
1020. SANDWICH PROJECT 2016 - VBA Excel: Looping through a named range
1021. SANDWICH PROJECT 2016 - VBA Excel: Defining the Chart Type
1022. SANDWICH PROJECT 2016 - VBA Access: Copying a query with a different name programmatically
1023. SANDWICH PROJECT 2016 - VBA Access: Deleting tables and queries programmatically
1024. DONUT PROJECT 2015 - Extraindo e-Mails - Extracting An Email Address From Text
1025. DONUT PROJECT 2015 - Function - Extracting Any Elements from a String using the Limiter
1026. DONUT PROJECT 2015 - Function - Returns the number of occurrences of a character in a string.
1027. DONUT PROJECT 2015 - Function - Returns any content delimited by 2 characters.
1028. DONUT PROJECT 2015 - Function - Returns Only the Content Between Parentheses
1029. DONUT PROJECT 2015 - Function - Extract Content Between Parentheses
1030. DONUT PROJECT 2015 - Excel - Report Layout
1031. DONUT PROJECT 2015 - Excel - Grand Totals - Inserting Totals for all Columns and Rows in a Pivot Table
1032. DONUT PROJECT 2015 - Excel - Change Pivot Table Data Source Range - Changing the Pivot Table Data Source
1033. DONUT PROJECT 2015 - Excel - Refresh Pivot Tables - Applying Refresh to Pivot Tables
1034. DONUT PROJECT 2015 - How To Create Partially Anonymous Data - How to Keep Information Partially Anonymous
1035. DONUT PROJECT 2015 - Excel - Clear Report Filter - Clearing the PivotTable Filter
1036. DONUT PROJECT 2015 - Excel - Report Filter On Multiple Items - Creating Multiple Filters in a Pivot Table
1037. DONUT PROJECT 2015 - Excel - Report Filter On A Single Item - Creating a Report Filter in a Pivot Table
1038. DONUT PROJECT 2015 - Excel - Remove Calculated Pivot Fields - Removing Calculated Fields from Pivot Tables
1039. DONUT PROJECT 2015 - Excel - Remove Pivot Fields - Removing Fields from a Pivot Table
1040. DONUT PROJECT 2015 - Excel - Add A Values Field - Adding Calculated Fields to a Pivot Table
1041. DONUT PROJECT 2015 - Excel - Add Calculated Pivot Fields - Adding Calculated Fields to a Pivot Table
1042. DONUT PROJECT 2015 - Excel - Add Pivot Fields - Added Fields to the Pivot Table
1043. DONUT PROJECT 2015 - Excel - Delete All Pivot Tables
1044. DONUT PROJECT 2015 - Excel - Delete a Specific Pivot Table
1045. DONUT PROJECT 2015 - VBA To Add A Confidentiality Footer Statement In Excel, Word, or PowerPoint - Adding a Footer with a Confidentiality Status in Excel, Word, or PowerPoint
1046. DONUT PROJECT 2015 - Excel - Create A Pivot Table
1047. DONUT PROJECT 2014 - Use MS Excel add-ins and take a leap in your performance.
1048. DONUT PROJECT 2014 - VBA - Automating Outlook to send an email with an attachment
1049. DONUT PROJECT 2014 - VBA - Outlook - Saving all attached files in emails
1050. DONUT PROJECT 2014 - VBA - Creating a MAT Date Matrix - Moving Annual Total
1051. DONUT PROJECT 2014 - VBA - Excel - Updating Pivot Tables - Refresh Pivot Table via VBA
1052. DONUT PROJECT 2014 - VBA - Excel - Removing Alphabetic and Special Characters
1053. DONUT PROJECT 2014 - VBA - Access - Creating a Query with Parameters
1054. DONUT PROJECT 2014 - VBA - Access - Updating the content of a Query
1055. DONUT PROJECT 2014 - VBA - Access - Find the Record Number for each table
1056. DONUT PROJECT 2014 - VBA - Access - Extract Data Blocks from the Database - No Timeout Problems
1057. DONUT PROJECT 2014 - VBA - Access - List the Size of All Tables
1058. A BRIEF RETROSPECTIVE...
1059. DONUT PROJECT 2014 - VBA - Excel - Populating a ListBox in your Form
1060. DONUT PROJECT 2014 - VBA - Excel - Importing CSV files
1061. DONUT PROJECT 2014 - VBA - Excel - Deleting Data Connections
1062. DONUT PROJECT 2014 - VBA - Excel - Getting the Workbook Name without the Extension
1063. DONUT PROJECT 2014 - VBA - WORD - Automated Export - From *.docx to *.pdf - Optimizing the size
1064. VBA Excel - Count Distinct Occurrences in a Range - Count Distinct Or Unique Values - VBA UDF
1065. VBA Tips - 3 of the 10 Main Interactions with Windows APIs - GetComputerName
1066. Excel Tips - 03 - PowerPivot Glossary - DAX Terms and Concepts
1067. Business Intelligence - 4 Worst BI Practices
1068. VBA Tips - 2 of the 10 Main Interactions with Windows APIs - GetUserName
1069. VBA Excel - DIR Function - 01 - Loop Through the Files in a Folder
1070. VBA Excel - DIR Function - 02 - List the files from a folder on a worksheet
1071. VBA Excel - DIR Function - 03 - Checking if a File Exists
1072. Excel VBA - List all the Worksheets in a Folder - List All the Excel Files in a folder
1073. VBA Access - Usando built-in enumerations nas suas procedures - Using built-in enumerations in your procedures
1074. Series - LinkedIn - Work on your Profile - 01 - Promote your company
1075. VBA Tips - Medical Specialties
1076. VBA Tips - One of the Top 10 Interactions with Windows APIs - Sleep
1077. Excel Tips - Compact Calendar for 2014 - THE COMPACT CALENDAR 2014
1078. Business Intelligence Analyst - Let's stimulate your analytical potential.
1079. Data Visualization - 03 - PowerPivot and SSAS - Landing Zone1080. VBA EXCEL - 10 TIPS FOR DEVELOPERS - 2 - IDENTIFY YOUR CODE
1081. VBA Excel - Copy and Paste Examples - 05
1082. VBA Excel - Copy and Paste Examples - 04
1083. VBA Excel - Copy and Paste Examples - 03
1084. VBA Excel - Copy and Paste Examples - 02
1085. VBA Excel - Copy and Paste Examples - 01
1086. VBA Excel - Find criteria in the cell and delete the row - Find Values Delete Rows
1087. VBA Excel - Looping através das Abas com o AutoFiltro - Loop through sheets and filter
1088. VBA Excel - Retrieve a Value from a Formula in each Sheet - Get a value from a formula in each sheet
1089. VBA Excel - Get the value of a range by looping through the sheets - Loop Through Sheets and get Value from a range
1090. VBA Excel - Procurando um valor na Coluna A com Looping - Find a Value in Column A using a loop1091. VBA EXCEL - 10 TIPS FOR DEVELOPERS - 1 OPTION EXPLICIT
1092. BI - QMG - Quadrado Mágico do Gartner - Magic Quadrant for Business Intelligence and Analytics Platforms
1093. Infographics - An Infographic Lesson on Typography
1094. Infographics - What is LITERACY?1095.03 - YOUR AUDIENCE CARES - IMAGES – Visual Impact
1096. VBA Excel Series - 02 - VBA or MACROS
1097. Data Visualization - 02 - PowerPivot and SSAS
1098. Excel Tips - 02 - PowerPivot Glossary - SharePoint Terms and Concepts
1099. Data Visualization - 01 - PowerPivot and SSAS
1100. Excel Tips - 01 - PowerPivot Glossary - PowerPivot Terms and Concepts
1101. VBA Excel - Clearing Filters
1102. VBA Excel - Filtering Tables or Lists
1103. VBA Excel - Copying a table or list to a new worksheet
1104. VBA Excel - Checking if the active cell is in a table or list
1105. VBA Excel Series - 03 - VBA or MACROS1106.02 - YOUR AUDIENCE CARES - ROBOTS – Are they legal?
1107. VBA Excel Series - 01 - VBA or MACROS
1108. VBA Excel Series - Animating Sparklines - Animate a Sparkline
1109. Dashboard - 5 great web-based data visualization applications
1110. Dashboards - Many Eyes and the NEO Project1111.01 - YOUR AUDIENCE CARES - EMPATHY - What you say needs to be exclusively in your own way.
1112.04 - YOUR AUDIENCE CARES - STORYTELLING – A good story
1113.05 - YOUR AUDIENCE CARES - TEXT – Less text, more content
1114.06 - YOUR AUDIENCE CARES - FOR REAL - Look in the mirror
1115.07 - YOUR AUDIENCE CARES - RHETORIC – Don't give a speech!
1116. VBA Access - Adicionando Colchete para SQL - SQL Add Brackets
1117. VBA Access - Change the Path of Connected Tables - Change Link Path
1118. VBA Access - Calcula Idade - Calculate Age
1119. VBA Access - Break a Line from a Character - BreakTextAtX
1120. VBA Access - Remove Prefixes from Your Tables - Remove the Prefixes on Linked Tables
1121. VBA Access - Convert Numbers to Text
1122. OFFICE 2013 - Quick Start Guides - Visio 2013
1123. OFFICE 2013 - Quick Start Guides - Publisher 2013
1124. OFFICE 2013 - Quick Start Guides - Project 2013
1125. OFFICE 2013 - Quick Start Guides - Outlook 2013
1126. OFFICE 2013 - Quick Start Guides - OneNote 2013
1127. OFFICE 2013 - Quick Start Guides - PowerPoint 2013
1128. OFFICE 2013 - Quick Start Guides - Word 2013
1129. OFFICE 2013 - Quick Start Guides - Excel 2013
1130. OFFICE 2013 - Quick Start Guides - Access 2013
1131. Office Tips - Office 2013 - Pograma MVA
1132. Excel Slicer VBA - SlicerCache Object
1133. Excel Slicer VBA - Data Slicer Object
1134. Excel Slicer VBA - Inserting or Modifying Slicers
1135. VBA Excel - Enviando emails via VBA - Send Email Using VBA
1136. VBA Excel - Enviando emails via CDO - Send Email Using CDO
1137. VBA Excel - Enviando emails usando Send Keys - Send Email Using Send Keys
1138. BIG DATA and Traditional Analysis - Choose speed and better results
1139. BIG DATA - Make better business decisions faster
1140. VBA Excel - Defining the last row - How To Delete Rows
1141. How much is your HOUR worth?
1142. VBA Excel - Populando Listbox com Multi-Colunas - Multi-column List
1143. VBA Excel - Populando Listbox - userform listbox
1144. VBA Tips - ADO - Creating a Table
1145. VBA Excel - Accelerate your Dashboards, Reports, and Scorecards
1146. VBA Tips - GetComputerName - API - Obtaining the Computer Name via API
1147. VBA Tips - GetUserName - API - Obtaining the User's Name using an API
1148. VBA Tips - SendLotusEmails - Send emails with Lotus Notes
1149. VBA Tips - Launch IE - Loading Internet Explorer with a page
1150. VBA Tips - GetComputerName - Knowing the computer's name
1151. VBA Tips - GetUser - Find out the name of a Windows user.
1152. Excel 2013 - Specifications and Limitations
1153. Excel Basic - Shortcut Keys
1154. DATA MINING - Is it Dead?
1155. VBA Excel Basic - Using the IF Conditional and the FOR Loop - Example of an If Condition and For Loop
1156. VBA Excel Basic - How to Merge and Unmerge Cells
1157. VBA Excel Basic - Setting Row Height and Column Width - How To Set The Row Height And Column Width
1158. VBA Excel Basic - Inserting and Deleting Rows and Columns - How To Insert And Delete Rows And Columns
1159. VBA Excel Basic - Making Rows and Columns Visible or Not - How To Hide and Unhide Rows and Columns
1160. VBA Excel Basic - Criando uma nova Planilha - How To Create New Workbook, Add Data, Save And Close The Workbook
1161. VBA Excel Basic - How to add a new tab to a worksheet - How to add a new worksheet, rename a worksheet, and delete a worksheet.
1162. VBA Excel Basic - Getting the Active Sheet and Workbook Names - How To Get The Active Sheet Name And Workbook Name
1163. VBA Excel Basic - How to Select and Activate a Worksheet
1164. VBA Excel Basic - How to Copy Data From One Range to Another Range
1165. VBA Excel Basic - How to Make Text Uppercase - How To Change The Text To Upper Case Or Lower Case
1166. VBA Excel Basic - How to Change the Font Color and Size in a Range
1167. VBA Excel Basic - How to Change the Background Color in a Range
1168. VBA Excel Basic - How to enter data into a cell
1169. VBA Excel Basic - Como acessar o valor de um Range mostrando-o num Message Box - How To Access The Excel Range And Show The Value Using Message Box
1170. Excel Data Mining - Processing Billions of Rows via the Cloud - New, fast Excel to process billions of rows via the cloud.
1171. BIG DATA - Managing corporate data overload
1172. VBA Excel - Manipulate Icons in your Worksheets - Add Icon Sets for Ranges
1173. VBA Excel - Working with Temporary Files and Folders
1174. VBA Excel - Sending Email with Excel
1175. VBA Excel - Ordenando as Abas da sua Planilha - Sorting By Name And Ordering Worksheets In A Workbook
1176. VBA Excel - Using MS Excel as a database
1177. VBA Excel - Converting to Images
1178. Access VBA Advanced - Usando o Poder do VBScript e do WMI - Using the Power of VBScripts and WMI in Microsoft Access VBA
1179. Expanding the understanding of VBA
1180. Excel Tips - Converting A1 notation content to R1C1 - Convert A1 notation to R1C1
1181. VBA PowerPoint - Updating chart with data from MS Excel
1182. VBA ACCESS - Handling Images in Forms – Picture in Forms
1183. VBA Access - How to load an image into a form
1184. VBA Excel - Formatting multiple cells
1185. VBA Excel - Deleting duplicate rows
1186. VBA Outlook - Tracking Project in Excel Dashboard - Tracking Outlook emails in Excel dashboard
1187. VBA PowerPoint - Saving PowerPoint presentations as PDF - How to Save PowerPoint Presentation as PDF using VBA
1188. VBA PowerPoint - Convert Slide Text to Comment Notes - Convert PowerPoint TextBox Slides as Notes
1189. VBA Excel - Save a chart as an image - How to Save a Chart as an Image using Excel VBA
1190. VBA PowerPoint - Same Fonts and Colors
1191. VBA Excel - Export as delimited text
1192. VBA Excel - 13 Interesting Functions
1193. VBA Excel - Refresh All Pivot Tables
1194. VBA Excel - Make Your Forms Transparent - Transparent Forms API EXCEL VBA
1195. VBA ACCESS - Compacting the application on exit
1196. VBA Excel - Return the Worksheet Name
1197. What are 7 billion people involved in right now?
1198. Excel Tips - Populando Combo Box - Multi-Column
1199. Excel Tips - Sort Alphabetically as suas Abas - Sort your worksheets
1200. Excel Tips - 10 Tips for Developers
1201. Tips - Track your Dashboards, Scorecards, Reports, Spreadsheets, and Applications.
1202. VBA Excel - Sorting data in a chart - Graph data table sorting via VBA
1203. Tips - Data Hygiene - Data Scrubbing - Data Cleansing
1204. Excel Tips - Applying the correct zoom to your dashboards
1205. A&A - Data or Information?
1206. Excel Tips - Sending emails from Excel
1207. ACCESS Tips - Campo Auto Numérico - Creating an AutoNumber field from code - VBA, DAO, DDL e SQL
1208. Excel Tips - Interacting with APIs - UserForms With Windows API Functions
1209. Excel Tips - How to compress XLSX files to even smaller sizes - How to Compress XLSX Files to the Smallest Possible Size
1210. Excel Tips - Deleting blank rows when opening the spreadsheet - Removing Blank Rows Automatically
1211. VBA Tips - Log Files
1212. Excel Tips - Make your spreadsheets smaller - SHRINK REDUCE EXCEL FILE SIZE
1213. Excel Tips - Increasing the startup speed of your MS Excel - Speed up Excel Startup - Faster Excel
1214. BIG DATA: Google - How to take ownership of BIG DATA?
1215. VBA Tips - Embutindo um Documento Word no Excel - Embed Existing Word File to Spreadsheet using Excel VBA
1216. VBA Tips - Converting Mapped Drives to UNC
1217. VBA Tips - Returning a UNC Path
1218. VBA Excel - Show only the report - Show only a few rows and columns in Excel
1219. VBA Tips: Generating the QR code in your application - Generate QR code
1220. VBA Access - Clear the contents of all fields in all tables in your MS Access application.
1221. VBA Tips - Sending email with VBA code - Send From Gmail
1222. VBA Tips - Compressing and Decompressing Files
1223. VBA - Using pattern matching to parse data from a string
1224. BIG DATA - Immersion or PRISM - Understanding Metadata in Gmail
1225. VBA Outlook - Automatically sends a blind carbon copy (BCC) to an email address.
1226. Professionals seek opportunities.
1227. Smarter Analytics - Five Big Data Predictions
1228. Tips: The BSC from the Customer Perspective - Balanced Scorecard Customer Perspective
1229. SQL Server 8 R2 - Business Intelligence Development Studio
1230. Series - Tip on how to use LinkedIn in a professional profile - 06 - Say Hello to Search Engines
1231. Microsoft Office - Complete Development Platform
1232. MHDI - Atlas of Human Development in Brazil 2013 - Municipal Human Development Index
1233. Office Tips: OBA Sample Application Kits
1234. Excel Tips: Introduction to Excel Web App
1235. Information Architecture
1236. VBA Excel - Saving the Spreadsheet as Read-Only - How to Make a File ReadOnly
1237. VBA Excel - Desinstalando AddIns - Programmatically uninstall Excel Addins using VBA
1238. VBA PowerPoint - Saving the Presentation as PDF - How to Save a PowerPoint Presentation as PDF using VBA
1239. VBA Excel - Ajuste o layout de diversas planilhas - Loop through all worksheets in all Excel workbooks in a folder to change the font, font size, and alignment of text in all cells
1240. Data Analytics - Compliance - Errors and Risks
1241. Questions, Issues and Answers...
1242. VBA Excel - Listing all available tabs - List Of Available Tabs In VBA
1243. Microsoft Office - Office Developer Training Kit
1244. Pharma Brazil: FRANCE - Older, smarter, more conscious value: The transformation of the consumer.
1245. How to Build Infographics - VBA Developers, take the plunge!
1246. VBA Excel - Creating an Access Log
1247. VBA Excel - Returns the Last Row of a Worksheet
1248. VBA Excel - Returning the Column Boundary of a Range
1249. Extrair eMails
1250. VBA Excel - Liste todas as Fontes instaladas no MS Excel - Display all installed fonts using VBA in Microsoft Excel
1251. Infographic - Learn how to choose the most suitable seat
1252. VBA Excel - Hiding Tabs very well - Choose from Hidden or Very Hidden
1253. VBA Excel - Show all hidden tabs - Show All Worksheets
1254. Tips - Shortcut Keys - SHIFT
1255. Tips - Shortcut Keys - CTRL
1256. Tips - Shortcut Keys - ALT
1257. VBA Excel - Working with Header and Footer Properties Using Excel.PagesAndPage
1258. VBA Tips - Example of the ActiveConnection catalog property in ADOX code
1259. Excel Tips - 4th Example of 5 Cool Things to Do with Data Explorer - Get your company's list of people and emails.
1260. VBA Tips - Declaring Variables in Forms - How to Declare Variables as a Form in VBA
1261. VBA Tips - Compiling VBA Code - How to Compile VBA Code
1262. BIG DATA - The phenomenon called BIG DATA
1263. BIG DATA - Big Data Professional - What to expect?
1264. VBA Tips - Making our applications speak - Speak
1265. Excel Tips - Example 3 of 5 Cool Things You Can Do With Data Explorer
1266. VBA Access - Closing ALL Open Reports - Close All Forms
1267. VBA Tips - Microsoft VBA Security Update MS03-037
1268. Half of half...1269. List 2013 - 200 Excel Books - General References
1270. Excel Tips - Example 2 of 5 Cool Things You Can Do With Data Explorer
1271. SQL Server 2014 - Unlocking Real-Time Insights1272. BIG DATA - PDD - Smarter Analytics Cases in Practice
1273. VBA Excel - Google Books API - How to retrieve data from a list of books with ISBN in Excel
1274. Excel Tips - Example 1 of 5 Cool Things You Can Do With Data Explorer1275. List 2013 - 200 Excel Books - Business
1276. VBA Excel - Copy Files from their Dates - Copy all files between certain dates
1277. VBA Excel - Copy all Excel files
1278. VBA Excel - Move all Excel files
1279. Series - Tip on how to use LinkedIn in a professional profile - Develop answers1280. List 2013 - 200 Excel Books - VBA
1281. VBA Tips Exclusive - Spontaneous Generation of Retroactive Dates
1282. Business Intelligence - 03 of 10 - Classic Rules for Implementation
1283. Access Tip - Using and Running Queries with VBA - Using and Running Queries in VBA Code
1284. VBA Access - Exporting Reports to PowerPoint - Working with PowerPoint Presentations from Access Using Automation
1285. VBA Access - Managing Relationships - VBA code for creating MS Access Relations
1286. VBA Access - Re-Conectando Tabelas - Relinking database tables
1287. VBA Access - Inserindo SQL Dinâmico na Query - Access 2013 Generate dynamic SQL statements
1288. Excel Tips - Logical Functions
1289. Business Intelligence - 04 to 10 - Classic Rules for Implementation
1290. Office 2013 - Access 2013 - 10 Relevant Positive Points
1291. VBA Tips - Deleting Files - Delete Files and Folders
1292. VBA Word - Open a document and find a word in it - Function to open/get a Word document and find a string
1293. Business Intelligence - 02 of 10 - Classic Rules for Implementation
1294. VBA Access - Alterando a Barra de Status - Message in Status bar
1295. VBA Word Tips - Insert Images from a Directory into Word - Batch insert pictures with filenames as captions
1296. VBA Excel Tips - Convert email addresses to hyperlinks
1297. VBA Excel Tip - Insert Photos in Cell Comments - Add photos to cells inside comments
1298. VBA Excel Tips - Add borders to all cells with content - Put borders around all used cells on a sheet
1299. VBA Excel Tips - Change the Font of All Cells with Comments - Change font on all cell comments
1300. Excel Tips - Delete all Pictures and Charts from a Worksheet
1301. Excel Tips - Livro John Walkenbach's - Favorite Excel 2010 Tips and Tricks
1302. Tips - How to change the color palette for workbooks in MS Excel
1303. Excel Tips - Lookup and Reference Functions
1304. Business Intelligence - 1 of 10 - Classic Implementation Rules
1305. SQL Server - 03 - Encriptação no SQL Server 2008 - Database Encryption in SQL Server 2008 Enterprise Edition
1306. Dashboards - Considerations for building a good model.
1307. Series - Tip on how to use LinkedIn in a professional profile - 07 - Build a Professional Network - Start building your network
1308. Access 2010 Tip - Sharing the same image - Shared images
1309. VBA Excel - Add a Module from a Text File - Add content to a module from a file using VBA in Microsoft Excel
1310. VBA Excel - Inserting Headers and Footers - Insert headers and footers using VBA
1311. Excel Tips - Math and Trigonometry Functions
1312. GEOFLOW - Simulation of seasonal electricity use in Dallas - GeoFlow: 3D Simulation of Seasonal Energy Usage in Dallas for BI and Advanced Analytics
1313. The evolution of Gmail1314. BIG DATA - PDD - Data Disposal Policy
1315. Geoflow - visualização 3D de dados no MS Excel - GeoFlow: Unlock 3D Data Visualization in Excel for BI, Power BI, and Advanced Analytics
1316. SQL Server - 02 - Encriptação no SQL Server 2008 - Database Encryption in SQL Server 2008 Enterprise Edition
1317. Excel Tips - Financial Functions
1318. VBA Tips - Detecting content in a text file external to the application
1319. VBA Tips - Grave arquivo texto externo - write to external text file without quotes in VBA
1320. SQL Server - 01 - Encriptação no SQL Server 2008 - Database Encryption in SQL Server 2008 Enterprise Edition
1321. VBA Access - Métodos de Conexão ao SQL Server - Methods of Connecting to SQL Server
1322. Excel Tips - Information Functions
1323. Business Intelligence - Apresentando o Business Intelligence Development Studio - 03
1324. Series - Tip on how to use LinkedIn in a professional profile - 06 - Pay attention to at least three external links
1325. VBA Excel - Compact your Spreadsheets - Use VBA SaveAs in Excel 2007-2013
1326. Business Intelligence - Apresentando o Business Intelligence Development Studio - 02
1327. Excel Tips - Text Functions - Text Functions
1328. Series - Tip on how to use LinkedIn in a professional profile - 05 - See what your peers are doing
1329. VBA Outlook - Inserting a signature into an email using Early Binding - Insert Outlook Signature in mail
1330. VBA Outlook - Inserting a simple signature into an email as a TXT file - Insert Outlook Signature in mail
1331. VBA Outlook - Inserting a signature into an email without an image - Insert Outlook Signature in mail
1332. VBA Outlook - Inserting a signature in an email with or without an image - Insert Outlook Signature in mail
1333. VBA Excel - Sending more than one spreadsheet by email - Send more than one sheet with SendMail
1334. VBA Excel - Excel 2007 - Exporting to SharePoint
1335. Excel Tips - Statistical Functions
1336. VBA Excel - Capturing all worksheets from a directory
1337. VBA Access - Hidden - Creating a new database
1338. Business Intelligence - Apresentando o Business Intelligence Development Studio - 01
1339. Excel Tips - Engineering Functions
1340. Excel Tips - Date and Time Functions
1341. Series - Tip on how to use LinkedIn in a professional profile - 04 - Go further
1342. Tips - The little ants and Mrs. Cockroach.
1343. Excel Tips - Database Functions
1344. Excel Tips - Functions for use with Cube - Cube functions
1345. Excel Tips - Add-in and Automation Functions1346. Tips - Copying a set of files from one folder to another using VBA
1347. Office 2013 - Business Intelligence - Powerful Features
1348. Excel 2013 - New Internal Data Model
1349. Excel 2013 - Distinct Count in Pivot Tables
1350. Excel 2013 - Criando um Cockpit Real - Open Excel workbooks in separate windows and view them side by side
1351. Excel Tips - Order in which MS Excel performs operations in formulas
1352. VBA Tips - How to check for a tab character in VBA
1353. Excel Tips - Showing the Developer tab in Excel 2010
1354. Series - Tip on how to use LinkedIn in a professional profile - 02 - Update your photo
1355. Business Intelligence - Business Intelligence Solution
1356. VBA Access - Adicionando novas Sheets no mesmo Workbook - Adding new sheets to Excel
1357. VBA Advanced - API Functions - Declaring API Functions
1358. VBA Excel - Interacting with AutoFilter Functions - Excel List AutoFilter VBA
1359. Business Intelligence - End-to-End Microsoft Business Intelligence
1360. Series - How to Use LinkedIn in a Professional Profile - 01 - LinkedIn Tips for Business Professionals
1361. VBA Excel - Copiando os valores de uma planilha para outra - VBA to loop through cells with date in worksheet 1, extract to worksheet 2 if month and year match
1362. VBA Excel - DAO, ADO and ADOX, updating the Excel Front End
1363. VBA Access - Outlook vs Access
1364. Tips - Control Charts
1365. A&A - VBA Solutions
1366. Excel VBA - AutoFilter - Count Visible List Rows - Excel List AutoFilter VBA - Count Visible List Rows
1367. VBA Excel - AutoFilter - Copying Specific Filtered Rows with Headings - Excel List AutoFilter VBA - Copy Filtered List Rows With Headings
1368. VBA Excel - AutoFilter - Copying Specific Filtered Rows Without Headings - Excel List AutoFilter VBA - Copy Filtered List Rows Without Headings
1369. VBA Excel - Autofiltro - Visualizar todas as setas da Lista AutoFiltro - Excel List AutoFilter VBA - Show All List AutoFilter Arrows
1370. Excel VBA - AutoFilter - Hiding Specific Columns in AutoFilter Lists - Excel List AutoFilter VBA - Hide List AutoFilter Arrows Specific Columns
1371. VBA Excel - AutoFilter - Hiding all arrows in the AutoFilter list except one - Excel List AutoFilter VBA - Hide List AutoFilter Arrows Specific Columns
1372. VBA Excel - Autofiltro - Contando as Listas de AutoFiltros - Excel List AutoFilter VBA - Count List AutoFilters
1373. Excel VBA - AutoFilter - Turning Off List AutoFilter
1374. VBA Excel - AutoFilter - Enabling the AutoFilter of our List - Excel List AutoFilter VBA - Turn On List AutoFilter
1375. VBA Excel - AutoFilter - Showing All Records - Excel List AutoFilter VBA - Show All Records
1376. VBA Excel - Exporting the chart as a GIF image - Exporting an active chart image
1377. VBA Excel - Delete all charts from the workbook - Delete All Charts in Workbook
1378. Access VBA Advanced - Usando o Poder do VBScript e do WMI - Using the Power of VBScripts and WMI in Microsoft Access VBA
1379. VBA Tips - How to Open a Website - Open a Website With VBA
1380. Tips - Dashboards, Scorecards and Reports - Several Report Examples
1381. VBA Excel 2010 - Remove properties from your worksheet - Remove Various Properties Using Excel.RemoveDocumentInformation
1382. English Tips - Prepositions of Place and Direction - Prepositions of Place
1383. VBA Excel - Sending the Chart to the Email Body - Code to send Chart in Outlook Mail body
1384. VBA Excel - Delete all charts on worksheet
1385. VBA Excel - Populating Combo Boxes in Forms - Populate form control combo boxes using VBA
1386. VBA Excel - Populating List Boxes in Forms - Populate form control list boxes using VBA
1387. VBA Tips - Creating folders via VBA code
1388. VBA Access 2013 - Making Data Entry Creation Easy
1389. MS Excel 2013 - Brief Overview
1390. Infographic: Relieve and treat a sore throat.
1391. English Tips - English Descriptive Words - Descriptive Words
1392. Tips - Excel ou o Access? - Microsoft Access X Microsoft Excel - For Data Analysis and Reporting
1393. VBA Tips - Displaying Time in Milliseconds - How to Get Time in Milliseconds using VBA
1394. Excel Tips - Compressing Excel Spreadsheets - COMPRESS EXCEL WORKBOOKS/REDUCE FILE SIZE
1395. Office Tips - Launch of Office 2013 and Office 365
1396. Excel Tips - Compact Calendar for 2013 - THE COMPACT CALENDAR 2013
1397. Relax - My Garden in a Bottle - David Latimer
1398. VBA Tips - Send emails directly through BOL and UOL - Send Email using a Brazilian free account - BOL
1399. VBA Tips - Envie emails através do Yahoo - Send Email using Yahoo Account
1400. VBA Tips - Envie emails através do Hotmail e MSN Live - Send Email using Hotmail, MSN Live
1401. VBA Tips - Envie emails através do GMail - Send Email using Gmail Account
1402. Outlook VBA - Print attached documents1403. Infographics - AIRBUS A380
1404. VBA Powerpoint - Liste os Títulos e as Notas dos seus Slides - How to get a list of the slide titles and notes text in PowerPoint?
1405. VBA Excel - Make spreadsheets read-only - How to Make a File ReadOnly using Excel VBA
1406. VBA PowerPoint - How to save presentations as PDF - How to Save PowerPoint Presentation as PDF using VBA1407. VBA Access - Exporting data to a tab-delimited text file
1408. English Tips - Business English - Business English Terms - Speaking the Linguistics
1409. VBA PowerPoint 2010 - Working with Shape Glow and Reflection Properties
1410. VBA Excel - Form - Preventing closing at [X]
1411. VBA Outlook 2010 - How to create automation functionality - How to Enable the Developer Tab and Use VBA and Macros
1412. VBA Project 2010 - Habilitar a aba Desenvolvedor no Project 2010 - Enable Developer Tab in Project
1413. Being a programmer...A brief reflection
1414. VBA Word - Adicione uma imagem ao Word - Add an Image to Word Document and Scale it using VBA
1415. VBA Excel - VLookAllBooks - Search across multiple worksheets simultaneously.
1416. VBA Excel - Google Translate Automation - Google Translate by Internet Explorer Automation
1417. VBA Excel - Extraindo dados do MySQL - Extract, Get Data from MySQL PHP
1418. VBA Basic - Checks if the file or path exists.
1419. 2012 LIST OF GLOBAL TOP 10 BIOTECH AND PHARMACEUTICAL COMPANIES BASED ON REVENUE
1420. 2012 - Profits as % of - Top 12 Annual ranking of America's largest corporations
1421. You have the right to your company's information.
1422. MIS - Leveraging excellence in the analysis of your information.
1423. Data or Information?1424. Dashboards - 8 Important Desirable Features.
1425. 2013 Started - Let's be developing fishermen.
1426. VBA Excel - Introduction to VBA in Excel
1427. End of the 2012 Commercial Year
1428. VBA Excel - Creating an Index of all Tabs - Create an Index Page
1429. VBA Excel Basic - Copying a Range from Worksheet to Worksheet - Copy a range in an Excel sheet using VBA
1430. Infographics - Various examples of charts - Charting Examples
1431. Infographics - John Deere - A Chronological History of John Deere
1432. Infographics - Dashboard - 2013 Ford Fusion
1433. Infographics - Comparison between First Class and Economy Class
1434. Infographics - A necessary interpretation of information
1435. VBA Excel - Inserting an animated logo - Animating Your Company's Logo in Excel
1436. VBA Excel 2013 - What's new for Excel 2013 developers
1437. VBA Access - Clear all spaces from text fields - Trim all text fields in an MS Access database
1438. VBA Tips - Removing special characters from a word - Remove and replace special characters
1439. VBA Tips - Renaming files randomly in a folder - Renaming files randomly in a folder using VBA
1440. VBA Tips - Renaming ALL files in a folder
1441. VBA Excel | Usando a API do Google Maps
1442. VBA Excel - Update all Pivot Tables - Refresh all Pivot Tables on Open
1443. Tips - Office 2010 - 6 Migration Guides - Office 2010 migration guides
1444. Tips - Office 2010 - Quick Reference Card - QRC - Michigan State University - ANR Technology Services
1445. Tips - Microsoft Project 2010 - Quick Reference Card Pack - QRC
1446. Tips - Excel 2010 - Quick Reference Card - QRC
1447. Tips - PowerPoint 2010 - Quick Reference Card - QRC
1448. Tips - Office 2010 - Quick Reference Card - QRC
1449. Excel VBA - AutoFilter - Showing all records - AutoFilter VBA
1450. Excel VBA - AutoFilter - Showing all records in a protected worksheet - AutoFilter VBA
1451. Excel VBA - AutoFilter - Showing all Filter Records in a password-protected worksheet - AutoFilter VBA
1452. Excel VBA - AutoFiltro - Ligue o AutoFiltro do MS Excel - AutoFilter VBA
1453. Excel VBA - Turning Off AutoFilter in MS Excel - AutoFilter VBA
1454. Excel VBA - AutoFilter - Counting AutoFilters in MS Excel - AutoFilter VBA
1455. Excel VBA - AutoFilter - Hiding AutoFilter Buttons - AutoFilter VBA1456. Excel VBA - AutoFilter - Copying Filtered Rows - AutoFilter VBA
1457. Excel VBA - AutoFilter - Applying to a Protected Worksheet - AutoFilter VBA
1458. Excel VBA - AutoFilter - Counting Visible Rows - AutoFilter VBA
1459. Excel VBA - Copy any object as an image and export it.
1460. VBA Excel - Manipulating rows and columns
1461. VBA Tips - MS Access Codes and Examples
1462. The 10 Commandments of Project Management
1463. VBA Outlook - Creating a spreadsheet from Outlook - Create Excel Workbook From Outlook
1464. VBA Outlook 2010 - Viewing Exchange Server Properties
1465. VBA Outlook - Get information from a linked contact
1466. VBA Outlook - Return a Single Name
1467. VBA Advanced - Extend VBA code with VSTO, LINQ, WPF, WCF, and .NET
1468. VBA Excel - Using Loops - Loop Through Controls on a UserForm. Textbox, ComboBox, CheckBox, etc.
1469. VBA Tips - Using Collection to Manage Groups of Objects and Collections
1470. VBA Tips - Use Better Message Boxes with Additional Buttons and Icons - Enhance Message Boxes with Additional Buttons and Icons
1471. VBA Tips - Using InputBox as an input box - Use the InputBox Function to Work with User Input
1472. VBA Excel - Informative Status Bar - Info Status Bar
1473. VBA Excel - Delete blank rows immediately upon opening the spreadsheet - Removing Blank Rows Automatically
1474. VBA Tips - Concatenating the first letter of each word - UDF to concatenate the first letter of each word in a cell
1475. 100,000 VISITS - ONE HUNDRED THOUSAND VISITS
1476. VBA Excel - 00.10 - Referencing Worksheets - Workbooks
1477. VBA Tips - Access to a HUGE list of Dashboards and Infographics
1478. VBA Excel - 01.10 - Referencing a worksheet - Active - Active Workbook
1479. VBA Excel - 02.10 - Referencing a worksheet - Currently - Workbook executing code
1480. VBA Excel - 03.10 - Referencing a worksheet - Collection - Referencing the Workbook collection
1481. VBA Excel - 04.10 - Referencing a worksheet - Explicit - Explicit reference to a workbook
1482. VBA Excel - 05.10 - Referencing a worksheet - Index - Referencing by index1483. Tips - 13 Tips for Public Speaking
1484. Excel Basic - Enabling Macros in Excel - Enabling Macros in Excel
1485. VBA Excel Basic - Opening a webpage
1486. VBA Access - função DLookup - DLookup Function
1487. Tips - O Melhor do Business Intelligence - The Best of Business Intelligence
1488. Excel Tips - Translated Excel Formulas and Functions
1489. VBA Tips - All Posts from October 2012 - 10/2012
1490. VBA Advanced - Reddick VBA e Microsoft Consulting Services - Naming and Coding Conventions
1491. VBA Tips - Validating the CNPJ
1492. VBA Tips: Validating a CPF - Questions and Answers
1493. VBA Tips - Mask for CNPJ
1494. MS Access - How to load an image into a form
1495. Databases: A Short History
1496. VBA Access Basic - Locating a record - Search Records in VBA
1497. VBA Access Advanced - Usando o DDL - Data Definition Language.
1498. VBA Advanced Excel - Preventing Excel applications from becoming loaded into memory.
1499. VBA Word - Exemplo com o Early Binding - An Example of Early Binding
1500. VBA Advanced Excel - Usando o Late Bound - Using the CreateObject Function to Create a Late-Bound Instance of Excel
1501. VBA Access Basic - Usando o OLEDB para conectar arquivos MDB - Use OLEDB to connect with mdb file
1502. VBA Access Basic - Abrindo um banco de dados no modo READ ONLY - Opening a Database in Read-Only Mode
1503. VBA Access Basic - Connecting to a Database via URL - Connect to database through URL
1504. VBA Access Basic - Conectando um Servidor SQL Server sem o DSN - Connecting to an SQL Server Using a DSN-less Connection
1505. VBA Access Basic - Connecting to a Database with Username and Password
1506. VBA Access Basic - Opening a Database Secured at the User Level
1507. VBA Access Basic - Opening a Database in Read/Write Mode
1508. VBA Access - Opening a Password-Protected Database
1509. VBA Access Basic - Connecting to an SQL Server Database
1510. VBA Excel - Adding a Custom Icon to Excel - Change Excel Icon
1511. VBA Advanced - Compreendendo o Early Binding e o Late Binding - Early Binding & Late Binding
1512. VBA Advanced - Code Refactoring - Code Refactoring
1513. VBA Excel Basics - Professional Mode for Opening and Closing MS Excel
1514. VBA Excel Basics - Blocking the user
1515. VBA Excel Basics - How to exit MS Excel without saving any tabs
1516. VBA Excel Basics - Saving all open Workbooks before closing MS Excel without warning the user.
1517. VBA Excel - Performance, diving deep into VBA - VBA Performance
1518. VBA Tips - Determine the active connection type - Determine Network Connection Type
1519. VBA Excel - Functions that return the file path and name - Formula to Return the Full File Path & Name of Excel Workbooks
1520. VBA Excel - Listing all formulas in a workbook - List All Formulas in Workbook
1521. VBA Excel - Recording change history in the spreadsheet - Log in Sheet
1522. VBA Access - Accessing External Data: - Connecting to an external table - Accessing external data: Link to external table
1523. VBA Access - Accessing External Data: Accessing snapshot tables in queries from external databases - Accessing external data: Import a table snapshot from an external query
1524. VBA Access - Documenting all objects - Loop Through All Objects
1525. VBA Excel - Retrieving information about points on a chart using PointClass - Retrieve information about chart points using Excel.PointClass1526. VBA Excel - Displays the top 10% of a range - Display Top Ten Percent in Ranges Programmatically
1527. VBA Excel - Export spreadsheets to PDF or XPS - Export data to PDF or XPS using the Excel.ExportAsFixedFormat method
1528. VBA Powerpoint - Adicione um Shape ao Slide e o formate - Add and Format Shapes Using PPT.ColorFormat.Brightness1529. VBA - Removing accents from spreadsheets, text files, presentations, databases, etc...
1530. VBA Lotus Notes - Inserting File - Insert Attach File
1531. VBA Tips - Returning Milliseconds.
1532. VBA Excel - Closing MS Excel - Close MS Excel
1533. VBA Excel - Counting selected cells.
1534. VBA Excel - Closing the spreadsheet - Close workbook MS Excel
1535. VBA Excel - Listing all existing worksheets in the spreadsheet.
1536. VBA Excel - Use the 'Saved' property to determine if the workbook has been modified.
1537. VBA Excel - Changing the default icon of a worksheet.
1538. Excel VBA - Refresh Pivot Tables
1539. Excel VBA - Connections: The season is open - VBA to link CSV File, TXT File
1540. VBA Excel - Defining the Chart Type - Change Chart Type.
1541. VBA Excel - Inserting an icon into your applications
1542. VBA Tips - Detecting the Location by ZIP Code Range
1543. CRM - Customer Relationship Management
1544. VBA Access - Sample Forms and Reports - Sample Microsoft Access Forms and Reports
1545. VBA Access - Formatting Dates Correctly for SQL - Wrong Date Formatting in SQL's Code
1546. VBA Access - Using the Windows(R) Color System in your applications.
1547. VBA Excel - Criando um Deck do Powerpoint no MS Excel - Creating a PowePoint Deck in Excel
1548. VBA Tips - Validating Email Addresses
1549. VBA Excel - List the names of all the tabs in your spreadsheet - List workbook defined names
1550. Excel VBA - Renaming the first Excel tab - Rename Worksheet
1551. Excel Macro - Removing Hyperlinks - Remove Hyperlinks
1552. Excel Macro - Filtering only one column - Selective Autofilter
1553. Excel Macro - Deleting Blank Rows - Delete Empty Rows
1554. Excel Tips - Make your spreadsheets calculate faster - Make MS Excel calculate faster
1555. VBA Excel - Ordena worksheets da planilha - Sort All Sheets in a Workbook
1556. VBA Excel - Loop por todas as worksheets
1557. VBA Access - Handling saved imports
1558. VBA Access - Data Type Comparison.
1559. VBA Access - Deleting connected data sources.
1560. VBA Access - Documenting application objects
1561. VBA Access - Sorting the properties of a RecordSet.
1562. VBA Outlook - Send all your messages via email as Bcc automatically.
1563. VBA Outlook - Obtaining the SMTP address of a public Exchange folder
1564. VBA Outlook - Sending reminders by email.
1565. VBA Excel - Automating recurring appointments - Automate recurring appointments on MS Outlook
1566. VBA Excel - Converting Excel spreadsheet to text file - Convert Excel to Text file
1567. VBA Excel - Juntando distintas planilhas - Combine worksheets in Excel and Kill all excel objects
1568. VBA Excel - Exporting Charts, Tables, and Creating Dashboards1569. VBA - Brazil, The maturing of our legacy - Brazil, VBA Development reflections
1570. VBA Excel - Dialog Box
1571. VBA Excel - Deleting Rows, Blank Rows, and Duplicate Rows - Delete Rows, Blank Rows, Delete Row on Cell, and Delete Duplicate Rows
1572. VBA Excel - Detecting the last cell in the worksheet
1573. VBA Access - Compressing and Uncompressing Files - Zip and Unzip Files1574. VBA Tips - Compatibility between 32-bit (x86) and 64-bit (x64) APIs in VBA
1575. VBA Excel - DashMap Analyse Brasil - Dashboard Brazil analyze
1576. VBA ACCESS - Using Gauges in Dashboards - Using a Graphical Dashboard in Access
1577. VBA Excel - Documenting Applications
1578. VBA Outlook - Obtaining the SMTP address of a public Exchange folder
1579. VBA Access - Deleting connected data sources
1580. VBA Access - Documenting application objects
1581. VBA Tips - Returning Milliseconds
1582. VBA Access - Posts that stood out the most from the last 100 published articles
1583. VBA Tips - VBA Development Interface - VBE Visual Basic Editor
1584. VBA Tips - Send Faxes through your VBA applications - Add Fax functionality to your VBA programs
1585. VBA Excel - Delete Empty Rows1586. VBA Excel - Protect yourself from copying and pasting content into your spreadsheets - To prevent people from cutting, copying, and pasting when your workbook is open.
1587. VBA Excel - Locate cells containing formulas with literal values - To locate cells containing formulas with literal values
1588. VBA Tips - 9 Tips to Reduce Errors During Development - Nine tips for writing better VBA code
1589. VBA Excel - Manage Ctrl+Break Usage During Code Execution - Prevent users from pressing CTRL Break in your VBA code during execution.1590. VBA Excel - Customizing the cell lock message in Excel - Is it possible to change the default Protected Sheet Msg?
1591. VBA Tips - InputBox
1592. VBA Tips - Indenting VBA Code - Smart Indenter
1593.04 - EXPAND YOUR SENSE OF BELONGING - BE SOCIABLE
1594. VBA Tips - Inserting automatic line breaks
1595. VBA Excel - Page breaks in grouping
1596. Shark Tip - VBA Tips - Counting the number of times an expression appears - Count String Occurrence
1597. VBA Access - Inserting gradient colors into forms - Excel form Back Color Gradient
1598. VBA Tips - Delay1599. Look at item 57.
1600. Office 2013 - Microsoft presents a new generation of Office for use on both PCs and tablets.
1601.57 - INSERT IMAGES IN SPONSORED LINKS IN ADWORDS
1602. TIPS - Large Databases - Volumetrics - Largest Database
1603. Dashboards - 8 Important Features1604. VBA Tips - Tabela ASCII - American Standard Code for Information Interchange, EBCDIC, UNICODE
1605. VBA Outlook - How to create an Outlook VBA code
1606. VBA Access - MS DOS Commands in VBA - Microsoft DOS Commands in VBA 🔥Updated on January 7, 2025
1607. VBA Access - Writing VBA Code with VBA
1608. VBA Tips - How to Capture and Print a Screen, Form, or Any Window
1609. VBA Word - Capturando a tela - Screen Capture
1610. VBA Excel - Moving to Cell - Move to Cell
1611. VBA Word - Inserting header and footer into the document - Word Footer and Header Code
1612.01 - SHARING USEFUL REFERENCES - CREATING LITTLE TIPS - 50-ORIGINAL TIPS
1613.02 - Signature in Emails, Articles and Comments - 50-Something Tips
1614.03 - COMMENT ON EVERYTHING, DON'T BE SHY - COMMENT ON ALL ARTICLES, NOT SHY - 50-Something TIPS
1615. 50-Something Tips to Promote Your Website or Blog - Online and Offline
1616. Tips - 7 Desirable Characteristics for KPIs - Key Performance Indicators
1617. VBA Excel - Removing Various Properties
1618. Tips - Acrônimos - Technology, Electronics & Video Game Acronyms
1619. KPI - Key Performance Indicator
1620. VBA Excel - Deleting all procedures from the worksheet - Delete all macros in a workbook
1621. VBA Excel - Deleting a procedure from a module - Delete a procedure from a module
1622. VBA Excel - Deleting a module - Delete a module using VBA in Microsoft Excel
1623. VBA Excel - Copying modules between workbooks - Copy modules from one workbook to another
1624. VBA Excel - Adding content to a module from a file - Add content to a module from a file using VBA in Microsoft Excel
1625. VBA Excel - Adding a Procedure to a Module - Add a procedure to a module using
1626. VBA Excel - Creating a new module automatically - Create a new module
1627. VBA Access - Exporting data to a text file with delimiters
1628. VBA Tips - Filling with SPACES or ZEROS - Right or Left1629. VBA Tips - How to Encrypt Part of VBA Code - Part 1 - Mini Version
1630. VBA Excel - Deleting Tabs with No Content - Delete/Remove Blank/Empty Worksheets
1631. VBA Excel - Ordenando Alfabeticamente as Abas - Sort all worksheets on the basis of Sheet names
1632. VBA Excel - Extraindo Dígitos - Extract Digits (Remove Alphabets) from Selected Range
1633. VBA Excel - Extracting Alphabetic Characters - Extract Alphabets (Remove Digits) from Selected Range
1634. VBA Excel - Coloring an entire row based on a parameter in a column - Color Entirerow based on a column's value
1635. Searched Profile
1636. VBA Access - Como realmente desabilitar o Menu do MS Access 2007 - How To Really Hide Access 2007 Ribbons With VBA
1637. VBA Tips - Capturing Images from a USB Camera - Capture USB Webcam Images on an Access form with a command button click
1638. VBA Tips - Downloading a File - Downloading a File From the Web
1639. VBA Tips - Deleting a VBA Module - Delete Module After Running VBA Code
1640. VBA Word - Compare the footer and header of two documents - Compare Word Documents with Headers and Footers using VBA
1641. VBA Excel - How to convert cell text into comments - How to convert Excel Text to Comments using VBA
1642. VBA Excel - How to split the content of a cell into multiple cells - How to Split Text in a Cell to Multiple Cells using Excel VBA
1643. VBA Excel - How to save a spreadsheet as read-only - How to Make a File ReadOnly using Excel VBA
1644. VBA Excel - Desinstalando Addins do MS Excel - Excel VBA uninstall Excel Addins
1645. VBA PowerPoint - Standardize all links in your presentation. MS PowerPoint - Make links and action settings visible.
1646. VBA PowerPoint - Divide a large presentation into smaller sets - Break a presentation up into several smaller presentations
1647. VBA PowerPoint - Exporting Slide Titles and their respective Page Numbers - Export Slide Number and Title Text to a text file
1648. VBA PowerPoint - Exporting the text of an MS PowerPoint presentation to a CSV/Excel file
1649. VBA Powerpoint - Exportando as Notas de texto do MS Powerpoint - Export the notes text of a PowerPoint presentation
1650. VBA Word - How to create a PDF document from MS Word - How to Create PDF from Word Document using VBA
1651. VBA PowerPoint - How to Save an MS PowerPoint Presentation as a PDF - How to Save a PowerPoint Presentation as a PDF using VBA
1652. VBA Excel - Find the word and highlight the row - Highlighting a row
1653. VBA Excel - Connecting remotely via IP1654. VBA Excel - Changing Chart Types - ChartType Property
1655. VBA Outlook - Search all emails in Outlook and extract information - Browse through all emails in subfolders of a specific folder in Outlook and extract the information.1656. VBA Excel - Finding the RGB value of a cell - Find RGB Value of a color
1657. VBA Excel - Find the first cell after a frozen area - Find The First Cell After Freeze Panel
1658. VBA Excel - Navigate through all the worksheets and press Ctrl + Home. Go to the first cell in each worksheet.
1659. VBA Excel - Merge the contents of multiple worksheets into a single worksheet - Merge data from all sheets from multiple workbooks and paste them into a single worksheet.
1660. VBA Excel - Getting all the names of the subfolders in a directory - Get Names of all the folders stored in a folder/directory Including Subfolders
1661. VBA Tips - Sample Code to Determine CD-ROM Drive Letter
1662. VBA Tips - Deleting a Module After Running Code in It - Delete Module After Running VBA Code
1663. VBA Tips - Example code to retrieve the current username
1664. VBA Excel - Copying a Table or List to a New Worksheet in the Current Workbook
1665. VBA Excel - Checking if the cell is part of a Table or List - Checking to See Whether the Active Cell is in a Table or List
1666. VBA Excel - Storing the values of a Range in an Array - Total Rows and Columns in an Array
1667. VBA Excel - Count cells that contain formulas, text, or numbers.
1668. VBA Excel - Export selected areas delimited by commas - Export a Text File with Comma and Quote Delimiters
1669. VBA Excel - Fix Badly Imported Formulas
1670. Access VBA - How to copy the screen or window to the clipboard from Visual Basic - How To Capture and Print the Screen, a Form, or Any Window
1671. VBA Outlook - How to send an email with a dynamic signature - How to send an email with an automatic signature
1672. LinkedIn - The professional profile that companies are looking for in the market.1673. VBA Access - How to open or close the navigation pane
1674. VBA Excel - Loading an Array with a Recordset
1675. MS Office 15 will support the ODF 1.2 open document standard.
1676. VBA Excel - Inserting the slash character when formatting dates
1677. VBA Access - Creating a query with page number - Creating an MS Access query with page number
1678. VBA Access - Returning the number of records - Generic function to return the number of records
1679. VBA Access - Creating temporary tables in MS Access DB
1680. SQL Access - Selecting specified records within a period - Select a specified number of rows older than the specified datetime.
1681. VBA Excel - Memory functions are unavailable in MS Excel 2007.1682. VBA Tips - Early Binding Vs Late Binding
1683. VBA Tips - Referencing the GUID - Globally Universal Identifier
1684. VBA Access - Techniques for writing subqueries - Access Subquery Techniques
1685. 40 Posts in April!1686. Excel - 25 years, how MS Excel changed the world - How Microsoft Excel Changed The World
1687. Books - Macros and VBA for Microsoft Excel1688. VBA Excel - Periodic Code Execution
1689. VBA Excel - What is VBA? How should it be used? - Defining VBA and Its Uses
1690. Tips - Various Data Visualization Sources - Dashboards and Infocharts - Data Visualization Resources1691. VBA Excel - VBA Programming Functions - VBA Programming Functions
1692. VBA Excel - Comando comuns no MS Excel - Common VBA Statements for Excel VBA Programming
1693. Charts - Analyze and improve. Identify the charts that need changing.
1694. Tips - Dashboards - Flynet Xcelsius Server 2010
1695. VBA Tips - 101 Code Examples in Office 2010 - 101 Samples for Office 2010 Development1696. Microsoft Office 2007 Interactive Map
1697. Office 2010 - Poster with the Developer Map - Microsoft Office 2010 Interactive Map
1698. VBA Excel - Why spreadsheets grow inexplicably
1699. VBA Access - Documenting application objects
1700. VBA Outlook - Sending reminders by email
1701. Large Databases - Volumetrics - Largest Database
1702. VBA Access - Filling a list box.
1703. VBA Tips - Over 800 errors and their descriptions - DAO Error List
1704. VBA Tips Development - Professionalizing my solutions.
1705. VBA Excel – Mask for CNPJ (Brazilian company tax ID)
1706. VBA Excel – Efficiency for deleting millions of rows
1707. VBA Excel – Formatting multiple cells
1708. VBA Access - Exporting reports to RTF, XLS, and Snapshot formats.
1709. VBA Access - Adding a title to your application.
1710. Access VBA - Computer Name (Workstation)
1711. VBA Excel - Protecting a worksheet
1712. VBA Access - Error 3052
1713. VBA ACCESS - RUN TIME ERROR 3021 - BOF OR EOF IS TRUE
1714. VBA Access - Number of lines of code in the application
1715. VBA Excel - Protecting the title of your chart
1716. VBA Excel - Removing menus
1717. VBA Excel - Your Spreadsheet can pronounce words, text, and titles - Speak method as it applies to the Speech object
1718. VBA Excel - Protect and Unprotect all Worksheets
1719. VBA Excel - Creating an In-Cell Chart Using VBA - Create an In-Cell Chart Using VBA.1720. VBA Access - Determines if a Folder or Directory Exists or Not
1721. VBA Access - Selecionando o Nó do Treeview - Select the Treeview Root Node.
1722. VBA Access - Creating Nested Directory Structures on a Network - Create Directory Structure/Create Multiple Directories/Create Nested Directories1723. VBA Access - Creating Directories and Folders - Directory/Folder Name Validation.
1724. Colors Tips - Combining Colors
1725. VBA Excel - Making everything uppercase, lowercase, first letter uppercase - Macro
1726. VBA Access - Documentando queries no MS Excel - Documenting Access Queries in MS Excel
1727. VBA Access - Animating the form title and taskbar icon - Animate String
1728. Dashboard - Ford Fusion 2013.
1729. Excel Tips - Shortcut Keys.
1730. VBA Outlook - Anexando arquivo ao email - Attaching files to MS Outlook email item using VBA
1731. VBA Excel - Closing a spreadsheet with a Timer - Close an Excel workbook using a timer
1732. Word VBA - How to add a serial number to an MS Word document - Adding a serial number to a Word document
1733. VBA Outlook - Importing holidays into Outlook from a list in MS Excel - Importing Outlook's holiday list into a function in MS Excel1734. VBA Tips - Retirando acento - Remove and replace accent characters from a string.
1735. VBA Access - Adding a field to a pre-existing table - VBA Access: How to Add Fields to Existing Tables for BI and Data Automation
1736. VBA Excel - Delete Rows Without the Specified Word
1737. VBA Excel - Delete rows with a specific word - Delete Row With Specific Word
1738. VBA Tips - Check if an application is responding - Test if an application is responding and terminate the application.
1739. VBA Tips - Evaluates an email address - Validating an Email Address1740. VBA Tips - How to Make Gradients
1741. VBA Tips - Manipulating Files - All File Operations.
1742. VBA Tips - Encrypting and Decrypting - Encode and Decode ASCII
1743. VBA Tips - Computer Name
1744. VBA Tips - Disabling [CTRL] + [ALT] + [DEL]
1745. VBA Tips - Create a Keyboard Hot Key to Start Excel or Access
1746. VBA Advanced - Adding references dynamically in VBA.
1747. VBA Access - Building queries "on the fly"
1748. Office Tips - Create charts in Excel
1749. Office Tips - Smart Art - Create a SmartArt graphic
1750. VBA Excel - Reducing the size of your spreadsheets - SHRINK REDUCE EXCEL FILE SIZE
1751. VBA Excel - Making startup faster - Speed up Excel Startup (FASTER EXCEL)
1752. VBA Access - DAO Programming Code Examples
1753. VBA Tips - Replacing characters in filenames in a directory - Replace Characters in the Filenames of a Directory
1754. VBA Tips - Functions
1755. VBA Access - Data collection via email messages - Office 2007
1756. VBA Tip - Accessing Text Files - Text File access - Scripting Runtime object library - Scrrun.dll
1757. VBA Excel - Creating Shortcut Keys.
1758. VBA Tips - Saving Error Messages to a Text File - Logging Errors to a Text File - Scripting Runtime object library - Scrrun.dll
1759. VBA Tips - Changing File and Folder Properties - Setting File & Folder Attributes - Scripting Runtime Object Library - Scrrun.dll
1760. VBA Tips - Returning files within a directory - Returning Files from the File System - Scripting Runtime object library - Scrrun.dll
1761. VBA Tips - Reexibindo pastas ocultas com VBA - Scripting Runtime object library - Scrrun.dll
1762. Microsoft Office 15
1763. A&A - You have the right to your company's information.1764. VBA PowerPoint - Printing Slides from a Presentation - Use CreateObject to Print Slides From A Presentation
1765. VBA PowerPoint - Useful Code Snippets
1766. VBA PowerPoint - Use VBA to read text from a file1767. VBA PowerPoint - Creating a Spirograph Programmatically with VBA - Create a Spirograph in PowerPoint Programmatically
1768. VBA PowerPoint - Shuffle Part of Your Presentation
1769. VBA Powerpoint - Mude de Slide randomicamente - Jump to a Random Slide1770. VBA PowerPoint - Resize your image to fit the entire slide - Full Slide Images
1771. VBA PowerPoint - Formatting images - Picture Format in 20071772. VBA PowerPoint - Removing bold text - Unbold
1773. VBA PowerPoint - Change all fonts in the presentation - Change Font for Whole Presentation
1774. VBA Excel - Clearing unused headers in Excel1775. VBA PowerPoint - Changing the Colors of Objects - Change My Colour
1776. VBA PowerPoint - Último Slide visto + 1 - Last Slide Viewed + 1
1777. VBA Powerpoint - Localize e substitua códigos no MS PowerPoint - Global Find And Replace routine in PowerPoint
1778. VBA Excel - Deleting rows with information.
1779. VBA Access - Exporting reports to RTF, XLS, and Snapshot formats.
1780. VBA Access - Adding a title to your application
1781. VBA Excel - Deleting Rows using a word passed as a parameter
1782. VBA Excel - Keeping up with the widespread use of spreadsheets.
1783. VBA Outlook - Como exportar as tarefas do MS Outlook para o MS Excel - How To Export Your Outlook Tasks To Excel With VBA1784. VBA Word - How to list all macros in my document.
1785. VBA Word: Checking revision count on opening
1786. VBA Outlook - Usando o VBA no Outlook - Using Visual Basic for Applications in Outlook1787. VBA Excel: Compact your spreadsheets resulting from automation.
1788. VBA Tips - How do I convert numbers to times?
1789. VBA Excel: Creating charts with VBA1790. VBA Powerpoint - Populando LISTBOX a partir do Access.
1791. VBA Excel - Inserting new worksheets into the spreadsheet
1792. VBA Tips: Remove Diacritical Accents
1793. VBA Tips - Extracting part of a text - By delimitation
1794. 30 Posts in January!1795. VBA Access - Exporting records for Paradox - VBA Code to Import Paradox Table into Access
1796. VBA Access - Format Function (with Dates)
1797. Microsoft Office Excel - 10 Usage Insights
1798. VBA Excel - How to make your spreadsheets leaner
1799. VBA Access - Network and Computer Username
1800. VBA Access - DDL/DML Code Examples
1801. VBA Access - Finding a specific record
1802. A&A - VBA Solutions
1803. VBA Excel - Manipulating Pivot Tables - Refresh Pivot Table
1804. VBA Excel - Filling empty gaps in ranges with data.1805. VBA Excel - How to select a variable-size range for copying.
1806. VBA Excel - Selecting Data in a PivotTable - Select Data in PivotTable1807. VBA Access - Gatilhos no Microsoft Access 2010 - Triggers in Microsoft Access 2010
1808. VBA - Invoking a call to the Control Panel
1809. New site CV
1810. VBA Lotus Notes Domino - Email Sending Code
1811. Word VBA - Various Functions.
1812. VBA Excel: Performing loops in a named range
1813. VBA Excel - Make all fonts and colors uniform.
1814. VBA PowerPoint: Make all fonts and colors uniform.
1815. VBA Outlook: Inserting a Signature Programmatically.1816. VBA Outlook: Forward messages sent as hidden.
1817. VBA Outlook - Sending messages without interruptions - Send email without security warnings1818. VBA Excel: Inserting new worksheets into the workbook.
1819. VBA Excel - Shows all fonts available for MS Excel - Display all installed fonts
1820. VBA Excel - Deleting all macros from a worksheet - Delete all macros in a workbook/document
1821. VBA Excel - Delete a specific procedure within a module - Delete a procedure from a module using VBA
1822. VBA Excel - Deleting a module using VBA - Delete a module using VBA
1823. MS Access – VBA - Retrieving values from a Stored Procedure.
1824. VBA Excel - Opening and closing the CD-ROM tray - Open and close the CD-ROM tray using VBA in Microsoft Excel
1825. VBA Tip - How to use RAM - Using Clipboard, RAM Memory
1826. VBA TIP: Books 2011
1827. EXCEL TIP - Increasing the startup speed of your MS Excel - Speed up Excel Startup (FASTER EXCEL)
1828. Excel TIP - Making your spreadsheets smaller - SHRINK REDUCE EXCEL FILE SIZE
1829. VBA Excel - Copying the content of one module to another Workbook - Copy modules from one workbook to another1830. VBA Excel - Log Files
1831. VBA Excel - Coloring the background of cells in a range alternately - Row and column background color
1832. VBA Excel - Deleting worksheets without confirmation prompts - Delete sheets without confirmation prompts
1833. VBA Excel - Deleting Columns or Rows in a Range - Delete Columns or Rows in the range
1834. VBA Excel - Deleting Empty Columns in a Range - Delete selected columns in the range
1835. VBA Excel - Deleting empty rows in a range - Delete selected rows in the range
1836. VBA Excel - Deleting blank rows when opening the spreadsheet - Removing Blank Rows Automatically
1837. Excel Tips - How to compress XLSX files to even smaller sizes - How to Compress XLSX Files to the Smallest Possible Size1838. VBA Excel - Interactions with APIs - UserForms With Windows API Functions
1839. VBA Excel - Array - Loading the contents of a cell into a vector.
1840. VBA ACCESS - Campo Auto Numérico - Creating an AutoNumber field from code - VBA, DAO, DDL e SQL
1841. VBA Excel - Progress Bar in the Status Bar - Show a Progress Meter in the Status Bar
1842. VBA Excel - Informative Status Bar - Info Status Bar
1843. SEND ME YOUR SPREADSHEET - AND I'LL MAKE YOUR Pivot Table - November 2011 Promotion
1844. November 2011 Promotion - Pivot Table.
1845. VBA Access - Exporting a query or table to a text file with tabulation.1846. VBA Excel: Sending emails from Excel
1847. A&A - Data or Information?1848. DEFINITION - Dashboard & Scorecard
1849. VBA - Format Function and Examples1850. VBA Excel - Printing selected or unselected worksheets.
1851. VBA Excel - Inserting page breaks according to grouping1852. VBA ACCESS - ShowToolbar - Inibindo o Menu - Switch off / Hide Toolbars & Menu Bar
1853. VBA - Converting the month number to its written name - Converting the month's written name to the number1854. VBA Access - How to delete files - Delete, Kill, Erase
1855. ACCESS - Using Gauges in Dashboards - Using a Graphical Dashboard in Access
1856. EXCEL - Tip to optimize calculation speed in Excel 20071857. VBA - Deleting files - Deleting folders - Deleting directories - Delete via VBA
1858. VBA Excel - Other ways to print selected or unselected worksheets.
1859. VBA Excel - Printing multiple worksheets simultaneously1860. VBA - Returning Milliseconds.
1861. VBA Excel - Defining the Chart Type - Change Chart Type.1862. VBA Access - Using the Windows(R) Color System in your applications.
1863. VBA Access - Handling saved imports
1864. Excel VBA - Connections: The season is open - VBA to link CSV File, TXT File
1865. VBA Excel - Changing the default icon of a worksheet.
1866. VBA Excel - Dashboard Brazil analyze - DashMap Análise Brasil
1867. VBA Excel - Manipulating rows and columns1868. VBA 2011
1869. VBA Excel - Dialog Box
1870. Excel VBA - Copy any object as an image and export it - Excel VBA: Copy any object as an image and export it for BI and data visualization.1871. Predict: VBA Excel - Self-Documenting Your Applications
1872. VBA Excel - Inserting an icon into your applications
1873. VBA - Removing accents from spreadsheets, text files, presentations, databases, etc...
1874. VBA Access - Deleting connected data sources.1875. VBA Outlook 2003 - Send all your messages via email as Bcc automatically.
1876. VBA Outlook - Obtaining the SMTP address of a public Exchange folder
1877. VBA Outlook - Sending reminders by email.
1878. VBA Access - Documenting application objects1879. VBA Excel - Ordena worksheets da planilha - Sort All Sheets in a Workbook
1880. VBA Excel - Loop por todas as worksheets
1881. VBA Excel - Use the 'Saved' property to determine if the workbook has been modified.
1882. VBA Excel - Counting selected cells.
1883. VBA Excel - Closing MS Excel - Close MS Excel
1884. VBA Excel - Closing the spreadsheet - Close workbook MS Excel1885. VBA Excel - Listing all existing worksheets in the spreadsheet.
1886. VBA Access - Sorting the properties of a RecordSet.
1887. VBA Access - Query Properties - SourceConnectStr and SourceDatabase Properties
1888. VBA Access - Query Properties - Property Description1889. VBA Access - Data Type Comparison.
1890. Excel VBA: Refresh Pivot Tables - Updating Pivot Tables
1891. KPI - Using Excel Services with other Business Intelligence resources1892. IRM - MS Excel Services and Information Rights Management
1893. MS Excel - MS Excel Services - Connecting to data securely
1894. Scenarios for Excel Services - MS Excel Services Office
1895. Interacting with an Excel workbook in Excel Services.
1896. Scenarios - Creating 'a version of the truth'
1897. How do Excel Services and Office Excel 2007 work together?
1898. What is Office Excel Web Access?
1899. Introduction to Excel Services and Excel Web Access.
1900. A&A: Introduction to MS Excel Services and MS Excel Web Access.
1901. VBA Excel - Adding a record in MS Access.
1902. VBA Tips - Tabela ASCII - American Standard Code for Information Interchange, EBCDIC, UNICODE
1903. VBA - Dashboard Sample1904. ODBC - What is it?
1905. VBA Excel - Date and Time Formatting - Format Date and Time in MS Excel.
1906. VBA: Function that returns age.
1907. VBA Excel - Deleting rows - 09 - Deleting duplicate rows1908. VBA Excel - How to close MS Excel worksheets or workbooks using VBA
1909. VBA Excel - Take a break from your application.
1910. Excel - 4 Ways to Increase Calculation Speed in Your Spreadsheets.
1911. Utilize excellence in analytical tools!1912. VBA: Get the file size in Kilobytes
1913. Access 2007 Quick Reference Card - Download
1914. Access 2007 Quick Reference Card
1915. Office 2007 Quick Reference Card
1916. PowerPoint 2007 Quick Reference Card
1917. OneNote 2007 Quick Reference Card
1918. Excel 2007 Quick Reference Card
1919. InfoPath 2007 Quick Reference Card
1920. Publisher 2007 Quick Reference Card
1921. Word 2007 Quick Reference Card - Download
1922. Word 2007 Quick Reference Card
1923. Outlook 2007 Quick Reference Card
1924. SharePoint 2007 Quick Reference Card
1925. Developer Map for the 2007 Microsoft Office System
1926. Microsoft Office Info Path 2007 Managed Object Model
1927. Developer's Roadmap for MOS (Microsoft Office System) 2007
1928. VBA - Functions for handling names
1929. VBA Access - Programming PivotTable and PivotChart Views in MS Access - Dynamic Tables and Charts - 01.
1930. Programming PivotTable and PivotChart Views in MS Access - Pivot Tables and Charts.
1931. A&A: Feedback - Hiding MS Excel - Question.
1932. BOOKS - List of suggestions to enrich your knowledge of VBA.
1933. VBA Access - Lendo E-mails do Outlook do Access
1934. A&A: Use your data liberally!1935. VBA - Make your code sleep - Pausing it...
1936. VBA Excel - Exporting data from MS Excel to MS Access (DAO).
1937. VBA Tips - Over 800 errors and their descriptions - DAO Error List1938. VBA Access - VBA Office System Constants
1939. VBA - www.visualstudio2010.learn.net.in
1940. VBA Excel - Inserting data directly into spreadsheets.
1941. Visual Basic for Applications (VBA) - A linguagem do MS Office
1942. VBA: Deleting files - 03
1943. VBA: Deleting files 02
1944. VBA: Deleting files - 01.
1945. Password - Password
1946. VBA Excel - Function that removes accents
1947. VBA Word - Code Examples - T to Z - In alphabetical order.
1948. VBA Word - Code Examples - D to K - In alphabetical order.
1949. VBA Word - Code Examples - C - In alphabetical order.
1950. VBA Word - Code Examples - B - In alphabetical order.
1951. VBA Word - Code Examples - A - In alphabetical order.1952. PowerPoint: Creating and Reducing Presentations.
1953. Micrososft Office 2010.
1954. VBA Error 3275 - Unexpected error from external database driver
1955. Take control of your company's INFORMATION!
1956. Review - MS Excel 2010 X MS Excel 2007.1957. VBA Access - Creating a spreadsheet (MS Excel with a chart) from an MS Access application.
1958. VBA Access - Removing fields programmatically
1959. VBA Access - Function to check if a file exists.
1960. VBA Excel - Working with multiple Worksheets - 02
1961. VBA Excel - Working with multiple Worksheets1962. Access VBA - API: Changing the ForeColor and Bold properties on a selected node in a Treeview
1963. VBA - Returning to the current version of any Office application.
1964. VBA Excel - Referencing Worksheet 10 - Worksheet code's name property.
1965. VBA Excel - Referencing worksheet 09 of 10 - By index
1966. VBA Excel - Referencing worksheet 08 of 10 - Explicit reference to the worksheet
1967. VBA Excel - Referencing Worksheet 07 of 10 - Referencing the Worksheet object
1968. VBA Access - Function to transpose the table.
1969. VBA Access - Changing the connection to version 2007
1970. VBA - Capitalize the first letter of all words.
1971. VBA Access/Excel - Link from Excel to Access - Solving #Num problems!
1972. Access VBA - Strings: Capitalize first character of every word automatically
1973. VBA Excel - Referencing Worksheet 06 of 10 - Referencing an active worksheet
1974. VBA Excel - Referencing Worksheet 04 of 10 - Explicit reference to a workbook
1975. VBA Excel - Referencing Worksheet 05 of 10 - Referencing a workbook by index
1976. VBA Excel - Referencing Worksheet 03 of 10 - Referencing workbooks in the Workbooks collection
1977. VBA Excel - Referencing Worksheet 02 of 10 - Reference the workbook that is currently running code.
1978. VBA Excel - Referencing worksheet 01 of 10 - Referencing the active workbook
1979. VBA Excel - Closing spreadsheet without saving.1980. VBA Excel - Creating new worksheets from existing workbooks within a spreadsheet.
1981. Excel Basic - Is a number even or odd?
1982. VBA Access - Converting the contents of a TextBox to Dates (Convert TextBox values to Dates)1983. VBA Access - Verificando sua Listbox (Check your listbox)
1984. Excel: How do spreadsheets inexplicably grow in size?
1985. VBA Excel - Efficiency for deleting thousands of rows (Delete thousand lines).
1986. VBA Excel - Deleting blank rows (Delete Blank Cells)1987. VBA Excel - Deleting duplicate rows in an ordered column.
1988. VBA - Samples, Examples, Tips, Tricks, Code, Download, Office, etc...
1989. VBA Excel - Disabling Menus - 2003/2007
1990. VBA Access - Find out which version of Access you have.
1991. VBA Access - Where is this FIELD used?
1992. VBA Access - MS Access Versions - up to August 3, 2009.
1993. VBA Access - File Types.
1994. VBA - Returning the username logged into the machine.
1995. A&A: Help - Assistance in defining the current path of the spreadsheet.
1996. VBA Access - Code line counter.
1997. Shark Tip - VBA Access - Run Time Error 3021 - O BOF ou EOF for VERDADEIRO - Fixing Run Time Error 3021 - BOF or EOF is True
1998. VBA Excel - Protecting a worksheet.
1999. VBA - Defining the Printer
2000. VBA Access - Erro 3052 - How to Fix Error 3052
2001. VBA Access - Adding a Title to Your Application - How to Add a Title to Your Application2002. VBA PowerPoint - Tips...
2003. VBA Word - Various tips.
2004. VBA Outlook - Various tips.
2005. VBA - Various Tips for Diverse Applications
2006. VBA Access - Índice - Creating and Using Indexes
2007. VBA Excel - Index - My posts on InfoForum
2008. VBA Access - Exportando relatórios para MS Word, MS Excel e Snapshot View - Exporting Reports to MS Word, Excel, and Snapshot View
2009. VBA Access - Distributing Access reports using email2010. VBA Word - How to list all macros in my document.
2011. VBA Excel - Deleting rows - 08 - Deleting rows with information.2012. Word VBA - Various Functions - Part 02.
2013. Word VBA - Various Functions - Part 01.
2014. Word VBA - Various Functions
2015. VBA Access - Deletando objetos - How to Delete Objects Programmatically
2016. VBA Access - Encontrando um registro...How to Find a Record Efficiently
2017. VBA Access - Nome do usuário na rede (Network User Name) - How to Get the Network User Name
2018. VBA Access - Usando o DML - Data Definition Language - Using DML (Data Definition Language) Effectively
2019. VBA Access - Registrando o nome das máquinas (Workstation) - VBA Access: How to Record Workstation Names (Machine Names)
2020. VBA Excel - Sorting emails by domain name.2021. VBA - Displaying the list of active processes on your machine using (WMI)
2022. VBA Excel - Desbloqueando as worksheets com VBA (How to hack a lost worksheet password with VBA to unprotect the worksheet)2023. VBA Excel - Prevent recalculation during code execution (Preventing Calculation).
2024. Making your code run faster by stopping screen flickering.2025. VBA Excel: Modo Calculation
2026. VBA Excel: Import data from MS Access to MS Excel (Via DAO)
2027. VBA Access - Função Format com Datas - Using the Format Function with Dates
2028. VBA Access - Exporting query data to PPT slides
2029. VBA Access - Exporting Records to Paradox Database
2030. VBA Access - Exporting Images Directly to PowerPoint Slides - VBA Access: Export Images Directly to PowerPoint Slides2031. VBA Powerpoint: Populando objetos a partir do MS Office Access.
2032. VBA Excel: Identifying the week number in the year.
2033. VBA: Printing in Dot Matrix
2034. VBA: Using the SHELL command with VBA applications
2035. VBA Excel - Creating charts with VBA2036. Direto do MSDN: Different Ways to Take Advantage of the E-mail Features of Excel
2037. VBA: Unzip to a specific folder using WinZip (VBA)2038. VBA Word: Checking the number of revisions right when opening the document.
2039. VBA Excel: Returning the period in YEARS, MONTHS, and WEEKS.
2040. VBA PowerPoint: View MS Access data in your slides.
2041. VBA PowerPoint: Mixing slides during a presentation.
2042. VBA PowerPoint: Make all fonts and colors in your presentation uniform.
2043. VBA Excel: Inserting new workbooks into the spreadsheet.
2044. VBA Outlook: Forward messages sent as hidden.
2045. VBA Excel: Send an email with your spreadsheet from Excel.
2046. VBA Outlook: Inserting a Signature Programmatically.2047. Discover the future of Web 2.0 and beyond!
2048. VBA Excel: Truly identifying the last cell in a spreadsheet.
2049. VBA Excel: Creating a calendar in one of your spreadsheet's workbooks.
2050. VBA Access - Deleting tables and queries programmatically - VBA Access: How to Programmatically Delete Tables and Queries
2051. VBA Access - Copying a query with a different name programmatically - How to Programmatically Copy a Query with a New Name2052. VBA Excel: Defining the Chart Type.
2053. VBA Excel: Performing loops on a named range
2054. VBA Excel - Chart - Redefine bubble size
2055. VBA Office: Controlling an Office application from another.
2056. MS Excel: Much more than spreadsheets.
2057. VBA Excel: Navigating between existing workbooks
2058. MS Excel - Deleting multiple blank rows - 02.2059. Excel VBA: 30 Books as a suggestion.
2060. Excel VBA: Opening dialog box
2061. VBA Excel - Connecting spreadsheets with MS Access tables.
2062. VBA Access & Excel: Loading data into a form in Excel from data available in Access.
2063. VBA Access: List of Books2064. VBA: Good definition when asking for help.
2065. Outlook: Sending Email without the security warning2066. VBA OutLook: Uso do editor do Word no outlook.
2067. VBA Outlook: Creating tasks from an email.
2068. VBA OUTLOOK: Sending Email Reminders
2069. VBA Outlook - 01 - Getting Started
2070. VBA EXCEL - Deleting duplicate rows in an ordered column
2071. Database - History - A Short History of Databases
2072. VBA Excel - Removing all references to external links from the worksheet
2073. VBA PowerPoint - Updating chart with data from MS Excel
2074. VBA PowerPoint - Adding comments to slides with coding
2075. VBA PowerPoint - Equivalent to the Application.ScreenUpdating command
2076. VBA PowerPoint - Opening a .PPS presentation
2077. VBA PowerPoint - Mixing Slide Presentations
2078. VBA PowerPoint - Changing the Slide Color
2079. VBA PowerPoint - Detecting the Last Slide
2080. VBA Word - Exporting the contents of a .DOC file to a .PPT slide.
2081. VBA Word - Remove all hyperlinks while keeping the text in the .DOC file.
2082. Excel VBA – An efficient solution for deleting thousands of rows
2083. MS Excel - Deleting rows - 07 – Duplicate rows - Delete duplicate rows
2084. MS Excel – CNPJ Mask
2085. MS Excel – Deleting rows - 05
2086. MS Excel - Deleting rows - 06
2087. MS Excel - Formatting Multiple Cells
2088. MS Access - How to load an image into a form
2089. MS ACCESS - Images in Forms – Picture in Forms2090. MS Excel – Creating a Menu with VBA
2091. MS Excel – XlChartType – Chart Types
2092. Excel VBA – Retornando nome da Planilha (Return Name of Excel Workbooks or Return the Full File Path)2093. MS ACCESS – Compacting the application on exit
2094. MS Excel – Formulários Transparentes (Transparent (See through) userforms in Excel)2095. MS Excel - How do I refresh all pivot tables in my spreadsheet using VBA?
2096. MS Excel – Various Useful Functions.2097. MS Excel – Navigating between workbooks in spreadsheets
2098. MS Excel – Sorting pasta alphabetically2099. MS Access – Exec Proc in SYBASE
2100. MS Access – Exec Proc in ORACLE
2101. MS Excel - Populando Combobox - Multi-Column
2102. MS Access - Unlinking Tables
2103. MS Access / MS Excel – Error: Numeric Field Overflow - when querying a linked spreadsheet
2104. VBA Access - Execute Stored Procedure with VBA in Sybase - Execute Stored Procedure in Sybase with VBA Access: A Developer's Guide
2105. VBA Tips - Application Access Log2106. MS Excel - Changing the Spreadsheet Icon.
2107. VBA: 8 Tips to Reduce Errors During Development
2108. Google Chrome
2109. Searching for information in an MS Access database and pasting it into an MS Excel spreadsheet.
2110. Checking the Status Bar in MS Access
2111. Creating Excel Spreadsheets Using Other Environments
2112. Profile - André Luiz Bernardes
Click on the image above to access 10 e-books!
PUDIM PROJECT
Yes, we know, we know, we know…
Seeing this message is annoying. We know that. (Imagine what it's like to write it...). But it's also extremely important. One of the greatest strengths of ✔ Programação GLOBAL® is its model, which is partially funded by readers.
1. Reader funding means we can cover whatever we want. Not subject to the whims of a billionaire owner. No one can tell us what not to say or what not to report.
2. Reader funding means we don't need to chase clicks and traffic. We don't desperately seek your attention for its own sake: we seek out stories that our editorial team considers important and worthy of your time.
3. Reader funding means we can keep our blog open, allowing as many people as possible to read quality articles from around the world.
The support of readers like you makes all of this possible. Currently, only 2.4% of our regular readers help fund our work. If you want to help protect our editorial independence, consider joining us today.
We appreciate any amount you can give us, but monthly support makes the biggest impact, allowing for greater investment in our most crucial and fearless work, so we hope you will consider supporting us. Thank you!
👉 Follow André Bernardes on LinkedIn . Click here to contact me via WhatsApp.























Nenhum comentário:
Postar um comentário