Course Information
Course Overview
Learn how to take Excel to the next level with charts, workbooks, range names and so much more
In this course you will learn how to use multiple worksheets and workbooks efficiently. You will also learn how to create outlines and subtotals, how to create and apply cell names, and how to create and format charts. You will work with templates, collaborate in workbooks and use the drawing tools to enhance and annotate spreadsheets.
With nearly 10,000 training videos available for desktop applications, technical concepts, and business skills that comprise hundreds of courses, Intellezy has many of the videos and courses you and your workforce needs to stay relevant and take your skills to the next level. Our video content is engaging and offers assessments that can be used to test knowledge levels pre and/or post course. Our training content is also frequently refreshed to keep current with changes in the software. This ensures you and your employees get the most up-to-date information and techniques for success. And, because our video development is in-house, we can adapt quickly and create custom content for a more exclusive approach to software and computer system roll-outs.
Like most of our courses, closed caption subtitles are available for this course in: Arabic, English, Simplified Chinese, German, Russian, Portuguese (Brazil), Japanese, Spanish (Latin America), Hindi, and French.
This course aligns with the CAP Body of Knowledge and should be approved for 3.5 recertification points under the Technology and Information Distribution content area. Email info@intellezy.com with proof of completion of the course to obtain your certificate.
Course Content
- 10 section(s)
- 51 lecture(s)
- Section 1 Course Overview
- Section 2 Using Workbooks
- Section 3 Working with Range Names
- Section 4 Applying Outlines and Subtotals
- Section 5 Working with Templates
- Section 6 Collaborating
- Section 7 Creating Charts
- Section 8 Formatting a Chart
- Section 9 Drawing Objects
- Section 10 Conclusion
What You’ll Learn
- Effectively use workbooks
- Understand the benefits of range names
- Apply outlines and work with subtotals
- Automate Excel with templates
- Turn numeric data into charts
Skills covered in this course
Reviews
-
AAnonymized User
Unable to get certificate for completing course even though going through and watching all videos.
-
CCatalina Moreno Pajuelo
La profesora habla un poco rápido y a veces es difícil seguirle. El examen es difícil de leer cuando para cada opción a elegir sale una palabra por línea, de tal manera que no puedes ver de una vez todas las posibles respuestas; hay que estar subiendo y bajando.
-
EEsther Díaz Aparicio
Ha sido una pena, estaba muy interesada en el curso, pero al ser en ingles y los subtitulos en ingles ha sido muy dificil seguirlo, ya que yo no sé inglés, se ha tenido que estar buscando por internet como realizar las operaciones
-
CConstantino Martín-Mora Muñoz
La exponente habla demasiado rápido, teniendo en cuenta que lo hace en inglés, y a los que no dominamos lo suficientemente bien el idioma nos cuesta seguirla a ella y a los subtítulos