You will not only be able to summarize data for you to analyze, but also organize the data in a way that meaningfully presents it to others. Being able to harness the power of advanced PivotTable features and create PivotCharts will help you to gain a competitive edge. You already have experience working with Excel and creating basic PivotTables to summarize data, but Excel is capable of doing much more. Along with this, the need to analyze that data and gain actionable insight is greater than ever.
#Microsoft office online free training how to
Also learn how to create conditional formatting rules using formulas, perform complex calculations using Array formulas and create customized lists using data validation.Īdvances in technology have made it possible to store ever increasing amounts of data. Learn how to analyze data using advanced formula skills by focusing on functions from various categories within the function library. This course is designed for participants who have a basic knowledge of Excel functions and want to discover how advanced functions can help save time at work. PREREQUISITE: Understand and use basic Excel functions. Join this quick power training to help boost your effectiveness and efficiency in Excel. These tools will help increase your productivity and motivate you to tackle your spreadsheets with ease. This training is dedicated to learning quick tricks on the top must-have skills for improving your efficiency with Excel: Data Validation, Logical Functions, Conditional Formatting, Lookup and Reference Functions, and Pivot Tables. PREREQUISITE: Intermediate Excel or equivalent. INSTRUCTORS: Emily O’Brien, AS, Roberta Principe, MS
#Microsoft office online free training for free
If you do not qualify for free training but would like to pay to take the course, let us know by emailing us at we can assist with enrollment. To see if you qualify, or to explore all of our grant-supported classes, please click here. This class is offered through our Grant-Supported Training program, and is free to employees of most NJ businesses. INSTRUCTORS: Emily O’Brien and Roberta Principe At the completion of this course, you will be able to perform basic Excel skills such as modifying an existing worksheet, building worksheets, copying and moving cells and much more. This course will introduce you to Microsoft Excel basics including creating spreadsheets, formulas, functions, text, formatting and charts. PREREQUISITE: Basic understanding of Microsoft Windows.
0 kommentar(er)
