Location
Online
Dates
Can be taken anytime
Course Type
Professional Training Course
Accreditation
Yes (Details)
Language
English
Price
$10

Course Overview

Excel is one the most powerful and most used application. You can use an excel sheet to store any sort of information in an easy to read format. By the end of this course, you can expect yourself to be able to use Excel very easily. Also, you will be able to work with the data in an excel sheet - input, organize, sort and analyze any data that you might require.

Learning Objectives:

  • Open, save and close a workbook in Excel
  • Identify parts of an Excel workbook
  • Enter and delete data
  • Insert and remove columns and rows
  • Use cut, copy, paste, undo, redo, find and replace
  • Insert basic formula
  • Use paste special
  • Format text and cells
  • Use excel autofill, flash fill, auto-sum and autocomplete
  • Sort data
  • Insert tables and filters
  • use names and data validation to restrict user inputs
  • Insert charts
  • Insert pivot tables, timeline, and charts
  • Set up a basic Sales and sales returns daybook in Excel
  • Set up a basic Purchase and purchase returns daybook in Excel
  • Set up a basic petty cash daybook in Excel
  • Set up basic payments and receipts daybooks
  • Identify key information to record in the daybooks

Who should take this course

It is available for all the learners.

Accreditation

WIISE

Course content

What will you cover?:

  • Excel Basics
  • Daybooks, Bookkeeping and Accounting - Basics
  • Excel - Working with data
  • Excel - Organizing and Sorting Data
  • Excel - Analysing Data

About Course Provider

WIISE is a 'Professional Learning Network'​ with a global outreach that helps anyone to learn anything to achieve personal and professional goals.

We bring top-rated interactive learning courses & certifications from across the world through respected Global Academic Institutes and Industry experts to our learners.

WIISE for Teams is a Smart training solution suitable for growing businesses (SMB’s) - deliver online cost-effective, on-demand training, staff engagement & Upskilling to their employees and customers. WIISE incorporates the latest micro-learning & social-learning techniques that provides fast and engaging training at a fraction of cost of traditional training methods.

WIISE is brought by respectable Learning services & Skill development company - PositiveShift Group - Silicon Valley CA USA, India (www.positiveshift.in). The company has been awarded unique Innovation partnership with National Skill Development Corporation (NSDC) and Ministry of Skill Development and Entrepreneurship, Govt of India.

Frequently asked questions

{{ item.question }}