New Laptop Setup Steps

On the weekend, I got a new laptop (another ASUS), which is exciting, until you realize all the things that have to be set up. It came with Windows 10 installed, but nothing else, so there were lots of programs to install. On the bright side, it’s a 15″ laptop with a number pad, so that’s a good thing!

Continue reading

Posted in Computer tips | 3 Comments

Last Chance to get 20% off Excel Macro Course

Recently, I let you know about Allen Wyatt’s Excel Macros for Beginners course that can help you work faster by automating some of your tasks.

If you’re thinking about signing up, I wanted to remind you that the 20% early bird discount is ending this Thursday, March 10th, at 8:00 pm Pacific time pm.

Continue reading

Posted in Excel training | Leave a comment

AWeber Link Tracking Not Working

As I’ve mentioned before, I use AWeber to manage my mailing list, and I’m generally pleased with the way that it works. Recently though, I discovered a major problem with the AWeber link tracking feature. I’ve lost data, but have learned how to avoid the problem in the future. As is often the case with computer problems, it was user error!

Continue reading

Posted in email list tips | Leave a comment

Work Faster in Excel

Are you ready to learn how to work faster in Excel?

Excel’s macros can help you automate your work, so your routine tasks can be done quickly and easily. It makes things go much faster, and you can focus on the more important tasks instead.

Continue reading

Posted in Excel training | Leave a comment

Add Products to Your E-Junkie Store

Since 2011, I’ve sold my Excel products through e-junkie and it has worked well for me so far. As a seller, you automatically get an online store on the e-junkie site, and you should take advantage of that opportunity.

Continue reading

Posted in product sales | Leave a comment

Don’t Miss the Free Dashboard Webinars & Course

Just a quick reminder that the awesome Excel Dashboard Course, by Mynda Treacy will be closing on Thursday February 25, at 8 PM (Los Angeles time).

I’ve been through this course, and loved it. High-quality online courses like this one are an efficient way to learn, because you can go at your own pace, at any time of the day or night, and review the content later, if you’d like to. It’s much better than sitting through a full-day classroom training, where your eyes glaze over by early afternoon! From my experience, you retain a lot more when you learn in small chunks, and take time to practice your new skills as you go through the lessons.

Continue reading

Posted in Excel training | Leave a comment

Are Your Excel Skills Falling Behind?

Are your Excel skills falling behind? Over the last couple of years, powerful new tools like Power Query and Power Pivot have been added to Excel. Do you know how to use them?

These new tools can help you get your work done faster, and there’s another bonus — less than 1% of Excel users know how to use these tools so you’re going to have a huge competitive edge in the workplace.

If you’re not convinced that you need to explore these new tools, ask yourself if you’ve ever felt like:

  • “The work is piling up — my Excel reports take way too long to update each month/week”
  • “It’s frustrating — I spend hours collecting and cleaning data, updating formulas and building charts and then no one reads my reports anyway.”
  • “I need a raise! How can I impress the boss and get what I deserve?”
  • “How can my Excel skills help me stand out from the crowd of other job applicants?”
  • “Am I doing it right? I’m not sure how to set up my Excel workbook the best way, so it’s easy to build and maintain”

If those problems sound familiar, then I have a solution for you — Mynda Treacy’s highly acclaimed Excel Dashboard course. There are 2 free webinars, and a full course is available too. NOTE: If you register by February 18 it’s 20% off.

Free Excel Dashboard Webinars

If you’re not sure what a dashboard is, or how these skills might help you, then you can attend one or both of Mynda’s FREE Excel Dashboard Webinars.

Webinar 1 – Excel Dashboard for Excel 2007/2010/2013/2016

The first webinar will teach you how to use Excel to build this interactive dashboard below, no additional software or add-ins required, just plain old Excel and some data.

Webinar 2 – Excel Dashboard for Excel 2010/2013/2016 using Power Query and Power Pivot

If you have Excel 2010, 2013 or 2016* then this webinar will showcase how you can use Excel’s Power Query tool to get data from multiple sources, mash it up with Power Pivot, analyse it in PivotTables to create this interactive Excel Dashboard.

* Power Query is available with the desktop version of Excel 2010, 2013 or 2016, or Office 365 ProPlus. Power Pivot is available with the desktop version of Excel 2010 or Excel 2013/2016 Office Professional Plus, Office 365 ProPlus, or in the standalone editions of Excel 2013/2016.

Click here to sign up for the Webinars.

What people are saying about the webinars

Over 15,000 people have attended her Excel Dashboard webinars and this is what some of them had to say:

“Thank you! This webinar has already saved tremendous time and effort. I tried some of the techniques you illustrated for a cumbersome report update that I can see will cut our preparation time by 2/3’s or more. ….awesome! Many thanks!!!!”   Cynthia Tashjian

“WOW, just WOW. Can’t type more now – am trying to create a dashboard. Thank you Mynda!”   Susan

“The webinar was fantastic! I really enjoyed every moment. As you said, it was fast paced, but I am so excited to go back and review the presentation. We have been trying to get a dashboard started for my department and this really motivated me to take the lead. Thank you so much!”   Kathryn Puskar

“My jaw dropped a couple of times as you casually mentioned a way to manipulate PivotTable data. That’s the problem with being largely self-taught – there are huge gaps in my knowledge.”   Ann

“I presented my first dashboard to the CEO yesterday and he was ecstatic. Since we are downsizing I was very worried about my job, but after seeing his reaction…I understand that my job is secure (for now). Thanks!”   Iris Stein

Dashboard Course Format

If you’ve seen Mynda’s free Dashboard Webinars and you’re ready to take your dashboard skills to the next level then check out Mynda’s Online Excel Dashboard course.

It will teach you how to build amazing interactive dashboards that impress your boss, get you noticed and help you stand out from the crowd, like this incredible le Tour de France dashboard she made, which is also included in the course:

The best part, aside from all the dashboard skills you’ll learn, is you’ll also get tons of tips you can use in your everyday Excel work to get things done more efficiently.

What to Expect in the course:

  • The course is video based and available online 24/7
  • It comes with comprehensive Excel workbooks complete with notes
  • 5 example Excel dashboards to keep
  • There’s also an option to download the videos,
  • Plus Mynda personally provides support for the first 6 weeks of the 12 month membership.

By the way, that 6 weeks of personal support is the reason the course is only open for a limited time (registration closes February 25). Mynda limits the number of classes to ensure that she can provide personal support to each new group. You’ll still get support after the first 6 weeks — it just might take her a few days or a week to reply to you if she’s out of town or busy working on another project

Dashboards are an incredibly valuable tool in today’s market for consultants, analysts and managers. And when you know the tricks it can be straightforward to build highly professional and interactive Excel dashboards. That’s why this type of training is so worthwhile.

What members are saying about the course:

The previous classes have been a huge hit with many people saying how they love the cool techniques and how they’ve been able to impress their colleagues and clients by using them in all sorts of reports, not just dashboards.

“An excellent course, Mynda. You have the gift of making the complex simple to understand. I thoroughly enjoyed your teaching. I have applied nearly everything taught.   Thank you”   Charlie.

“This was my first online training course and I was a bit dubious about how much I was going to learn. I have to say, minute for minute I have learnt more on this course than any other course I have been on. The way the course is delivered is exceptional and the learning material and exercises really cement the learning.   This course has without a doubt furthered my career and has allowed me to secure a permanent job based on the skills I have acquired from this course. I have already signed up to another course!   Thanks”   Ryan Cunningham

I highly recommend the course but don’t just take my word for it. You can read further comments from past students and find out more here.

Bonus 20% Off

If you register by Thursday, February 18 the course is 20% off, plus I’ll include a free copy of my new Excel Dashboard Tools add-in. Just enter DebraD in the Coupon Code field in the Cart or Checkout, and then email me your receipt. I’ll send you my bonus, as soon as it is released (estimated release date is Monday, February 22nd – I’m just adding the final touches).

So, do yourself a favour and check out the course. The price is a great investment, the course is awesome and it will transform your Excel reports and possibly even your Excel career.

And remember, after you watch the free webinars, or join the course, it’s important to put those tips into action as soon as possible!

Disclosure: For students who join Mynda’s course, I make a small commission, and as you know, I only recommend products of outstanding quality and value, that I truly believe in.

Posted in Excel training | 1 Comment

Show Cursor Highlighting in Camtasia Studio 8

It was a struggle, but I’m finally up and running with Camtasia Studio 8, and the yellow cursor highlighting is working again. What a pain that was to figure out!

Yellow cursor highlighting in Camtasia 8

Yellow cursor highlighting in Camtasia 8

Continue reading

Posted in Computer tips | Leave a comment

Preparing for a Home Office Power Outage

There was a big storm in Mississauga last night, and the weather channel predicted heavy rain, lightning, and “toonie-sized hail”. If you’re not familiar with Canadian currency, a toonie is our $2 coin, and about the same diameter as a golf ball.

Continue reading

Posted in Computer tips | Leave a comment

Volume Icon Missing in System Tray

Usually the Volume icon is sitting in my laptop’s System Tray, and I use it several times a day, to turn the sound up or down. But occasionally it disappears – usually after an update or after installing some software.


Continue reading

Posted in Computer tips | Leave a comment