Due to the Coronavirus (COVID-19), the health and safety of our students, visitors, staff and the community at large is our first priority. Social distancing is a must, as such Microtrain will be delivering courses using a remote live solution for all courses until further notice.
Now is the time for us to come together to support each other and tackle the challenges we are facing. Please let us know what we can do for you during this time; we’re always here to assist and help however we can.
We invite you to share your insights, ideas, and strategies with us at firstname.lastname@example.org.
Microsoft Office 2016 Excel Level 2
This version of Excel incorporates some new features and connectivity options in efforts to make collaboration and production as easy as possible.
This course is intended to help all users get up to speed on the different features of Excel and to become familiar with its more advanced selection of features. We will cover how to create and use advanced formulas, analyze data, organize worksheet data with tables, visualize data with charts, insert graphics, and enhance workbooks.
About this Course
By the end of this course users should be comfortable in creating advanced formulas, analyzing data with functions, analyzing data using functions and PivotTables, working with tables, visualizing data with charts, inserting graphics, and enhancing workbooks. This course is broken up into lessons. Each lesson focuses on several key topics, each of which are broken down into easy-to-follow concepts. At the end of each topic, you will be given an activity to complete. At the end of each lesson, we will summarize what has been covered and provide a few review questions for you to answer. Supplemental learning for selected topics is provided in the form of Lesson Labs at the end of this book.
Lesson 1: Enhancing Workbooks
Lesson 2: Organizing Worksheet Data with Tables
Lesson 3: Visualizing Data with Charts
Lesson 4: Creating Advanced Formulas
Lesson 5: Analyzing Data with Logical and Lookup Functions
Lesson 6: Inserting Graphics
This class assumes the user has completed or has an understanding of the materials covered in the first part of the Microsoft Office Excel 2016 courseware, including:
§ Using absolute, relative, and mixed references
§ Using formulas and functions in a worksheet
§ Managing and organizing worksheets
§ Editing and formatting Excel data
§ Printing and saving Excel files
§ Customizing the Excel interface
Great class, loved the interaction and team-building exercises. Plenty of materials and learning tools supplied. Although it was a full week's class, never boring. Donna [Russell] was awesome and gave many supporting examples for better understanding.
The instructor [Al Khalfan] was very knowledgeable in the field. He presented the materials and concepts with a professional touch. He also frequently adds humor to his teachings, which made it easier for me to understand. The support staff was all nice, gentle, caring, and very helpful. The materials, rooms and amenities were excellent and exceeded expected standards.
Student Employment Success - Project/Process Manager
My Career Services Manager was very friendly and helpful and had excellent follow-up. She seemed to really care how things were going and kept me moving in the right direction. The resources available in job search were great and the visibility that there were jobs out there looking for my skillset was promising. Additionally, the training, as well as having an updated resume stating the Microtrain course work I had taken made me feel more confident and marketable as I looked for employment. It showed that I was dedicated and took project management and process management seriously.
PMP Certification Training, 2008
Great training facility. Great instructors. Great experience.
PMP Certification Training, Lombard, 2008
I was laid off for many months and not really getting many callbacks for my resume and no job offers. After I put the letters PMP on it, not only did I see an increase in quantity, but also quality of interviews. I had been spinning my wheels for 5 months, and after the PMP went on, I had 2 job offers in 6 weeks. It really was the "golden ticket"
Connect with MicroTrain
Begin building a successful long-term career pathway.