VIDEO: How to Fire Your Customers to Make More Money.

In this webinar, Experts Exchange tech pro and IT consultant DrDamnit (author of EE's All-Time Most Helpful Article Warning: 5 Reasons Why You Should Never Fix a Computer For Free) pulls back the curtain on his very successful businesses and answers questions every IT consultant and business owner should know about. 

DrDamnit shares secrets on what he did to solve the 5 most common problems in IT:

  • Creating predictable cash flow by debugging how you get paid
  • Turning your users and customers into people who idolize and respect you
  • Finding and keeping good, reliable people who love your business instead of finding excuses not to do work
  • How to create "Income on Demand" for your business
  • Time Control best practices that really work

Webinar Video Viewing Requirements

About the Presenter: In 2004, with no money and no job, DrDamnit started a business with his hopes pinned on just one client. Despite his $300,000 college education, he knew nothing about business, and struggled through 112 hour work weeks because what you need to run a successful business is not taught in school. Finally, he made a breakthrough. That breakthrough revolutionized his business nearly over-night, and was single-handledly responsible for shrinking his work day from 16 hours to 4, and his work week from 7 days a week to just 3 (Tuesday, Wednesday, Thursday). By 27, DrDamnit had paid off his home, his commercial building, all the cars, and began to travel and currently takes 6 vacations every year. It's not because he's smart either. It's because business itself and IT use and share the same types of skills. It's knowing how to apply them that makes all the difference.

How-To Video: Using Objects, Properties, Events and Methods in Microsoft Access

Join Experts Exchange Access expert Alison Balter as she gives an in-depth look at Objects, Properties, Events and Methods in Microsoft Access. In this one-hour video you’ll learn about:

  • Using the Object Browser
  • Referring to Objects
  • Working with Properties and Methods
  • Working with Object Variables
  • Understanding the Differences between Objects and Collections
  • Passing Objects to Subroutines and Functions
  • Determining the Type of a Control
  • Special Properties that Refer to Objects
  • Understanding and Working with Access's Object Model
  • Practical Examples of Working with Objects

Click here to download:
Access_Webinar_5_11.wmv (96.95 MB)

Webinar video viewing requirements:

About the Presenter: Alison Balter is the president of InfoTech Services Group, Inc. A highly experienced independent trainer and consultant specializing in Windows applications training and development, Alison has been in the industry for over 25 years. Since founding InfoTech Services Group, Inc. in 1990, Alison has grown its client base to include major corporations and government agencies like Cisco, Shell Oil and the Drug Enforcement Administration. She is a leading author of 14 Microsoft Access books and SQL Server books, including Alison Balter's Mastering Access 2007 Development, Teach Yourself SQL Server 2005 Express in 24 Hours and Using Access 2010.

Tips, Tricks and Best Practices for Site Optimization | Demystifying SEO Pt II

In Part II of "Demystifying SEO," Experts Exchange Search Engine Optimization pro Jonathan Hoekman present tips, tricks and best practices for your on-site and off-site optimization efforts.

Click here to download:
DemystifyingSEOII.wmv (60.34 MB)

Webinar video viewing requirements:

VBA Webinar: Going Beyond the Formula

In this one-hour session, Excel and VBA Guru Brad Yundt will teach you how to go beyond the formula with Visual Basic applications. You will learn:

  • How to trigger macros with buttons
  • Where macros are stored
  • How to use functions in worksheet formulas
  • How to write sample formulas
  • How to record and edit a macro for reuse
  • How to use the macro recorder to discover VBA bits that do what you need

Click here to download:
2011-03-24_VBA_Webinar_Going_beyond_the_formula.wmv (84.41 MB)

Webinar video viewing requirements:


About the Presenter: Brad Yundt is a mechanical engineer at Applied Research Associates, Inc. who has been working with Excel since 1988 and Visual Basic for Applications (VBA) since 1995. In 2003, Yundt began participating on Experts Exchange where he has since answered over 9,000 questions and currently serves as a Zone Advisor for Microsoft Office and Excel. For the past four years, Yundt has been the recipient of the prestigious Microsoft Most Valuable Professional award for Excel.

Writing Faster SQL Server Queries: Part 2

Learn strategies for improving database performance from Experts Exchange SQL Server pro Tim Chapman.

Properly written queries and well-designed indexes are key to improving database performance and working faster and more efficiently. In part two of Writing Faster SQL Server Queries with Experts Exchange Expert Tim Chapman, you'll learn:

- How to efficiently design transactions to minimize system blocking
- Strategies for handling queries involving many joins
- How to leverage SQL Server constructs to de-dupe data
- Common execution plan "red-flags"
- How to use a Numbers table for efficient operations
- An overview of indexing

Tim Chapman is a SQL Server consultant specializing in system architecture, administration and performance tuning. Co-owner of www.sqlservernation.com, Tim is a Microsoft MVP and has passed the SQL Server 2005 & 2008 MCITP tests for Database Administration and Database Development. He is also an Experts Exchange certified Expert with thousands of questions answered in the SQL Server 2005 and SQL Server 2008 zones.

Click here to download:
FasterSQL_Server_Queries_Pt_2.wmv (94.65 MB)

Webinar video viewing requirements: