Data Analytics

What learn

They will learn pencil techniques in order to create shirring/gathers, and shading, and the use of color pencils.

They will learn movement of the body, balance, plumb line.

They will learn about a fashion diary/journal, as a source of inspiration in order to be a great designer.

Course Content

9 sections • 26 lectures • 21h 55m total length

	1.User interface or Parts of Excel, Part 1		60min
	2.User interface or Parts of Excel, Part 2		60min

	1. Editing data and customizing		60min
	2.Cut, Copy, Paste, Redo, Undo		60min
	3. Clipboard, Split panes		60min

	1.FILL types in Excel		60min
	2. Copying formulas without changing the cell references • Subtotal • Text functions • Logical or Comparative Operators • Conditional Formating • IF and IFs functions, Nestedif • Database Functions • Logical functions • Basic unconditional formatting in Excel • Formula auditing		60min

	1.Naming Ranges		60min
	2.Basic Sorting and Filtering		60min
	3.Advanced Sorting and Filtering • Excel Power Query • Excel Dashboarding		60min

	1.Inserting and Deleting Rows, Columns and Cells		60min
	2.Hide Unhide rows and columns, Modify column and row size, Freeze and Unfreeze • Working on worksheets • Basic formulas and functions		60min

	1. Absolute, mixed and relative cell referencing		60min
	2. Protecting Cells and Worksheets		60min
	3.Protecting files and Workbooks		60min

	1. Text to columns		60min
	2. Textsplit function		60min
	3. Textbefore function		60min
	4. Textafter functions		60min

	PROTECTION IN EXCEL • Tables in Excel • Printing • Data Validation and Dropdown, Advance Validation • Index and Match functions		60min

	• MACROS In Excel & Uses		60min

Requirements

No course requirements or prerequisites.

Description

Drawing thoughts twirling in your psyche onto paper is the initial phase in building up a style portfolio and a design assortment/line. Having the option to share thoughts that can in the end be converted into a real piece of clothing is so significant. Your sewer and additionally design creator must have the option to take a gander at your portrayals and comprehend what you're imparting. The sketch will in the end become the piece of clothing along these lines should be exact and clear. You will figure out how to make a "style diary" which will assist you with building up your own exceptional style as a style architect. Comprehending what you like (and don't care for) engages your structuring capacities and will bolster you in building up your one of a kind "voice". Figuring out how to draw style plans, and its act, will give you certainty and sureness; it will help your resolve, and the capacity to convey your thoughts