Enquiry : 9920294574

Course Curriculum

Module 1 : Overview of the Basics

  • Creating a new Sheet

  • Working with the Ribbon

  • Sheet Options – Hide, Unhide, Move, Delete, Rename, Duplicate

  • Freeze – Unfreeze Columns and Rows

  • Add – Move Columns and Rows

  • Group – Ungroup Columns and Rows

  • Star Mark a Sheet

  • Apply Indian Currency

Module 2 : Working with Format Toolbar

  • Set Font, Size, Style, Text Color, Fill Color, Borders

  • Merge – Unmerge Cells

  • Alignment, Text wrapping, Text rotation

  • Insert Link, Comments

  • Filter views

  • Create a filter

  • Share

Module 3 : Charts

  • Insert Column Chart

  • Pie Chart

  • Scrolling Table

Module 4 : File Operations

  • Make a copy

  • Email

  • Rename

  • Add a shortcut to Drive

  • Move to Bin and Recover

  • Version History

  • Use Offline

  • Download and Import

  • Print

Module 5 : Insert Objects

  • Image

  • Drawing

  • Pivot Table and Pivot Chart

  • Apply Theme

Module 6 : Conditional Formatting

  • Predefined Rules

  • Custom Rules

  • Alternating Colors

  • Clear Formatting

  • Todo List

  • Add and Remove Rules

Module 7 : Data Validation

  • Sort Range

  • Advanced Range Sorting Options

  • Add a Slicer

  • Protect Sheets and Ranges

  • Data Validation – List, Range of Values, Prevent Duplicates

  • Delete Rules

  • Data clean-up : Remove Duplicates

  • a

  • b

Module 8 : Working with Functions

  • GoogleTranslate

  • IsEmail

  • Concatenate

  • XLookup

  • VLookup

  • Offset

  • Filter

  • Sort

  • ImportRange

  • Array

  • Query

  • GoogleFinance

  • Open-ended References

 

Duration : 1 Week

Fees : 1500/-