Beginner Excel Classes New York City
Learn best practices in data management—Enter, Analyze, and Create Charts
Microsoft Excel is a powerful tool used to enter and track data for analysis. Excel for Business Fundamentals covers the essential applications of Excel used frequently by corporate professionals. Learn to produce polished work with formatting techniques and crucial tricks to accelerate your workflow.
In this hands-on class, you will work on real-world examples, reinforcing the concepts with practice throughout the class, as well as a cumulative project at the end. You’ll be able to take what you’ve learned in class and apply it directly to projects on your job. At the end of the course you’ll be able to do the following:
- Create automatic calculations to save time entering data
- Apply colors and formatting to text or data cells
- Design spreadsheets with headers and print-ready worksheets
- Learn shortcuts to perform repetitive tasks quickly
Save 15% by Enrolling in Our Excel Bootcamp
Are you eager to master the advanced functions and formulas of Excel? This course is the first class in our Excel for Business Bootcamp. Take our three Excel for Business classes and get a 15% package discount! Sign up for the Excel Bootcamp
Continue Learning with our Free Excel Video Suite
Every student that enrolls in Excel for Business Fundamentals will have lifetime access to our Excel video suite with tutorials on Excel’s functions and techniques. Review the course materials with high-quality video with lifetime access on desktop, tablet or mobile, a $95 value, included at no additional charge.
Beginner Course Outline
Beginner Course PDF Outline
||Provides a brief description of the user interface for Microsoft Excel
|2) Data Entry
||Examines and describes multiple means of entering data
||Explores Excel's amazing ability to predict and extrapolate patterns
||Perform mathematical expressions and review the Order of Operations rule
|5) True or False
||Tests to see whether criteria is true/false
|6) AutoSum Functions
||Review the five key functions: Sum, Average, Max, Min, and Count Numbers
|7) Text Functions
||Introduces functions used to modify text in Excel
|8) Multi-Input Functions
||More advanced functions that require more than one input
|9) Absolute Cell References
||Changing a cell reference into a constant, which is necessary for certain calculations
||The addition of effects to an excel document to provide visual instruction
|11) Format Painter
||The ability to copy format from one cell/range of cells to another cell/range of cells
|12) Conditional Format
||Apply a predetermined format based on specified rules
|Charts & Tables
|13) Line Chart
||Create a Line chart and Spark lines to visually examine data
|14) Column Chart
||Create a Column chart to visually examine data
|15) Pie Chart
||Create a Pie chart to visually examine data
||Explore the special functionality created when data is converted to a Table
||Rules and strategies to make printing easy
||Insert, move, copy and delete worksheets
|19) Repeat Action
||Use the F4 key to duplicate a prior action
||5 Fundamental keyboard shortcuts and a review of others previously covered
|End of Class Project
||End of class project to review key concepts from the class
|22) Save and Close
||Save, close and email the completed workbook
Beginner Course Video Overview
This video will recap some of the essential concepts we'll cover in this class, including formulas, charts, Autofill, absolute cell references, conditional formatting & more. Play the video full-screen in HD for the best viewing experience.
In-Depth Course Overview
When looking to improve your abilities in Excel, our Excel for Business Fundamentals course is a great place to start. This course offers foundational knowledge in Excel that helps to map out the amazing capabilities that Excel possesses. Not only do you learn about Excel’s incredible potential, but you also gain a logical understanding of how all of these individual skills are connected.
Lesson 1 begins with a brief tour of the Excel interface. There is a lot of hidden functionality right in front of your eyes, and our goal here is to identify this. We then segway into Data Entry, with an exercise that allows you to practice various methods of entering data: manually typing, copy/paste, and drag & drop. Here we also witness Excel’s Intellisense—which is Excel’s ability to predict patterns in your keystrokes. This is a theme that we will witness several times throughout the course and can greatly cut down on the amount of time and effort needed when entering data.
Lesson 2 deals with formulas, which are a staple of Excel. We first discuss Excel’s Autofill ability, which is the process of Excel decoding a pattern and applying that pattern to as many cells as we designate. Autofill works not just for calculations, but also for value and time period labels. Next are Calculations, or basic mathematical expressions using the basic operations of addition, subtraction, multiplication, and division. From calculations, we transition to the AutoSum Functions, which is an umbrella term for the 5 basic functions in Excel (SUM, AVERAGE, MAX, MIN, COUNT). True/False is a basic property in Excel in which a simple “test” is created and the result of that test will be listed as either “TRUE” or “FALSE”.
Functions are further explored in the Text Functions exercise, which focuses on a collection of functions (PROPER, UPPER, LOWER, TRIM) that help to modify the “case” of text in Excel. Multi-Input Functions introduces and reinforces slightly more complex functions that require more than a single input. Absolute Cell References is the last exercise in Lesson 2 and this discusses specific instances where we need to “lock” cell ranges at times, in order to make those cells/cell ranges constants. We close out Lesson 2 with a brief review Project to aid in student retention, that you work on independently.
Lesson 3 Formatting consists of a series of mini-drills that teach you about the most effective ways to format data. A practice exercise to apply these skills is provided. This is followed by Conditional Formatting, which involves the selection of a particular rule (“highlight cells with a value greater than 100”, for example) and formatting that you decide upon in advance.
Lesson 4 covers one of Excel’s most popular features which are Charts and Tables. Through the series of Line Chart, Column Chart, and Pie Chart exercises, you will be exposed to the simplicity in creating charts, as well as the ease in formatting them. Tables cover the “why” and “how” involved with formatting data as a database table.
Lesson 5 begins with a series of practical exercises in Printing. Here we practice with the Page Layout view, the Page Break Preview, and the Print menu. Worksheets will expose you to various techniques that can make you more efficient overall, such as inserting, deleting, and grouping worksheet tabs, columns, and rows. We also cover freezing panes. Worksheets are followed by Excel Tricks, which is a small collection of skills such as inserting comments or hyperlinks. Lesson 5 closes out with a second Project, which aims to improve your retention of topics that have been covered earlier in the course.
Why Learn Excel Fundamentals?
A large majority of us have learned to use Excel on an “as needed” basis. We are faced with an unfamiliar task at work, so we ask a colleague for advice, or maybe a quick Google search. What we are really looking for is a “quick fix” solution to the problem, not a deeper understanding of the underlying issue.
What we end up with is a mental toolkit of specific Excel solutions. If we run into the same problem in the future, we can handle it. If we run into a related problem—maybe not. Because we never learned why that solution worked, or how it worked, we are not able to make connections in the future and possibly avoid the problem all together next time.
Think of it this way: if you work with people that speak a different language, you can learn a little of that language. Just from listening and interacting in that new language, you can pick up simple words and phrases to be able to communicate some ideas to others. Does this mean you are now bilingual? Of course not, but you may add enough to your language toolkit to help you in a future situation.
This is where the Excel for Business Fundamentals course comes in. This course is designed to fill in the gaps in knowledge that most of us have accumulated over time. It takes your mental toolkit and makes connections between those specific skills, providing answers to the “why” and the “how”. And from this knowledge comes the all-important “how can I use this to become more efficient/make my job easier” approach, which should be a goal of everyone.
Excel for Business Fundamentals is about gaining fluency in Excel. Are you new to Excel? Are you a little rusty, not having used Excel for many years? Are you a daily user, that wants to better understand how Excel can bake your life easier? This course caters to all three of these cases.
The Excel team at NYIM takes great pride in the content and delivery of all classes—but especially this one. We know that this is often the first step for people like yourself that want to become more competitive in the workplace. We know that your sacrifice of time devoted to learning is precious and so we meet regularly to revise the curriculum and update the relevance of the content.
Finally, our team is committed to your long-term development. We offer students the ability to retake a course for free and provide all students with lifetime access to a video suite that contains individual videos of each of the exercises covered in the course.
Interested? Give us a call and we would be more than happy to discuss this further.