This online, hands-on Advanced Excel training course teaches attendees advanced Excel skills, including how to calculate, analyze, and automate data. Attendees learn how to make these tasks more efficient than if they had used traditional calculation methods.
Excel Advanced Training Overview
This online, hands-on Advanced Excel training course teaches attendees advanced Excel skills, including how to calculate, analyze, and automate data. Attendees learn how to make these tasks more efficient than if they had used traditional calculation methods.
Objectives
Create 3D formulas for linking worksheets
Outline goals with conditional formatting
Automate data
Create aggregate calculations
Link worksheets via lookups
Organize data to create summary reports
Prerequisites
All attendees must have prior knowledge of Excel basic formulas.
Providing IT training is what Steve has wanted to do since his late teens. In 1990, he had the good fortune to be placed in the first dormitory at Stanford University that had Internet connections in the dorm rooms. Steve's idea of a good time in college was teaching other students how to use email, FTP, and even Gopher (a precursor to the World Wide Web), as well as putting the University's Berlin, Germany campus online during his time living there.
After graduation, Steve worked for a year at a software company before joining an IT training firm in Washington, DC as its second employee in 1995. In the following years, he progressed to Vice President and then President of the firm, which grew to 7 US locations before the bursting of the Dotcom Bubble and 9/11 sharply reversed its fortunes.
In 2002, Steve founded Accelebrate with one laptop and himself as the sole instructor. In the following 20 years, Accelebrate has grown to consistently deliver more than 1,000 days/year of private training for clients, with classes delivered in-person and online for attendees from every US state, every Canadian province, and more than 30 countries.
At the end of 2022, Accelebrate joined Web Age Solutions and the Axcel family of education companies to drive the next chapter in its growth.
At Accelebrate, we are:
Inclusive
In a world of constant technological, business, and societal change, Accelebrate intentionally builds engagement and opportunity for its clients, employees, and business partners worldwide.
We promote ongoing learning and openness, celebrate diverse people and points of view, strive for equity in all our relationships, and include everyone in the pursuit of knowledge and growth.
Respectful
Accelebrate respects our clients' training needs and carefully adapts classes to meet them.
We listen carefully to the true needs of our clients and make recommendations in their best interests.
We treat all people (clients, employees, and business partners) with respect, regardless of differences.
Our respect for others makes us receptive to feedback and ensures we continuously improve.
In interactions with clients, instructors, and each other, we convey our concern and interest in the other person.
Rigorous
We strive to be the best training firm our clients hire in terms of instructional quality, flexibility, ease of logistics, attention to detail, and timeliness of communication.
We strive to be the best training firm for which our instructors work while simultaneously holding them to high standards for how they teach and treat our clients and staff.
Responsive
We feel a sense of urgency on any matters related to our clients.
We own problems, resolve them in a timely manner, and make commitments with care.
The primary Microsoft Office Applications program is geared towards professionals who want to start their careers in Office Administration, as well as students who want to refresh their understanding of Microsoft Office Products.
Learn Microsoft Access foundations in this introductory Access course. This course teaches the essentials of Access and working with relational databases.
This advanced Microsoft Excel training class is meant for students who want to advance their skill set by learning to work with what-if analysis, data tables, basic macros, data validation and basic macros.
The leader in creating spreadsheets and data presentations. Topics include basic worksheet navigation, entry techniques, cell references, using the command groups and settings, formulas and functions, charts and graphs, and simple database operations.Â
Basic database topics are covered at the beginning of this Introduction to Microsoft Access 2019 training course. After that, they will discover how to design databases, make tables, query those tables, and produce forms and reports.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy