MS Excel for Professionals - Starter Pack

Microsoft Excel for professional

  • 0 ratings, 11 students enrolled

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.

What are the requirements?

  • Familiarity in using computers

What am I going to get from this course?

  • You will become a master in Microsoft Excel

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

  • Introduction to Excel Environment
     
  • Basic Options
     
  • Excel Layout
     

Entering data

  • Introduction
     
  • 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

  • No reviews found

toprated

English

Designed for beginners, this 45 minutes course aim... Read More

Oct 12, 2019, 18 Comments

Doodling for Beginners

This course is designed for absolute beginners in ... Read More

Jun 18, 2019, 7 Comments

View More...