The possibility of using Microsoft Excel spreadsheet for statistical analysis in research into the history of science, in particular, to study the scientific contribution of individual authors is presented based on the example of V.G. Averin’s contributions. It is revealed that version 2007 or later is required for correct operation of Excel, since formulas may not work correctly when performing calculations. For initial analysis, only three kinds of Excel formulas are sufficient such as COUNTIF, COUNTIFS, and SUMIFS. Features of creation of the bibliographic list database and its analysis are given. The list of parameters required for a full analysis is specified, including the title and year of publication, type of publication (monographs, periodicals, notes, etc.), number of pages, individual or co-authored, language of publication, and research topic (zoology, botany, geology, etc.). Several examples are considered in detail: a chronological analysis of the dynamics of publications, analysis of publications dynamics according to the language of writing, analysis of the topic of publications and its breakdown by years. The specifics of each method and the results that can be obtained are discussed. Step-by-step instructions to create and analyse databases in Excel are provided, with examples of tables required for their statistical analysis (with formulas used). Advice on the easiest and fastest counting and analysis options is given, as well as charts and graphs that can be obtained from this analysis. The list of additional parameters to carry out bibliographic analysis (type of publication banned by Soviet authorities, number of citations, etc.) is presented. In addition, possible errors that may occur when working with this program (formula language, quotation marks, empty cells, transfer of tables from Word to Excel) are pointed out and recommendations are given to avoid them as well as options for their solution. When entering new data, it is possible to automatically calculate and add new formulas. All analysis procedures are based on the author's experience.

1. Vasyliuk, O., Lastykova, L., & Parkhomenko V. (Eds.) (2019) Askaniia-Nova. Antolohiia publikatsii ta drukovanykh vydan (1845-1945) u 7-my tomakh. Tom 1: 1845-1922 [Askania-Nova. Anthology of Publications and Prints (1845-1945) in 7 volumes. Volume 1: 1845-1922]. / series: «Conservation Biology in Ukraine». Vol. 15. Kyiv [in Ukrainian].
2. Bolhov, M.V. (2019). Elektronni tablytsi v istorychnii profesii. [Spreadsheets in the historical profession] Matematychni metody, modeli ta informatsiini tekhnolohii u nautsi, osviti, ekonomitsi, vyrobnytstvi (рр. 6-8). Mariupol: MDU [in Ukrainian].
3. Borovikov, V.P. (1998). Populyarnoe vvedenie v programmu Statistica [Popular introduction to Statistica]. Moscow [in Russian].
4. Verhunova, I.M., & Krasnitskyi, V.Y. (2012). Matematychni metody dlia vyrishennia naukovykh zavdan vitchyznianoi ahronomii pershoi polovyny XX st. [Mathematical methods for solving scientific problems of domestic agronomy of the first half of the twentieth century]. Kyiv [in Ukrainian].
5. Verhunova, I.M., & Mihulov, O.V. (2011). Istoriia protsesu informatyzatsii v ahronomii Ukrainy (60-ti rr. XX st. – poch. XXI st.). [History of the Informatization Process in Agronomy of Ukraine (60's of XX Century - Beginning of XXI Century)]. Kyiv [in Ukrainian].
6. Horban, T.Yu., & Horban, Yu.A. (2015). Istoriia nauky i tekhniky: vstup do dysertatsiinoho doslidzhennia (naukovo-metodychni porady). [History of Science and Technology: Introduction to the Thesis (Scientific and Methodical Tips)]. Istoriia nauky i biohrafistyka, 3. Retrieved from: http://nbuv.gov.ua/UJRN/INB_Title_2015_3_4 [in Ukrainian].
7. Horda, I.M. (2015). Osoblyvosti vykorystannia bazy danykh «Vykladachi» u vyshchykh ahrarnykh navchalnykh zakladakh. [Peculiarities of the use of the Teachers database in higher agricultural educational establishments]. Science and Education a New Dimension. Pedagogy and Psychology, III (19), Issue: 38, 15-18 [in Ukrainian].
8. Gramma, V.N. (1990). Eretiki i buntari: o pervykh sovetskikh uchenykh-prirodookhranitelyakh. [Heretics and rebels: about the first Soviet environmental scientists]. Zavtra budet pozdno (рр. 6-61). Khar'kov [in Russian].
9. Guseva, N.S. (2013). Matematizatsiya istoricheskoy nauki: stanovlenie kliometrii v istoricheskoy nauke vo vtoroy polovine XX v. [Mathematization of historical science: the establishment of cliometry in historical science in the second half of the 20th century]. Vestnik Tomskogo gosudarstvennogo universiteta,372, 87-90. [in Russian].
10. Guseva, N.S. (2017). Vklad otechestvennykh uchenykh v razrabotku teoretiko-metodologicheskikh problem primeneniya matematicheskikh metodov v istoricheskikh issledovaniyakh (1960-e-konets 1980-kh gg.). [Contribution of domestic scientists to the development of theoretical and methodological problems of the application of mathematical methods in historical research (1960s-late 1980s)]. Vestnik Omskogo gosudarstvennogo pedagogicheskogo universiteta. Gumanitarnye issledovaniya, 1 (14), 23-26. [in Russian].
11. Dovidka Excel. [Excel Help]. Microsoft Office 365. (n.d.). support.office.com Retrieved from https://support.office.com/uk-ua/excel [in Ukrainian].
12. Zhdanovych, O. (2005). Istoriohrafichni aspekty istorychnoi informatyky. [Historiographical aspects of historical informatics]. Spetsialni istorychni dystsypliny: pytannia teorii ta metodyky, 12 (2), 154-168. [in Ukrainian].
13. Koval'chenko, Y.D., & Ustinov, V.A. (1964). Primenenie elektronnykh vychislitel'nykh mashin v istoricheskoy nauke [The use of electronic computers in historical science]. Voprosy istorii, 5, 54-68. [in Russian].
14. Koval'chenko, Y.D. (1969). O primenenii matematiko-statisticheskikh metodov v istoricheskikh issledovaniyakh [On the application of mathematical and statistical methods in historical research]. Istochnikovedenie. Teoreticheskie i metodicheskie problemy, 115–133 [in Russian].
15. Borodkina, L.I., & Garskovoy I.M. (Eds.) (1999) Komp'yuterizovannyy statisticheskiy analiz dlya istorikov [Computerized Statistical Analysis for Historians]. Moscow [in Russian].
16. Kurbatova, K. (2004). Excel 2003: styslyi kurs. [Excel 2003: A Concise Course]. Kyiv: Dialektyka [in Ukrainian].
17. Matematicheskie metody v istoricheskikh issledovaniyakh: sbornik statey (1972) [Mathematical methods in historical research: collection of articles] [in Russian].
18. Mykhailovskyi, M. (1927). Matematychna metoda v biolohii. [Mathematical method in biology]. Visnyk pryrodoznavstva, 2, 65-69. [in Ukrainian].
19. Neliubov, V.O., & Kurutsa, O.S. (2018). Osnovy informatyky. Microsoft Excel 2016: navchalnyi posibnyk. [Fundamentals of Informatics. Microsoft Excel 2016: A Tutorial]. Uzhhorod: DVNZ «UzhNU» [in Ukrainian].
20. Palli, Kh. (1965). Primenenie perfokart v istoricheskikh issledovaniyakh [The use of punch cards in historical research]. Voprosy istorii, 11, 90-98 [in Russian].
21. Parkhomenko, V.V. (2019). Dani do analizu tematyky naukovykh prats profesora V.H. Averina [Data to the analysis of the subject of scientific works of Professor V.G. Averin]. Istoriia osvity, nauky i tekhniky v Ukraini, 14, 482-487. [in Ukrainian].
22. Freeman, M. (2010). Introduction to MS-Excel for historians. Retrieved from https://warwick.ac.uk/fac/cross_fac/heahistory/elibrary/internal/rg_freeman_quanitativeskills_20100131/ [in English].