Filter by Category
Computer Software and Applications
in Computer Training
Excel Advanced 2019/Office 365
available
Bristol and ed2go are partnering to present a menu of professional programs to prepare for exams and certifications – some industry recognized!
Self-paced and instructor-led, ed2go is a platform to develop your resume and enhance your career.
Course Description:
Most organizations rely heavily on Microsoft Excel to consolidate, analyze, and report financial information and other important data. Your company is probably no exception. If you work with data of any kind, learning Excel's advanced functions to taking on greater responsibilities in your organization.
This course will help you master many features in Microsoft Excel 2019/Office 365 that most users don't know exist. You will learn the secret to using formula-based conditional formatting as a creative solution to common issues. You will also learn how to leverage Excel's Power Query tool to import and transform data from about any data source. By the time you finish this course, you will have mastered Microsoft Excel 2019/Office 365 and will be able to better serve your company's data management needs.
Hardware Requirements:
This course must be taken on a PC. It is not suitable for Chromebook and Mac users.
Excel Beginner 2019/Office 365
available
Bristol and ed2go are partnering to present a menu of professional programs to prepare for exams and certifications – some industry recognized!
Self-paced and instructor-led, ed2go is a platform to develop your resume and enhance your career.
Course Description:
Do you manage large sets of numbers, names, dates, or other pieces of information? If so, then you need to create worksheets to manage, store, organize, and even analyze this information. Excel, Microsoft's powerful spreadsheet software, is the most widely-used program to handle this task. In fact, most workplaces require that new employees have a basic level of understanding of Microsoft Excel.
If you want to learn the 2019 version of Microsoft Excel, this course will introduce you to the program's basic functions and uses. Through hands-on lessons, you will learn numerous shortcuts to quickly and efficiently set up worksheets. You will also learn how to use the function wizard to calculate statistics, future values, and more. In addition, you will get tips on sorting and analyzing data, creating three-dimensional workbooks, and automating frequently-repeated tasks with macros and buttons. By the time you're done, you will know how to use this vital Office 2019 tool.
Hardware Requirements:
This course must be taken on a PC. It is not suitable for Chromebook and Mac users.
Excel Intermediate 2019/Office 365
available
Bristol and ed2go are partnering to present a menu of professional programs to prepare for exams and certifications – some industry recognized!
Self-paced and instructor-led, ed2go is a platform to develop your resume and enhance your career.
Course Description:
Many businesses rely on spreadsheets to manage budgets, schedules, and tracking. Microsoft Excel is considered the industry standard for spreadsheets. If you use Excel regularly and want to learn more advanced functions in this powerful software, this course is for you.
You will learn how to harness the power of Excel's data analysis tools and AutoFilter commands and how to create macros that eliminate repetitive tasks. Set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and other intermediate functions to your professional skill set. In addition, you will learn to create macros that let you manipulate data with the push of a button. You'll also discover how to use Goal Seek and Solver and apply them to real-world problems.
Hardware Requirements:
This course must be taken on a PC. It is not suitable for Chromebook and Mac users.