The course participants will be able to efficiently use primarily data analysis tools such as scenarios and pivot tables, use the features to perform calculations on dates and text-processing functions, and create and adapt to the needs of macros to automate work with spreadsheets.
Requirements
Knowledge of Windows and the basics of using Microsoft Excel.
Overview
The course participants will be able to efficiently use primarily data analysis tools such as scenarios and pivot tables, use the features to perform calculations on dates and text-processing functions, and create and adapt to the needs of macros to automate work with spreadsheets.
Course Outline
Adjustment of the working environment
Hotkeys, facilities
Create and modify toolbars
Options excel (autosave, input, etc.).
Options paste special (transpose)
Formatting (style, format painter)
Tool - go to
Organization of information
Management sheets (naming, copying, color change)
Assign and manage the names of cells and ranges
Protect worksheet and workbook
Secure and encrypt files
Collaboration and track changes, comments
Inspection sheet
Create your own templates (charts, worksheets, workbooks)
Data analysis
Logic
Basic Features
Advanced Features
Creation of complex / multiple formulas
Scenarios
Search result
Solver
Charts
Graphics support (shadows, charts, AutoShapes)
Database management (list)
Data consolidation
Grouping and outlining data
Sorting data (over 4 columns)
Advanced data filtering
Database Functions
Subtotal (partial)
Tables and Pivot Charts
Cooperation with other applications
Get External Data (CSV, TXT)
OLE (static and link)
Web Queries
Publication sheets on site (static and dynamic)
Publication PivotTables
Automation of work
Conditional Formatting
Create your own formats
Check the validation
Macros - automation tasks in sheets
Registration macros
Understanding and modifying the code macros (VBA items)
Connecting the interface macros or workbook
Create forms on screen or printed
NobleProg is an international training and consultancy group, delivering high quality courses to every sector, covering: Cyber Security, Artificial Intelligence, IT, Management, Applied Statistics.
Over the last 17 years, we have trained more than 50,000 people from over 6000 companies and organisations.
Our courses include classroom (both public and closed) and instructor-led online giving you choice and flexibility to suit your time, budget and level of expertise.
We practice what we preach – we use a great deal of the technologies and methods that we teach, and continuously upgrade and improve our courses, keeping up to date with all the latest developments.
Our trainers are hand picked and have been through rigorous checks and interviews, and all courses are evaluated by delegates ensuring continuous feedback and improvement.
Discover how to manage data and information with easy. Microsoft Access is an information management tool that helps you store information for reference, reporting, and analysis.
Learn to create professional documents, reports and newsletters confidently using efficient features such as forms and fields, text manipulation techniques, etc.
Learn to use this elegant presentation package which is part of your MS-Office suite. It allows you to prepare stunning effects for on-screen presentations, overheads and slides for meetings and briefings.
Learn the skills to create and maintain database tables, queries, screen forms and reports using this powerful database management program.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy