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 &amp; mixed reference 	Use of if statement, multiple if statement 	 Filter &amp; 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 &amp; smart art 	Sumif, sumifs, countif , countifs , averageif &amp; averageifs 	 Use of consolidate &amp; subtotals 	Pivot table with chart report features – (used to generate reports) 	 Vlookup with iserror / isna functions – (used to generate reports) 	 Sorting &amp; multiple sorting 	Data analysis through goal seek &amp; data table features 	Linking of worksheet / workbook 	Import / export of data 	How to protect file, worksheet &amp; workbook 	Use of template 	Use of other applications in the workbook 	How to customize the applications 	Printing setup 	Many more …… with assignments &amp; 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