Microsoft Excel Advanced
The course is designed for participants who knows basic functionality of Microsoft Excel and want to improve their knowledge of the possibilities of data processing, analysis and visualization using a wide range of Microsoft Excel functionality.
Lecturer:
Aleksandrs Vosekalns
Daiga Zentele
Iveta Milta
Jānis Stūris
Oskars Zeps
Kristiāns Freidenfelds
Raitis Uščins
Olga Tjurdju
Jānis Stūris
Microsoft certified data analyst with more than 10 years of experience. Mainly works with Microsoft Excel, Microsoft Power BI and the programming language R. solving a wide range of tasks - both data acquisition from various data sources, automation of data processing and analysis processes, and presentation of voluminous tables in easily and clearly understandable visualizations.
Raitis Uščins
Resource planning expert at "Tet" company, skilled telecommunication and computer network specialist with continuous growth, focused on innovative company solutions. A teacher with high motivation, self-confidence and the ability to adapt to different situations. Lecturer at the Baltic Computer Academy since 2022.
Plans
Contact us
Apply or ask a question!
If you want to apply for the course or ask a question about it, feel free to use this form. |
||||||||||||
|
||||||||||||
Course target
Teach students to work independently with Microsoft Excel data analysis tools using filtering, selecting by specific criteria, creating PivotTables, as well as other advanced tools.
Audience
Computer users with basic knowledge of Microsoft Excel.
At Course Completion you will be able
- To give a cell area a name and use it in formulas and functions
- To work with functions and independently carry out calculations
- To perform formula auditing – study the values associated with it, correct it if necessary
- To assign a theme to the workbook, perform visualization of various data
- To select data by using filters
- To combine the data of multiple worksheets into one worksheet
- To carry out the organization of data with the calculation of subtotals
- To create and edit PivotTables
- To create charts and use their properties for more accurate data representation
- To protect a workbook, worksheet, or area with a password.
Prerequisites
- Basics of using computers.
- Microsoft Excel basics.
If necessary, to determine the level of knowledge of participants, the BDA conducts pre-course testing.
Training materials
The course uses traing materials developed by the BDA and examples of practical work.
Certification Exam
No certification exam is included.
Course outline
- Calculations and features:
- Name assigning, editing a cell, and a cell area
- Using cell addressing to create functions
- Using the rounding function
- Use functions to determine the number of cells
- Using a text function
- Using date and time functions
- Formation of logical functions
- Using the Browsing and Reference functions
- Using the SUMIF, COUNTIF, and IFERROR functions
- Display formulas and functions
2. Auditing formulas:
- Tracking the precursor and succession of formulas
- Evaluate a formula by using the Evaluate dialog box
- Searching for errors in formulas and correcting them
3. Create and visually format data tables:
- Create and customize a table
- Assign, edit, and delete conditional formatting
- Data visualization using data bars, color scales, and data visualization
- Calculate multiple results using a data table
4. Data processing:
- Sort the data list
- Data filter
- Organization of data into levels with totals (subtotal)
- Perform data validation to prevent data validation
- Text to columns
- Delete duplicates
- Combine data from multiple worksheets into a single worksheet (consolidate worksheets)
5. Display data by using PivotTables:
- Create pivottables
- PivotTable data filter
- Filter data using a timeline
- PivotTable editing (pivottable tools)
- PivotTable formatting
6. Adjusting charts:
- Create a chart template (save as template)
- Add a chart trendline
- Create a chart using a combo chart
- Create a pivotchart
7. Additional options:
- Changing the basic options of the program
- Change the properties of a workbook
- Protected view
- Password protection for workbooks and worksheets
- Checking hidden content and personal information (inspect document)
- Marking the document as final
- Compatibility mode
- Introduction to macros
- Excel protection (macro settings)
- Create and modify macros
- Save a workbook in the Excel Workbook format with a macro (change file type)
If you want to get more information about this course, contact us by phone +371 67505091 or send us an e-mail at mrn@bda.lv.
