Excel Full Review 100 Lessons, Any Version, Subtitled

2. How to enter data in Excel and useful shortcut keys for repetitive data entry

3. How to make a weekly planner using the Excel fill feature

4. How to specify a custom fill list, How to use Quick Fill

5. Insert and edit memos Show/hide all memos How to input special characters How to input Hanja characters

6. How to delete a specific cell and shift data up, inserting and removing rows/columns, adjusting width, hiding rows/columns, explanation of data selection shortcuts

7. Method for specifying border lines, Font-related keyboard shortcuts, Method for merging and unmerging cells

8. Form Documents: Creation, Saving, and Loading

9. Various methods for converting cell formats

10. Cell Formatting Customization Method Date and Time Data Setting Method 1

11. Cell Formatting Customization Method Number Data Setting Method 2

12. How to create a document using cell formatting

14. How to move to blank cells, How to use Go To Special, Copy function, How to copy formatting

15. Search/Replace function, how to select objects and delete shapes all at once

16. Copying Only Visible Cells, Paste Special Guide

17. Pasting Part of Excel as a Picture; Anchoring Images in Cells

18. Using Conditional Formatting: Highlight/Top/Bottom Rules Method

19. How to display icons, data bars to emphasize data

20. How to reference different sheets, Sheet group operations, How to reference different documents

22. How to define and edit named ranges, Name shortcuts, How to use names in formulas

23. Explanation of function types, How to use the Function Wizard

24. How to Calculate Cumulative Sum of Data and How to Use Rank, EQ Functions

25. How to use the average and round functions needed to calculate ratings, and how to display stars using the rept function

26. Assigning data serial numbers automatically (using the ROW function), method for removing duplicate data, method for calculating the total by item using the SUMIF function

27. Calculating headcount based on single and multiple conditions using COUNTIF, COUNTIFS, and COUNT functions

28. Explanation of how to determine grades based on multiple conditions using the IF, IFS, and IFERROR functions, and how to handle errors when the result is an error.

29. Explanation of how to display customer key information with asterisks using the string functions left, right, and mid, and operators

30. Using CONCAT, TEXTJOIN, splitting and merging strings

31. How to format rows for reserved books using a formula in Conditional Formatting

32. Creating a schedule using date and weekday functions related to dates

33. Creating an Excel calendar using the DATE and WEEKDAY functions

34. datedif function to calculate period of employment, calculating workdays between two dates (networkday), calculating estimated project completion date (workdays)

36. Fast interest calculation method using array constants, Document password setting, Sheet protection, Method for protecting document structure

37. How to recover when you forget the password to unprotect a sheet

38. How to view two worksheets from one file side-by-side, Freeze Panes, Page Break Preview, Explanation of how to repeat specific rows when printing

39. How to Look Up Customer Name and Phone Number by Number Using the INDEX Function

40. How to find unit price information using vlookup and hlookup functions, and how to use vlookup with multiple criteria

42. Method for searching and displaying the name of the person with the highest total score in the department desired by the user, using index, match, and maxifs functions.

43. Usage of the OFFSET function, how to dynamically change a named range

44. When the user selects a book title, display the corresponding detailed data on the screen (using index, match, vlookup).

45. Filtering desired data using the filter function, and adding a column to the filtering result.

46. How to Set Various Criteria for Advanced Filters: Explanation

47. How to use form controls, How to use the PMT function

48. How to use the frequency function, displaying data for a specific price range

49. MS Word: Labels & Mail Merge with Excel Data

50. How to Use Data Integration Function, How to Integrate Product Groups Using Wildcard Characters

51. How to Use Excel Tables, Setting Summary Options, How to Reference Table Data from Outside

52. Explanation of how to create Main, Sub, and Detailed Category Lists using the INDEX function

54. How to read external data such as text files, CSV files, etc.

55. How to import only a portion of a specific worksheet, How to merge two queries into one using Power Query

56. Explanation of the TREND function for calculating sales trends, and the Goal Seek and Solver add-ins

57. Explanation of the shortcut key for creating charts, How to add/delete elements in a chart, How to print only the chart

58. Explanation of how to use radial and pie charts

59. How to Use Sparklines to Visualize Individual Data Content

60. How to format chart axes, insert a picture into a chart, and save a chart as a template.

61. Explanation from sales data processing to Pareto creation method

63. How to create a pivot table, explanation of pivot table areas

64. How to read Access data into Excel, How to import by connecting external data in a PivotTable

65. How to create a single PivotTable from data in multiple worksheets using the PivotTable Wizard

66. How to sort PivotTable values, how to group dates, how to filter top/bottom items, how to update a PivotTable when the source data changes

67. How to specify the field display format, how to use the time bar for easy filtering of date/time data, handling blank cell issues, explanation on how to hide row and column grand totals.

68. Explanation of 2 methods for removing duplicate values when calculating PivotTable values

69. Methods for creating, modifying, deleting pivot table calculated fields, explaining GETPIVOTDATA function use for data reference.

70. Explanation of Pivot Table Value Display Format Types, Report Layout, and Pivot Table Report Styles

71. Pivot Chart Limitations, How to Create a Pivot Chart

72. How to create a frequency distribution table and chart by grouping data into ranges in a pivot table and calculating the count of data points within those ranges.

73. How to Copy a PivotTable, Convert to Regular Data, and Add Needed Analysis

74. How to set up relationships between multiple relevant tables and how to utilize pivot tables using those related tables.

75. How to Record a Macro, Explanation of Various Ways to Run a Macro

76. How to modify a macro, How to link a macro to a command button control

77. VB Editor Basic Structure and How to Change Font Size, How to Write and Run VB

78. Module and Procedure Concepts, the basic structure of VBA programs, and practical programming exercises

79. Explanation of the main objects in VBA: Cell, Worksheet, Workbook, and working with core objects

80. Program Practice: Variable Declaration Methods and Displaying a Messagebox Using Them

81. VBA Basic Syntax - Cell and Range Selection and Activation Using Range and Cells Properties

82. VBA Basic Syntax - Dynamic Cell Range Specification, Last Row Position & Range Methods using currentregion, end, offset properties

83. VBA Basic Syntax - Inputting Data into the Last Cell Principle of the currentregion property Explaining the difference between the row and rows properties Explaining how to write formulas using the formula property

85. Unfiltering based on condition Ending the task How to use IF statement How to unfilter How to use a message box asking whether to continue the task

86. How to specify an arbitrary range and calculate How to receive a range input using the application and inputbox methods How to use Excel built-in functions using the worksheetfunction property How to use the select~case statement

87. Calculating Data Count in a Dynamic Range - Learning Loop Statements, For-Next Loops, How to Count Data Meeting Specific Conditions in a Range

88. Copying only data with a background color How to use the COPY method How to add a worksheet How to use the COLORINDEX code table Explanation of the task: copying only data with a background color and pasting it into a new sheet

89. Table multi-sorting method, How to use the SORT method, How to use the WITH-END WITH statement, How to sort a table by specifying multiple keys

90. Creating history data, How to use the INTERSECT method, How to record changes in original data into history with timestamps

91. Handling worksheets, Adding, deleting, and renaming worksheets, How to list the names of worksheets in the current document

92. Iterating Object References and Coloring Partial Strings Learning Object-Referencing For-Each Loops Explanation on How to Highlight the First Character of Specific Text in Data

93. Hiding and Showing Selected Sheets - Hiding Important Sheets for Security, How to Create and Run a Macro to Show Hidden Sheets

94. Classifying Dates by Quarter - How to use the VBA built-in function DatePart, Practice program to divide dates in data by quarter and classify them onto respective sheets

95. Program that reports the number of connected users at regular intervals - Method for a program that automatically displays the number of connected users in a cell at regular intervals using the timevalue function and ontime method.

96. How to Display Arbitrary Values - How to display random numbers using rnd and randomize, How to store and display arbitrary numbers using an array

97. Lucky Lotto Number Extractor - Lotto Number Generation Program Practice

98. Creating Monthly Files - Using the Workbook Object, Method to Automatically Generate Files for a Desired Month from Transaction Data

99. Creating Reservation Information Registration Form - User-Defined Form Text Box, Option Button Creation Method, Linking Method Explanation

100. Creating a Search Form - How to Search a Worksheet and Create a Data Search Screen Using a User-defined Form Combo Box