priya ranjan

BASIC / INTERMEDIATE EXCEL – MICROSOFT OFFICE  2016 / 2019

Training Course Outlines  For Windows / Mac Computer :

STARTING THE EXCEL PROGRAM: 
	What is the Active Cell?
	The Excel cell referencing system 
	Entering numbers and text
	Default text and number alignment 
	Entering a date 
	Worksheets and Workbooks 
	Saving a workbook 
	Closing a workbook 
	Creating a new workbook 
	Opening a workbook 
	Switching between workbooks
	Saving a workbook using another name 
	Saving a workbook using a different file type
SELECTION TECHNIQUES:
	Manipulating rows and columns
	Manipulating cells and cell content
	Worksheets
	Font formatting
	Alignment formatting
	Number formatting
	Freezing row and column titles
FORMULAS:
	 Creating formulas 
	 The easy way to create formulas 
	 Copying formulas 
	 Operators
	 Using operators in formulas 
	 Relative cell referencing
	 Absolute cell referencing
FUNCTIONS:
	 What is a function? 
	 Sum function 
	 Average function 
	 Max function
	 Min function 
	 Count function
	 The COUNTA function 
	 The COUNTBLANK function
	 The Round function 
	 Using the IF function 


ADVANCED EXCEL – MICROSOFT OFFICE 2016 / 2019
FOR OFFICE PURPOSE:
	Use of operators
	 Advanced formulas
	Understanding of relative reference, absolute reference & mixed reference
	Use of if statement, multiple if statement
	 Filter & advanced autofilter – ( used to generate reports)
	 Conditional formatting, hyperlink
	 Use of validations
	How to create and use of macro in workbook
	Chart / 3d chart / use of pie chart & smart art
	Sumif, sumifs, countif , countifs , averageif & averageifs
	 Use of consolidate & subtotals
	Pivot table with chart report features – (used to generate reports)
	 Vlookup with iserror / isna functions – (used to generate reports)
	 Sorting & multiple sorting
	Data analysis through goal seek & data table features
	Linking of worksheet / workbook 
	Import / export of data
	How to protect file, worksheet & workbook
	Use of template
	Use of other applications in the workbook
	How to customize the applications
	Printing setup
	Many more …… with assignments & important notes


FLEXIBLE FOR HOME TUITION!
ONE TO ONE OR GROUP STUDENTS!
REASONABLE FEES!
HOURLY CLASSES!

PLEASE CONTACT ON: [PHONE] ( calling no. / What’s App ) 


Get Advanced Excel Computer Trainer In Dubai

Details

Description

Location