About the product
Microsoft Excel for Beginners is a 1-day course targeting beginners as well as intermediate users. It begins with the necessary basic skills and covers a wide range of intermediate level topics. No matter you are new to Excel or you know a little bit of Excel, this is the right course for you.
You will learn
Basic operations of workbooks, worksheets, rows, columns and cells.
Creating worksheets for entering and organizing data in an efficient way and to setup linkages between workbooks for co-authoring
Using Excel functions to summarize data
Formatting reports for presentation
Searching for information in worksheets by using the sorting and filtering functions effectively
Creating headers and footers and customizing print setup
Working with multiple documents
Microsoft Excel for Advanced Users is a 1-day course focusing on the advanced features of Excel such as data management, data analysis, macro, customization, data import/export, data protection, etc.
You will learn
Advanced Excel functions to consolidate data to meet business criteria
Co-authoring documents by enabling document sharing and track changes
Searching and analyzing data with advanced criteria
Preparing reports by grouping and consolidation techniques
Advanced Data presentation by using conditional formatting and charts
Exchanging data between software by using plain text files
Allowing users to input correct data by applying validation rules
Protecting documents with passwords
An overview of task automation by using Macros
You will learn
Basic operations of workbooks, worksheets, rows, columns and cells.
Creating worksheets for entering and organizing data in an efficient way and to setup linkages between workbooks for co-authoring
Using Excel functions to summarize data
Formatting reports for presentation
Searching for information in worksheets by using the sorting and filtering functions effectively
Creating headers and footers and customizing print setup
Working with multiple documents
Microsoft Excel for Advanced Users is a 1-day course focusing on the advanced features of Excel such as data management, data analysis, macro, customization, data import/export, data protection, etc.
You will learn
Advanced Excel functions to consolidate data to meet business criteria
Co-authoring documents by enabling document sharing and track changes
Searching and analyzing data with advanced criteria
Preparing reports by grouping and consolidation techniques
Advanced Data presentation by using conditional formatting and charts
Exchanging data between software by using plain text files
Allowing users to input correct data by applying validation rules
Protecting documents with passwords
An overview of task automation by using Macros
Contact with supplier
Company