We are offering a Microsoft Excel Expert Course. The class will teach you how to create macros, conditional formatting, securing your workbooks, expert functions, auditing worksheets, analyzing data, and importing, exporting data. This course is perfect for someone who uses Microsoft Excel already, or took our Excel essentials course and wants to become an expert user.
When this course is over you will be able to create and edit macros, use nested functions, enter database and financial functions, tracing errors in functions, using trendlines and forecast, and how to automate the collection of web data into excel. Students will be able to take home their files they created during the course to practice. Also, students are welcome to come back for a free retake of the course, good for up to 6 months after their first course.
If your goal is to learn Excel from great instructors without breaking the bank, this course is for you. We deliver our Live Online training using the latest technology. You will be able to see your instructor, ask questions, and follow along with them. You are required to have Microsoft Excel installed on your computer. You can download a free 30 day trial directly from Microsoft by clicking this link.
What students will learn in this Excel Expert course?
We pride ourselves on being able to offer a great course at a great price. With over 500 reviews, our students seem to agree. They compliment our great instructors the most.
This course provides 24 hours of live interactive training.
Come back and retake our course, free of charge for up to 6 months from your original course date.
Reduced pricing & customized training available for companies and government agencies.
This is NOT a lecture class where you just watch someone draw while you try to imagine yourself doing the same.
Self Improvement should not require someone going into debt; that is why TIA offers the best value in quality training.
|Microsoft Learning Solutions Partners||(Non Authorized training)|
|Better Business Bureau Accredited Business.||(Not an Accredited Business. No assurance if they are a real company)|
|Small classes Size.||(Classes with 18+ students)|
|Flexible Schedule (Weekday, Evening, and Weekend)||(Just Weekday classes)|
|Instructor with real world Experience.||(Instructors with no real world Experience)|
|Live instructor-led training.|
|Great Location. A few blocks from Penn Station and Port Authority.||(Have to take additional trains and buses to get there)|
|American owned and operated company.||(Non-American company)|
|New York State Licensed Regulated School.||(Non-licensed illegal school)|
|Free retake of the course with in 6 months.||(No retakes allowed)|
|Flat tuition.||(Some providers charge for books or for using a credit card to pay)|
Our Live Online course allows you to attend our great live online training from the comfort of your desk at home or at work. It's the same great course with our excellent instructors. Here a few points about our online class.
This course is available Live Online or Live In-Person. Check out the dates listed on this page and you either see one of our locations listed like "Washington DC", or it'll say "Live Online", and sometimes both.
Yes you will get a certificate of completion at the end of the class.
Yes the course fee includes a training manual.
Our tuition is much lower than other training providers because we have optimized our business processes to ensure quality training at a reasonable price. As a smaller school with lower overhead we are able to provide a great class and better value to our students.
We only hire the best instructors. All instructors have over 10 years’ experience in the filed they teach and over 5 years of experience teaching.
Choosing a training provider can be tough choice. We all claim to offer the best value, in terms of price and training quality. The Technical Institute of America offers the lowest price and teaches more Excel than any other school in New York City. As a New York State licensed school and Better Business Bureau Accredited business we can honestly say what we offer is the truth and you can verify it.
Lesson 1: Streamlining Workflow
Create a Macro
Apply Conditional Formatting
Add Data Validation Criteria
Lesson 2: Collaborating with Others
Protect a Workbook
Share a Workbook
Set Revision Tracking
Review Tracked Revisions
Lesson 3: Expert Functions
Date and time functions
Nested Logical Functions
Working with Math Functions
Lesson 4: Auditing Worksheets
Troubleshoot Errors in Formulas
Troubleshoot Invalid Data and Formulas
Watch and Evaluate Formulas
Lesson 5: Analyzing Data
Create a Trendline
Lesson 6: Working with Multiple Workbooks
Create a Workspace
Link Cells in Different Workbooks
Lesson 7: Importing and Exporting Data
Export Excel Data
Import a Delimited Text File
"A very good class. I absolutely came away feeling comfortable with the program."Helena
"Instructor was extremely knowledgeable and a pleasure to work with!"Denise
"Instructor was very friendly and through he is very good and helped me tremendously."Blake
"Instructor was absolutely terrific. Best software training I ever had."Greg
"Instructor made learning pivot tables and charts very easy. I recommend this class to anyone looking to learn Excel."Tiffany
"Presentation was well done. Instructor was very knowledgeable and friendly. Made learning the complex formulas easy."Albert
"I had taken classes at other schools. This class was one of the best I ever had. The instructor was great, class was small and computers were new."Latoya
"I love the Small classes and smart teacher. He made learning easy and fun."Angel
"Although I have had Excel training before. I have not had it with such clarity. I appreciate his presentation. I'm sure I will be able to retain and use everything I learned. Special Thanks."Sharon
"Juan is an excellent instructor."Joyce
"The instructor was very clear when explaining every aspect of Excel. I really feel I learned a lot and will take other courses in the future."Julia
""I was really impressed with how clear the instructor's instructions were, which made the course enjoyable."Izzy