Excel Lessons - Zero to Hero for Teachers and Office Workers - Printable Version +- Softwarez.Info - Software's World! (https://softwarez.info) +-- Forum: Library Zone (https://softwarez.info/Forum-Library-Zone) +--- Forum: Video Tutorials (https://softwarez.info/Forum-Video-Tutorials) +--- Thread: Excel Lessons - Zero to Hero for Teachers and Office Workers (/Thread-Excel-Lessons-Zero-to-Hero-for-Teachers-and-Office-Workers)

Excel Lessons - Zero to Hero for Teachers and Office Workers - OneDDL - 08-23-2024 Free Download Excel Lessons - Zero to Hero for Teachers and Office Workers Duration: 5h1m | Video: .MP4, 1280x720 30 fps | Audio: AAC, 44.1 kHz, 2ch | Size: 2.87 GB Genre: eLearning | Language: English Microsoft Excel Made Easy - VLOOKUP, Excel Formulas and Functions, Advanced Excel, Shortcuts, Tips & Tricks, Basic Excel What you'll learn What to Expect - How to get the best from each class, what you will need, basic assumption. Introduction - Excel Workbook, Worksheet, Interface Explained (formula bar, rows, columns, name box ), Resizing rows and columns Cell Referencing made easy - Relative Cell Referencing and Absolute Cell Referencing Data Modelling Explained. Why is Excel Smart? Working with basic operators (+,*,/,-) Conditional Formatting of Cells in Worksheet Introduction to tables and charts - Design a budget template Charts in Excel - Bar chart, Pie chart, Line chart, Scattered (Bubble) charts Full chart customization, Chart elements explained, Chart styles, Format chart area Introduction to excel functions - SUM, MIN, MAX, AVERAGE, COUNT, COUNTA, COUNTBLANK Working with Text functions I - "CONCATENATION" and "&" operator Working with Text functions II - LEFT, RIGHT, UPPER, LOWER, PROPER, LEN, MID Data Sorting, Data Filtering, Freeze Panes Carry out Searches and Query in Excel Smart Excel tips and skills to speed up workflow inthe work place Lookup functions in Excel - Vertical lookup (VLOOKUP) and Horizontal lookup (HLOOKUP) Logical Excel Functions - IF, OR, AND, Nested IF Data summary in Excel - SUMIF, COUNTIF, SUMIFS, COUNTIFS Using PIVOT tables as a tool to summarize data - Dicing and slicing Data Sharing and Data Tracking in Excel - Working with comments and changes made Budget Estimates, Financial modeling, Setting up payment schedule (loan amortization) Requirements You will need a Laptop or a PC with any version of Excel installed in it No prior Excel knowledge is needed. A relaxed mind because Excel is about to be made EASY...hahaha Description Some reasons why you should choose this Microsoft Excel Made Easy course Carefully designed curriculum teaching you only the most used functionalities of Excel in school and office environments You can complete this course within one weekend (it's just 4 hours ) Office-related and school-related examples and case studies with complementary tasks More practical exercises because Excel requires practice Downloadable resources Your queries will be responded to by the Homepage [To see links please register or login] Recommend Download Link Hight Speed | Please Say Thanks Keep Topic Live [To see links please register or login] No Password - Links are Interchangeable