UDEMY Microsoft Excel Essentials Bookkeeping and Accounting BOOKWARE-iLEARN | Apps-Tutorials | MP4 | 2.30 GiB
1 406 kb/s 1280×720 | AAC 128 kb/s 2 CH
iLEARN source: https://www.udemy.com/course/microsoft-excel-basics-course/ looking for locations in: 10 GBit .SE 10 GBit .NO and other european locations
45M 1. Introduction.mp4 35M 10. Clear Formats and Clear Content in cells.mp4 57M 11. Formatting cells in Microsoft Excel (Bold, borders, highlight, merge & center).mp4 40M 12. Using Copy, Cut, Paste, and Format Painter to copy cell format.mp4 64M 13. Paste Values using Paste Special.mp4 27M 14. Using Wrap Text to wrap spill over text in a cell.mp4 55M 15. Formatting numbers using dollar sign, percentage, decimal points.mp4 49M 16. Excel shortcuts - openclosesave spreadsheet, bolditalics, copy, paste, undo.mp4 60M 17. Excel shortcuts - Home tab, delete column, insert row, zoom.mp4 36M 18. Excel shortcuts - Tab, move to last cell, move to next worksheet, move down.mp4 24M 19. Mean, median, mode, count cells.mp4 25M 2. How to make the most of this course (subtitles, speed up videos).mp4 40M 20. Split screen to work on different parts of the same Excel sheet simultaneously.mp4 64M 21. Grouping data (expand and collapse data).mp4 41M 22. Using Charts (pie charts, column charts).mp4 63M 23. Sort and Filters in Excel.mp4 46M 24. Using Freeze Panes in Excel to see column headings and row headings.mp4 57M 25. Absolute Reference to prevent cell reference from moving.mp4 82M 26. Print Preview options.mp4 83M 27. Using Sumif function to add cells based on criteria you set.mp4 84M 28. Using VLookup function to find data quickly.mp4 54M 29. Using HLookup function to find data quickly.mp4 50M 3. Navigating around Microsoft Excel.mp4 40M 30. Using If function to test criteria and give results.mp4 47M 31. Using Left and Right functions to extract data in a cell.mp4 52M 32. Remove duplicates in a range of data.mp4 75M 33. Shortcut keys to quickly select a range of cells.mp4 27M 34. Absolute value of numbers.mp4 94M 35. Pivot Tables overview How to summarize data.mp4 61M 36. Pivot Tables report filters and column labels.mp4 67M 37. Find & Replace options.mp4 67M 38. Sum, count, average, time, date functions.mp4 37M 39. Displaying cell formula (auditing cell formula).mp4 44M 4. Entering text and numbers into Excel.mp4 75M 40. Sparklines to display trends inside a cell.mp4 51M 41. Text to columns (split first and last name into 2 cells).mp4 30M 42. Concatenate function (merging 2 columns into 1 column).mp4 49M 43. Flash fill (getting Excel to fill in information automatically for you).mp4 46M 44. Countif function.mp4 62M 45. Protect sheet (prevent unauthorized or unwanted changes to an Excel sheet).mp4 41M 46. Bonus lecture additional resources to learn bookkeeping.mp4 57M 5. Adding numbers using the SUM function.mp4 55M 6. Subtract, multiply, and divide in Excel.mp4 33M 7. Correcting cells and moving around cells.mp4 16M 8. Inserting columns and rows in Excel.mp4 68M 9. Conditional Formatting to add colors to data.mp4 2.3G total
File: 1. Introduction.mp4 Size: 46798757 bytes (44.63 MiB), duration: 00:04:26, avg.bitrate: 1407 kb/s Audio: aac, 48000 Hz, stereo (und) Video: h264, yuv420p, 1280x720, 30.00 fps(r) (und)
Filehosts: Nitroflare, Rapidgator
Keywords: UDEMY, Microsoft, Excel, Essentials, Bookkeeping, and, Accounting, BOOKWARE, iLEARNDownload from Nitroflare
https://nitroflare.com/view/D91C67092E64619/hggcUDMiExEsBoanAcBOiL.z01
https://nitroflare.com/view/35FADF213C8F011/hggcUDMiExEsBoanAcBOiL.z02
https://nitroflare.com/view/3270B1A0357A1F6/hggcUDMiExEsBoanAcBOiL.zipDownload from Rapidgator
https://rapidgator.net/file/520da454af4c6d4e616a576018c75310/hggcUDMiExEsBoanAcBOiL.z01.html
https://rapidgator.net/file/cb2720336fcc61aee34c88b60fbed6bd/hggcUDMiExEsBoanAcBOiL.z02.html
https://rapidgator.net/file/ef5ee13290b5a79e4a509c2c994f75c6/hggcUDMiExEsBoanAcBOiL.zip.html