Search
Close this search box.

Learning Excel 2013: A full tutorial of most features

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

Recent Posts
Showing 69 comments
  • This site was… how do you say it? Relevant!! Finally I have found something that helped me.
    Thanks a lot!

  • AmparoTHauch

    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.

  • why not find out more

    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.

  • Al Signorile

    Very good info. Lucky me I found your site by chance (stumbleupon). I’ve saved as a favorite for later!

  • furtdsolinopv

    Rattling nice design and style and good content material, hardly anything else we want : D.

  • Alycia Riggsby

    I found this board and I to find It

  • With our unique connections and private attentiveness, your satisfaction is inevitable.

  • OmarRBachman

    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.

  • MiquelRAmmar

    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!

  • CedricVWon

    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!

  • TyrellGKubis

    Hello to all, the contents present at this web site are truly amazing for
    people experience, well, keep up the good work fellows.

  • MartineDKrey

    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!!

  • CameronLKale

    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!

  • NormandCBupp

    Wow, that’s what I was searching for, exactly what a stuff!
    existing here at this internet site, thanks admin on this site.

  • tanie kredyty gotówkowe

    Thank’s great post.

  • DiegoELute

    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!

  • Cialis

    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.

  • DawnaYWarrix

    I could not resist commenting. Well written!

  • insurance

    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.

  • GaylaBMannes

    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!

  • BufordGLimbo

    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!

  • Hosting Italia

    Let Excel be your calculator. Take this course to learn how to add, subtract, multiply, and divide using formulas and functions.

  • LaniDAmiot

    When you desire to grow your experience only keep visiting this website and be updated using the most updated news
    update posted here.

  • JudeHAytes

    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.

  • AlexVGrattan

    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

  • KenVGorsline

    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.

  • JanisOArcega

    Great article.

  • CoyAPressley

    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.

  • RupertQCoble

    We all love it whenever people come together and share ideas.
    Great site, keep it up!

  • EmileeAHyten

    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.

  • MajorTFusaro

    Very good info. Lucky me I just found your site by accident
    (stumbleupon). I have got bookmarked it for later!

  • RustyJDonlan

    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.

  • TishaEChehab

    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.

  • ElzaKPasch

    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!

    • Sali

      Thank you for your comments and for sharing the link to the site.

  • ElsaXButay

    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.

  • YaniraYChino

    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?

  • EldenAOffutt

    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.

  • bastcilk doptb

    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

  • RonnyVDebray

    Appreciate this post. I want to try it out.

  • SixtaMStamos

    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.

    • Sali

      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.

  • JavierXGurka

    Hello, I visit your new stuff regularly. Your humoristic style is awesome, keep
    it!

  • RandyUYeater

    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.

  • IrvinSBecvar

    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?

  • ClassieVLanz

    I am just regular visitor, how are you presently everybody?
    This post posted around this site is truly good.

  • MeghanZBison

    Why viewers still make use of to read news papers when in this technological world everything is presented
    on net?

  • LianaZGungor

    I constantly emailed this website post page to all my friends, as
    if want to read it then my contacts will too.

  • DwightTKnoth

    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!

  • LoiseHThai

    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!

  • MeganJGott

    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.

  • GusLSheftall

    What a material of un-ambiguity and preserveness of valuable know-how regarding unexpected emotions.

  • RoryPHeilman

    Saved as a favorite, I adore your web site!

  • AlaneVBinker

    I read this article fully regarding the resemblance of most current
    and earlier technologies, it’s amazing article.

  • facebook password hacker

    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

  • ArtDPotulski

    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.

  • Sali

    This is based off a WordPress theme. It costs some but worth it.

  • hack facebook free

    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

  • KoryFZepka

    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.

  • LanetteIHitt

    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.

  • LuisaBRidler

    Thanks for sharing your thoughts about news. Regards

  • StevieLQuero

    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!

  • SeanXForss

    Hello to every one, the contents existing at this web page are truly
    amazing for people experience, well, keep up the good work
    fellows.

  • CassiQArtzer

    Very rapidly this website will be famous amid all blogging and site-building visitors, due to it’s good articles or reviews

  • RoyURipley

    This information is invaluable. When can I find out more?

    • Sali

      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.

  • SammyCUrey

    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!

  • BennettKOday

    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?

  • Jennifer

    Excellent Post, thanks for sharing.

Leave a Reply to BufordGLimbo Cancel reply