68 STUDENTS ENROLLED

Featured Testimonial

The Greatest Strength of the instructor explain material clearly and indicate important points to remember and also shows genuine interest in...Read more

Anamika Gaur

CS Qualified

Basic Excel Course

A guide to Excel for total beginners. In this Microsoft Excel training course, expert training provider takes you through the basics of the worlds most popular spreadsheet software.

In this Excel training course, you will learn by watching the author actually perform the operation he is instructing on, as he explains step by step how to perform these functions. The training explains Microsoft Excel starting with the absolute basics of creating your very first worksheet. He slowly works you up through learning the various capabilities of this very powerful program, and covers topics such basic to advanced formula and functions. As part of this course, you can also download the working files that allow you to work alongside the author as he teaches you how to use Microsoft Excel.

By the completion of this online training course, you will be fully versed, and capable of working with Microsoft Excel 2010 in a commercial Environment.

What are the requirements?

  • Excel 2013 – Windows

 

What am I going to get from this course?

  • Over 115 lectures and 7 hours of content!
  • Learn Microsoft Excel from a professional trainer from your own desk.
  • 115 lectures (7 hours of content) teaching you from the basic to the advanced of this powerful program
  • Suitable for beginners to advanced users. ideal for users who learn faster when shown.
  • Visual training method, offering users increased retention and accelerated learning.
  • Breaks even the most complex applications down into simplistic steps.

 

What is the target audience?

  • Beginners and Intermediate

For Course Curriculum click on the Course Curriculum in left side menu.

Course Curriculum

Basic Excel Calculation
Methods and Shortcuts to Open ExcelFREE 00:02:00
Basic Excel CalculationsFREE 00:04:00
Define Ranges to Perform Calculations 00:02:00
Absolute and Relative Reference in ExcelFREE 00:03:00
Mixed ReferencesFREE 00:03:00
Write a 3D function and How to Consolidate 00:04:00
Useful Quick Excel Shortcuts
Shortcut to Autosum, Copy, Paste 00:03:00
How to repeat Previous Task ? 00:02:00
Shortcut to Fill Down, Fill Right 00:01:00
How to Insert and Delete Rows and Columns ? 00:02:00
Show and Hide Ribbon with shortcut keys 00:02:00
Use of Ribbon without Mouse 00:03:00
How to Customise the Shortcuts ? 00:05:00
How to Customize Ribbon 00:04:00
Paste Special
Paste Value, Format, Formulas, Comments only with Paste Special 00:04:00
Update Value without Formulas 00:02:00
How to Transpose Data from Column to Row 00:02:00
Link Data with Paste Special 00:02:00
If Conditional Function
Use of IF Condition for Single Criteria 00:03:00
Use of IF Condition for Multiple Criteria 00:04:00
Use of IF & AND function for Multiple Criteria 00:04:00
Use of IF & AND Function with OR Function 00:04:00
Nest IF Function for Multiple Grades 00:05:00
Conditional Formatting
Use Conditional Formatting to Colour Cell Based on Content 00:00:00
Identify Bottom and Rop Numbers using Conditional Formatting 00:03:00
Display Data with Data Bar 00:02:00
Use a Formula to Format the Cell 00:05:00
Rounding Functions
Int, Trunc, Odd, Even Functions 00:06:00
Round, Roundup, Rounddown Functions 00:03:00
Mround, Ceiling, Floor Functions 00:03:00
Mathematical Functions
Max, Min, Median, Average, Sum Function 00:03:00
Count, Counta, Countblank 00:02:00
Rank the List with Rank Function 00:03:00
Large and Small Functions 00:03:00
Introduction to IF related Functions 00:03:00
Use of SUMIF Function-part-1 00:05:00
Use of SUMIF Function-Part-2 00:04:00
Use of Average IF Function 00:05:00
Use of SumIFs and AverageIFs Functions 00:04:00
Use of Count IF Function 00:05:00
Use of Count IFs Function 00:03:00
Database Functions
Introduction of Data Base Functions 00:03:00
Using DSUM Function for AND Criteria 00:06:00
Using DSUM Function for OR Criteria 00:04:00
Using DGET Function to Find Single Record 00:03:00
Text Functions
Use of Right,Left,Mid Functions to Extract Text 00:06:00
Use of Find, Search, Len Function 00:05:00
Use of Trim, Proper, Upper, Lower Function 00:04:00
Use of & and CONCATENATE Function 00:05:00
Use of Rept and Len Function to Display Initial Zero 00:04:00
Use of Replace & Substitute Functions 00:06:00
Advanced Use of Text Functions with Example 00:07:00
Advance Use of Right, Mid, Left Functions 00:10:00
How to Extract Worksheet Name with Text Functions 00:06:00
How to Extract Workbook Name with Text Functions 00:04:00
Validation and Protections
How to Prevent From Entering incorrect values 00:04:00
How to Validate Huge range of values 00:03:00
How to Protect the whole worksheet with password 00:04:00
How to Keep few cells unprotected while entire worksheet is protected 00:05:00
Document Encryption & Mark as Final 00:03:00
IS and Lookup Functions
Introduction to ISNumber, ISError, ISBlank Functions 00:07:00
Use of IF, Match and ISError & ISNumber Functions 00:06:00
Simple Use of Choose Function 00:04:00
Use of Choose Function to make Scenario Analysis 00:05:00
Use of Vlookup to extract Record from Table like Data 00:05:00
Advance use of Vlookup, IF and ISError Functions 00:06:00
Use Hlookup Function with Match Function 00:04:00
Combined Use of Vlookup and Hlookup with IFerror 00:07:00
How Index Function is much better than Vlookup & Hlookup 00:06:00
Indirect Function-Prepare an Output Sheet 00:05:00
Financial Functions
Use of FV & PV Functions to analyse Investment Returns 00:05:00
Use of FV Schedule Function in Case of Variable Interest Rates 00:02:00
Effective & Nominal Rates with Effect & Nominal Functions 00:04:00
Use of IPMT, PPMT, PMT Functions to Prepare Debt Repayment Schedule 00:06:00
Use of CumIPMT and CumPrice Functions 00:04:00
Date and Time Functions
Introduction of Date & Time Functions and Format Convention 00:06:00
How to Change Default Date and Time Format 00:03:00
Custom Formatting of Dates 00:04:00
Today & Now Functions to Enter Current Date and Time 00:04:00
Weekday Function to Identify the Day of Week 00:04:00
Weekday and Networkday Functions 00:03:00
How to Find Age with DatedIF Function 00:04:00
Edate & Emonth Functions 00:04:00
How to Extract Year, Month, Day from Given Dates 00:02:00
How to use Autofill to write Date Series 00:04:00
What IF Analysis and Subtotal
Use of Goal Seek to get a particular Result 00:03:00
How to Summarize Data using sub total tool 00:05:00
How to Use Data Table for Sensitivity Analysis 00:05:00
Scenario Manager for Different Outcome 00:05:00
Charts
Introduction to Chart Elements and Chart Types 00:07:00
How to Create First Chart and Display Specific Data 00:03:00
Learn to Create Instant Chart, Use Switch & Move Buttons 00:05:00
Learn to Change the Default Chart, Give Title, Save as Template 00:08:00
Understanding the Use of Legends, Chart Title, Axis, Data Labels, Gridlines etc 00:07:00
How to add an Average to the Chart 00:03:00
How to Create Double Axis Chart to display values with huge difference 00:02:00
How to Create a pie Chart 00:04:00
Formatting of Pie Chart & Key Features 00:05:00
Pie to Bar and Seperate Peices of Pie Chart 00:07:00
Pivot Table
Introduction to Pivot Table 00:08:00
How to Find Out Values as % of Grand Total and Column/Row Total in Pivot Table 00:07:00
How to Display Revenue by Quarter in Pivot Table 00:05:00
Use of Calculated Field for calculating commision on revenue 00:03:00
Use of External Data Connections to import data from different file 00:03:00
Consolidate Sheets through pivot wizard 00:04:00
Filter the pivot table by Row and Column label 00:03:00
Adding and Removing Subtotal and Grand Totals 00:04:00
Conditional Formatting in the Pivot Table 00:04:00
Create your First Pivot Chart 00:03:00
Change Chart Type, Formatting, Filter Column 00:05:00
Array Function
Introduction to Array Functions 00:07:00
Multiple Condition Test with Array Function 00:03:00
How to Count Uniques Enteries in List 00:05:00
How to Transpose Data with Link 00:04:00
How to Combine Multiple Functions with Array 00:05:00
Download Videos
Download Basic Excel Videos 00:00:00

    Course Reviews

    3

    95 ratings
    • 1 stars0
    • 2 stars0
    • 3 stars0
    • 4 stars0
    • 5 stars0

    No Reviews found for this course.

    © 2015-17 Takshila Learning. All Rights Reserved.
    Request Callback
    For course & fee related queries, Leave your details and our counsellor will get back to you or Call us at 8800-999-280
    • This field is for validation purposes and should be left unchanged.

    Login