By WIISE
Online
Can be taken anytime
Professional Training Course
Yes (Details)
English
$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.