In the lessons of the presented three courses dedicated to Microsoft Excel, you will familiarise yourself with the tools of the most widely applied spreadsheet program.
Excel 2013 Online Course
Via the interactive lessons, you will first get acquainted with the program environment. You will learn how to properly enter values to the cells of future tables and how to set their format. From these input values, you will further derive new data by calculating them through formulas, including the applied functions from various categories. You will learn to manipulate cell ranges and whole worksheets. You will adjust the appearance of created tables by setting the cell properties and by applying cell styles. You will analyse the entered data via charts and conditional formatting. You will learn to set the print properties before printing created tables and charts. You will also learn to sort and filter more extensive data and to calculate their subtotals. You will familiarise yourself with the data validation, the creation of scenarios and with the application of the Solver tool. You will learn to share workbooks and to set various levels of their protection. You will also examine the creation and usage of macros in details.
MS Excel 2013: Introduction – You will familiarise yourself with the Excel 2013 environment and its documents and you will learn to control them. You will learn in each lesson to create tables step by step. You will find out how to enter values correctly into the cells and how to set the cell formatting, including conditional formatting. You will learn to manipulate each cell and cell range, you will learn to work with worksheets and entire files. You will create a chart and learn to create calculations by basic arithmetic formulas.
MS Excel 2013: Intermediate – The presented interactive lessons focus mainly on performing various calculations. You will broaden your basic knowledge by the application of logical and text functions. You will get acquainted with the principles of referencing to the values in other cells. You will learn to fill cells with series of data. You will familiarise yourself with the advanced options of sorting and filtering data or searching for specific values in extensive tables. You will also examine how to split longer text entries in tables into individual data placed into several columns.
MS Excel 2013: Advanced – This course is focused mainly on the creation of charts and automation of the work in the program by using macros. Besides these main topics, you will also examine the insertion of various graphical elements into worksheets, such as shapes or SmartArt graphics. You will learn to prepare a table or the entire worksheet before printing and you will familiarise yourself with the options of protecting and sharing the workbook content. You will further familiarise yourself with the usage of macros, including their creation and editing and you will also examine the options of macro security.