Browse Course
CLOSE

CATEGORIES

MS Excel for Professionals - Starter Pack

Microsoft Excel for professional

  • (2 ratings) 43 students enrolled
Created byAsitha Vijilesh Last Updated: 2020-10-08 22:09:07

Course Overview

Microsoft Excel puts a wealth of functionality at your fingertips. This course was designed to focus on the most essential of these functions, covering the features and capabilities that brand-new users need to get going with the 2019 version of Excel.In this course you will learn creating and opening workbooks, entering text and numbers, working with formulas, basic formatting, inserting charts, and sharing and printing workbooks. Upon wrapping up this course, you'll have the skills you need to start building easy-to-use, accurate spreadsheets with this hugely popular program.

1. What are the requirements?

  • Familiarity in using computers

2. What am I going to get from this course?

  • You will become a master in Microsoft Excel

3. Who this course is for?

  • Anyone who wants to learn the Microsoft Excel

About the Author

  • An Engineer and a perfect home maker who has keen interest in teaching, turned her career now to an online educator.Finds satisfaction in her current part time hobby when it really makes useful & worth to her students. According to her, life gets to its core when your efforts makes someone smile.

    Has worked priorly as a lecturer in Wayanad gov engineering college, and higher secondary school.Currently shares her knowledge through youtube channels.


Course Curriculum

Getting started

Entering data

  • Introduction
    Preview
     
  • Worksheet Operations
     
  • Storing Details
     

Creating formulas and function

  • Auto sum And Other Functions
     
  • introduction
     
  • Formulas in Excel
     
  • Year to Date totals
     
  • Relative, Absolute, Mixed References
     

Formatting

  • inserting Shapes Arrows Other Features
     
  • Introduction
     
  • Adjusting Row Height and Column width
     
  • Font And Number Formatting
     
  • Wrap Text, Alignment, Borders
     
  • conditional Formatting - 1
     
  • conditional Formatting - 2
     
  • Tables Part 1
     
  • Tables Part 2
     

Adjusting worksheet layout

  • moving Copying Inserting Data, Find Replace
     
  • Introduction
     
  • inserting Deleting Hide Rows Columns
     

Printing

  • print Controls
     
  • Introduction
     
  • printing
     

Charts

  • Charts Advanced
     
  • Introduction
     
  • Creating Charts
     

Adjusting worksheet view

  • Splitting Screen
     
  • Introduction
     
  • Freeze and unfreeze panes
     

Multiple worksheet and work book

  • Using Formulas To Link worksheet and workbook
     
  • Introduction
     
  • Displaying Multiple worksheets and workbooks
     
  • Renaming , inserting and deleting sheets
     
  • Moving, copying and grouping sheets
     

IF, VLOOKUP and Other function

  • Using COUNT IF Family Of Functions
     
  • Introduction
     
  • IF And Logical Operators
     
  • V-Lookup
     

Data management features

  • Using Filters
     
  • Introduction
     
  • Sorting Data
     

Pivot Table

  • • Automatic Date Grouping
     
  • Introduction
     
  • Creating Pivot Table
     
  • Manipulation of Pivot Table Data
     

Security

  • Assigning Passwords to workbook
     
  • Introduction
     
  • Unlocking Cells
     
  • Protecting Workbook
     

reviews

students

Quick Links

recentPosts

റെസ്യൂമെയും സി വിയും തമ്മിൽ എന്താ വ്യത്യാസം

Ever wondered whether CV and Resume are the same t... Read More

Oct 19, 2022 , 0 Comments

ഇന്റർവ്യൂ നടക്കുന്ന ദിവസം ഇതൊക്കെ ശ്രദ്ധിക്കാം

Do you have an interview scheduled for tomorrow? H... Read More

Oct 19, 2022 , 0 Comments

View More...

toprated

Machine Learning and Data Scie

Globally, the machine learning market is expected ... Read More

Jul 2, 2020, 15 Comments

Introduction to HTML, CSS and

HyperText Markup Language, commoly abbreviated as ... Read More

Dec 14, 2021, 13 Comments

View More...