A full 18 module free tutorial on Excel 2013 is now available from our YouTube channel. Feel free to check it out and refer friends and link to it. Other modules are also now available in individual format. The video covers:
Data File: https://drive.google.com/file/d/0B3-9HUBAvpxnVm9GVDBjSVVPcGc/view?usp=sharing
This video covers the following topics along with the timeline:
0:5 Getting Started with Excel
7:06 Basic Calculations: SUM, AVERAGE, MAX, MIN
24:50 Arithmetic Calculations: Subtraction, Multiplication, Division
31:30 Relative, Absolute and Mixed Cell References
41:32 Conditional Formatting and Data Analysis
45:00 Data Sorting and Filtering
50:45 Creating and Modifying Charts
59:00 Cross-Sheet Calculations
1:05:15 Calculating Percentages in Excel
1:09:44 Using the IF statement in a Formula
1:15:55 PMT, IPMT, PPMT functions in Financial Calculations
1:26:20 Using Named References
1:31:15 Data Validation Using Drop-Down Lists
1:34:30 Pivot Tables
1:40:12 Setting and Clearing the Print Area
1:44:20 Linking Excel Data with Word
1:49:00 Importing and Exporting Data in .csv files
1:53:00 Saving Data in PDF Format
Leave a Comment
You must be logged in to post a comment.
This site was… how do you say it? Relevant!! Finally I have found something that helped me.
Thanks a lot!
Hey I know this is off topic but I was wondering if you knew
of any widgets I could add to my blog that automatically
tweet my newest twitter updates. I’ve been looking for a plug-in like this for quite some time and was hoping maybe you would have some experience with something like this.
Please let me know if you run into anything. I truly enjoy reading your blog
and I look forward to your new updates.
I simply want to say I am just all new to blogging and site-building and definitely enjoyed your web site. Probably I’m want to bookmark your site . You amazingly come with good posts. Kudos for sharing with us your website.
Very good info. Lucky me I found your site by chance (stumbleupon). I’ve saved as a favorite for later!
Rattling nice design and style and good content material, hardly anything else we want : D.
I found this board and I to find It
With our unique connections and private attentiveness, your satisfaction is inevitable.
Link exchange is absolutely nothing else except it really is only placing another person’s webpage link
on the page at suitable place as well as other person will
likely do similar for you.
The other day, while I was at work, my cousin stole my
iphone and tested to see if it can survive a 30 foot drop,
just so she can be a youtube sensation. My apple ipad is now destroyed
and she has 83 views. I know this is completely off topic but
I had to share it with someone!
This is the perfect website for anybody who wishes to understand this topic.
You know a whole lot its almost tough to argue with you (not that I actually would
want toHaHa). You certainly put a fresh spin on a topic that has been written about for ages.
Excellent stuff, just great!
Hello to all, the contents present at this web site are truly amazing for
people experience, well, keep up the good work fellows.
Oh my goodness! Incredible article dude! Thanks a lot, However I am encountering difficulties with your RSS.
I don’t understand why I can’t sign up to it. Is there anybody else getting the same
RSS problems? Anyone who knows the perfect solution do you want to kindly respond?
Thanx!!
It is appropriate time to make some plans for the near future and it is time to
be at liberty. I have got read this post and in case I might just I wish to counsel you
some fascinating issues or advice. Perhaps you could write next articles regarding this post.
I desire to learn even more things approximately it!
Wow, that’s what I was searching for, exactly what a stuff!
existing here at this internet site, thanks admin on this site.
Thank’s great post.
Firstly I want to say excellent blog! I had a simple question which
I’d want to ask should you not mind. I was curious to learn the method that you center yourself and clear your mind before writing.
I’ve had trouble clearing my thoughts to get my thoughts out there.
I truly do get pleasure from writing but it really just looks
like the initial 10 to 15 minutes are wasted just simply figuring
out where to start. Any recommendations or tips?
Thanks a lot!
It’s truly a great and useful piece of info. I’m glad that you shared this helpful information with us. Please stay us up to date like this. Thanks for sharing.
I could not resist commenting. Well written!
Just want to say your article is as surprising. The clearness in your post is just spectacular and i could assume you are an expert on this subject. Well with your permission let me to grab your RSS feed to keep updated with forthcoming post. Thanks a million and please carry on the enjoyable work.
Having look at this I believed it had been really enlightening.
I appreciate you making the effort as well as to place this post together.
I once again find myself personally spending a great deal of time both reading and commenting.
But so what on earth, it had been still worthwhile!
After I initially left a comment I have clicked on the -Notify me when new comments are added- checkbox and today whenever a comment is added I
recieve 4 emails with exactly the same comment.
Will there be a way you may remove me from that service?
Kudos!
Let Excel be your calculator. Take this course to learn how to add, subtract, multiply, and divide using formulas and functions.
When you desire to grow your experience only keep visiting this website and be updated using the most updated news
update posted here.
Hmm is anyone else encountering problems with the pictures on this blog loading?
I’m trying to determine if its a problem on my end or if it’s the blog.
Any suggestions would be greatly appreciated.
I don’t know whether it’s just me or if perhaps all the others experiencing difficulties
with your web site. It seems as though several of the written text inside your posts are
running off of the screen. Can someone else please provide feedback and tell me should this be happening to them at the same time?
This may be a problem with my internet browser because I’ve had this happen previously.
Many thanks
Hello, this weekend is nice in favor of me, as this occasion i am reading this great informative piece of writing here
at my house.
Great article.
Hello to every , since I am really eager of reading this website’s post to be updated on a regular basis.
It carries pleasant stuff.
We all love it whenever people come together and share ideas.
Great site, keep it up!
I will right away snatch your rss because i cannot find your email subscription link or e-newsletter service.
Do you might have any? Please permit me understand to ensure
that I could subscribe. Thanks.
Very good info. Lucky me I just found your site by accident
(stumbleupon). I have got bookmarked it for later!
I have got been surfing online over 2 hours today, yet I never found any interesting article like yours.
It’s pretty worth enough for me. For me, if all site owners and bloggers made
good content as you did, the internet will likely
be a lot more useful than previously.
No matter whether some one searches for his required
thing, therefore he/she wishes to get available that in more detail,
thus that thing is maintained right here.
Magnificent site. Lots of helpful information here.
I am sending it to several friends ans additionally sharing
in delicious. And needless to say, thanks in your effort!
Thank you for your comments and for sharing the link to the site.
It’s actually a nice and helpful component of information. I am just satisfied that you just shared this useful information along
with us. Please keep us updated this way. Thanks
a lot for sharing.
magnificent points altogether, you simply received
a emblem new reader. What may you recommend in regards to your post that you just made a
couple of days ago? Any certain?
Thank you for some other magnificent post. The place else may anyone
get that kind of info in such a perfect manner of writing?
I have a presentation subsequent week, and I am on the look for such info.
I appreciate, cause I found just what I was looking for. You have ended my 4 day long hunt! God Bless you man. Have a great day. Bye
Appreciate this post. I want to try it out.
I’ve been surfing on-line greater than 3 hours lately,
yet I never found any fascinating article like yours.
It is pretty worth enough to me. Within my view, if all web owners and bloggers
made perfect content as you did, the internet
can be considerably more useful than previously.
Thank you. I appreciate the feedback. Keep coming back and also please spread the word in the social media etc. That is one way you can help support this work. I also recently started self-paced courses for those that are serious about learning this stuff. If interested, check out http://learn.kaceli.com.
Hello, I visit your new stuff regularly. Your humoristic style is awesome, keep
it!
What’s Taking place i am just new to this, I discovered this I’ve
found It positively useful and contains aided
me out loads. I’m hoping to give you a contribution & assist other users like its helped me.
Great job.
Hey there! Do you know if they make any plugins
to safeguard against hackers? I’m kinda paranoid about
losing everything I’ve worked hard on. Any suggestions?
I am just regular visitor, how are you presently everybody?
This post posted around this site is truly good.
Why viewers still make use of to read news papers when in this technological world everything is presented
on net?
I constantly emailed this website post page to all my friends, as
if want to read it then my contacts will too.
Hello, I think your website might be having browser compatibility issues.
When I look at your website in Safari, it looks fine but when opening in Internet Explorer,
it has some overlapping. I just wanted to give you a quick heads up!
Other then that, fantastic blog!
I similar to the helpful information you provide on the articles.
I’ll bookmark your blog and test yet again here frequently.
I’m fairly sure I’ll be told lots of new stuff right here!
Good luck for another!
I’m excited to discover this amazing site.
I want to to thank you for ones time just for this particularly wonderful read!!
I definitely savored every bit of it and i have you book marked to look
into new stuff within your site.
What a material of un-ambiguity and preserveness of valuable know-how regarding unexpected emotions.
Saved as a favorite, I adore your web site!
I read this article fully regarding the resemblance of most current
and earlier technologies, it’s amazing article.
Great website! It looks very expert! Keep up the great job! Additionally, I have shared your site in my social networks. you could try these out: http://ow.ly/OBGn303jqlB
I actually have been browsing online greater than 2 hours today, yet I never found any interesting article like yours.
It really is pretty worth enough in my opinion. Personally, if all web
owners and bloggers made good content as you may did, the internet
will likely be a lot more useful than previously.
This is based off a WordPress theme. It costs some but worth it.
Can I simply say what a relief to discover somebody who actually knows what they’re discussing online. You definitely realize how to bring a problem to light and make it important. A lot more people should look at this and understand this side of your story. I was surprised you are not more popular because you surely have the gift. you can try this out: http://ow.ly/OBGn303jqlB
What’s up all, here every person is sharing these
kinds of know-how, thus it’s good to read this blog, and I used to visit this weblog every day.
Pretty section of content. I just stumbled upon your web site and in accession capital to assert that
I get actually enjoyed account your blog posts.
Anyway I will be subscribing to your augment and even I achievement you access
consistently quickly.
Thanks for sharing your thoughts about news. Regards
Very nice post. I simply discovered your blog and wished to
say that We have really enjoyed browsing your weblog
posts. In any event I’ll be subscribing with your feed
and I am just hoping you write again very soon!
Hello to every one, the contents existing at this web page are truly
amazing for people experience, well, keep up the good work
fellows.
Very rapidly this website will be famous amid all blogging and site-building visitors, due to it’s good articles or reviews
This information is invaluable. When can I find out more?
Subscribe to the newsletter and also to the YouTube channel: http://youtube.com/skaceli. In that way you will be alerted when new posts are available. I am soon going to post PowerPoint 2016. Also, please spread the word. I would love to see 50K subscribers on my channel by Christmas 2016.
You really help it become seem really easy with the presentation but I find this matter
to get actually something which I do believe I would personally
never understand. It appears too complicated and very broad in my opinion. I am
just anticipating for your upcoming post, I will try to find the hang than it!
I know this site provides quality based articles or reviews and extra material, can there be any other website which presents these
things in quality?
Excellent Post, thanks for sharing.