My name is Mike Smart and I've personally written and recorded every Excel video on this channel. I've devoted the last 20 years of my life working towards one objective: To create the world's best and easiest way to master Excel.
I'm the founder and CEO of The Smart Method. In my long career as an IT consultant, I specified, designed and delivered IT solutions for large corporations all over the world. In 2002 I decided to specialize in IT training and founded The Smart Method.
By carefully observing the areas that students find the most difficult to understand, I've constantly refined my "Smart Method" teaching technique over a period of more than twenty years.
In 2008 I realized that I could only ever teach a few thousand students in my classroom courses but could help millions of students by producing my Excel courses in book form. My first "Smart Method" Excel books (covering Excel 2007) rapidly became best sellers and my books have topped best seller lists ever since.
love your videos/books. i saw the on your website you have the free video walkthrough for the Expert Skills 2016 book owners. Would you happen to have the videos for the Expert Skills Jan 2021 version because i have the book? thanks
Thank you for this. Excel is hard for me. Half the time these videos are to hard for me to understand. I loved how easy & fast your video was for me. Thanks a million 😊
The Excel 2013 Expert Skills contains 9 Sessions & 158 lessons. So why random videos of only 20 lessons are shown on this channel & why not videos of each 158 lessons are included. However for Excel 2013 Essential Skills the videos of all 139 lessons & 8 Sessions are included on this channel. So by when we can expect the same for Expert skills lesson videos ?
Thankyou very much for the complete course playlist. I have been looking for excel classes for a while now... and now only found this....This is the best playlist to study excel.😍😍😍
thank you so much, I've tried a lot and you are the only one who mentioned the system format date, when I adjusted it, the magic happened. you deserved a subscribe
What's the formula for totalling up Yearly shopping. Can I use autosum to total up a shopping list for the whole year?. For example can I type =SUM(D6:Z38 in Total box and click enter. And for monthly total do I use autosum by typing =SUM(D6:D38 in the total box and click enter
What's the formula for totalling up Yearly shopping. Can I use autosum to total up a shopping list for the whole year?. For example can I type =SUM(D6:Z38 in Total box and click enter. And for monthly total do I use autosum by typing =( SUM(Z6:D38 in the total box and click enter
You can use AutoSum to sum any column of numbers. Make sure that the column only contains numbers (for example not text) and that there are no blank cells. You can also manually type in a SUM function to reference any range of cells (see Lesson 2-12: Create Excel formulas the correct, professional way: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-GR7rebZN_hE.html).