Free Basic Excel Course + Lookup Function

EXCEL MADE EASY FOR EVERYONE.


Course content:



  • Creating a Loan Calculator-1
    Creating a Loan Calculator-2
    Creating a Loan Calculator-3
    Function Basics
    Logical Functions
    Mathematical Functions
    Lookup and Reference Functions
    LOOKUP, VLOOKUP, and HLOOKUP Functions
    Introduction to Advanced charts
    Line chart
    Column chart
    Pie chart
    Area Chart
    Converting area chart into line chart
    What is regression analysis ?
    What are chart templates ?
    What are sparklines ?
    Sparklines vs charts
    Data in hidden rows and columns
    Introduction to Pivot chart and tables
    Creating pivot charts
    Creating pivot table
    Multiple fields in row, column or data section
    Creating pivot charts
    Creating and using calculated fields



Description:

Microsoft Excel has the basic features of all spreadsheets,using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations. It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display. It allows sectioning of data to view its dependencies on various factors for different perspectives using pivot tables. 

In this course you will be learning the basics which is required when you start working with Microsoft Excel. In today's time Microsoft Excel is one of the most important tool used in any organization. This course will definately help you to learn the basics with the practical use of it.


This course is for:

  • Anyone who wants to learn working with Excel

Requirements:

Interest to learn and Microsoft Excel installed in their computers and laptops.

Comments

Post a Comment

Popular posts from this blog

Anti-Money Laundering Concepts: AML, KYC and Compliance

Anti-Money Laundering Concepts: AML, KYC and Compliance     Description: Welcome to the course on  Anti-Money Laundering (AML) , where you will learn about the key issues faced by financial institutions today:  Money Laundering and Terrorist Financing . This course will educate you on  Money Laundering and Terrorist Financing laws, Know Your Customer, Customer Due Diligence, Economic Sanctions and Politically Exposed Persons . This is a comprehensive course that captures all relevant concepts required for training employees of an organization. We will start the course by understanding the term Money Laundering and will then cover the process & impact of the same. Post which, we will learn about terrorist financing and then cover the differences and similarities between money laundering & terrorist financing. In the next lectures, we will cover the Anti-Money Laundering policies along with KYC procedures, Economic Sanctions & Politically exposed perso...
Read more

Microsoft Excel Masterclass for Business Managers

Microsoft Excel Masterclass for Business Managers      Description: 7 Reasons why you should choose this Excel course Carefully designed curriculum teaching you only the most used functionalities of Microsoft Excel in business environment Concise – you can complete this Microsoft Excel course within one weekend Business related examples, data analysis and case studies solved using Advanced Excel. You will learn various data analysis techniques using MS Excel Ample practice exercises on data analysis, MS excel (basic & advanced), because Excel requires practice Downloadable resources comprising important MS Excel techniques and functionalities Your queries will be responded by the Instructor himself Start using Excel to its full potential to become proficient at your Excel tasks today! Either you’re new to Microsoft Excel, or you’ve played around with Excel since long but want to get more comfortable with MS Excel’s advanced features, or maybe you want to enhance your ...
Read more

Complete WordPress Website Developer Course

CHINESE LANGUAGE COURSE FOR COMPLETE BEGINNERS. LEARN MOST COMMON CHINESE PHRASES AND FOCUS ON SPEAKING CHINESE Description: This is one of the best WordPress course you will ever find. WordPress is now powering more than 29% of all websites in the world, there’s never been a better time to build an income and a business around it. This is the course of our students. New lecture are added every month and, at anytime on the request of the student.  You’re here because you want to master WordPress, right? Good idea. You’re in the right place. And, you can do it without learning any programming or coding. While WordPress is open source, and because of that has thousands of developers building resources for it, it still takes quite a bit of learning to become a master at building and managing websites with it. But you don’t have to worry about anything. I will teach you everything that you need to know. This course is for: Create beautiful blogs, stunning website and paying e...
Read more