#Beginner excel training how to
Learn how to create pie graphs, bar charts, line graphs and more by using Pivot Charts in Excel.
Now that you have some basic understanding of Pivot Tables, it's time to learn how to to customize them, manipulate them and organize them depending on the data you want to produce. LESSON 5: HOW TO CUSTOMIZE YOUR PIVOT TABLES In Lesson 4 of our Advanced Excel Accelerated Course, you'll learn how to build pivot tables in a few easy steps. In Lesson 3, users will spend a significant portion of their time learning three different types of lookup formulas by learning about how they are structured, how they are used, and when to use each type of formula depending on your spreadsheet and your desired outcome. Through numerous exercises, you'll learn how to apply the IF formula to automate a process, how to use multiple IF formulas when you encounter different conditions and how to combine IF formulas with other logical formulas to facilitate the automation process. In Lesson 2 of our Advanced Excel Accelerated Course, you'll begin to learn how to automate your formulas by using the infamous IF formula. During this lesson you'll learn different techniques to link sheets together, work with hyperlinks and learn a few formulas that will help you become more efficient when working with dates in Excel. Lesson 1 helps you quickly learn Excel skills that intermediate users should know and helps our newer Excel students get well acquainted with the structure of our course. LESSON 1: HOW TO USE HYPERLINKS & WORK WITH DATES The warm-up exercises are designed to help you smoothly transition from an intermediate Excel user to an advanced Excel user. This is to ensure the quality of training remains high and that all students can ask questions and engage in discussion.The Advanced Excel Accelerated Course begins with two warm-up exercises to help you assess your skills in a few intermediate-level Excel concepts. While this varies from session to session, we typically have 5-8 students in an Excel class. How may students are typically in a Nexacu Excel Training Course?
Book any course as normal and you will receive login details and instructions the evening before your course.
Which courses are available if I am working from home?Īll of our Public Courses are available to be delivered remotely. Students have the same level of participation and access to the trainer as they would in classroom training sessions. Students can access our usual classroom training courses via video conferencing, ask questions, participate in discussion and share their screen with the trainer if they need help at any point in the course. Remote training at Nexacu, means our team of experienced trainers will deliver your training virtually.
We teach these key elements introducing formulas, pivot tables, charting etc with worked examples to help you to understand how to apply these when you get back to the office. Will the content in these Excel Courses be relevant for the workplace?Įveryone uses Excel differently but as previous Excel Consultants we are aware of the core concepts relevant to all workplaces.