Complete Microsoft Office Bootcamp

Master the core Microsoft Excel functions in this one-day course. Automate calculations and data entry. Apply formatting to text and cells to make your spreadsheet scannable and visually appealing. In this hands-on training, you will learn all the basics to use Excel as your primary data processing tool. You'll produce polished and print-ready spreadsheets while learning tricks to accelerate your workflow.

Go from beginner to experienced professional: summarize data with Pivot Tables, write advanced functions including VLOOKUP, and learn techniques to expedite your workflow. Use tools and formulas to format text. Manipulate data visuals with advanced charting skills. Use statistical formulas like COUNTIFS and SUMIFS to learn more about your data. At the end of intermediate Excel, you'll unlock powerful techniques that will help you complete tasks more quickly.

Advance your career with this essential course for professionals that use Excel daily. You'll make functions more flexible, take Pivot Tables to the next level, and automate tasks with macros. Utilize Excel's most important tools with training in core database functions. If you have a strong working knowledge in Excel and want to save even more time with custom shortcuts and advanced features, this is the perfect course for you. 

• Create new PowerPoint Presentations
• Choose appropriate slide layouts & add content (text, images, etc.)
  
• Add photos, graphics, & how to adjust them (size, crop, etc.)
• Build Diagrams using SmartArt
• Draw Shapes & Lines
• Align & Evenly Space Objects
• Work with Tables & Charts
• Add Transitions
• Run a PowerPoint Presentation (Slide Show)

• Design Custom PowerPoint Themes
  
• Work with Theme Colors, Fonts, Backgrounds, & Slide Layouts
• Add Animations for Stand Out Presentations
• Incorporate Video
• Customize the Look of Charts & Animate Charts
• Bring in Tables from Excel
• Manage Large Presentations with Sections, Hidden Slides, and Custom Shows
• Collaborate with Others using Comments

This one-day class concentrates on how to use Outlook quickly and effectively for daily work tasks or to become an Official Microsoft Certified Outlook Specialist. By the end of this class, you will be able to reduce hours of repetitive work by setting up rules and search folders to automate email, manage your calendar and to-do lists, manage huge amounts of email with ease, manage complex scheduling, organize all your contacts and track your correspondence.

In this course, you will configure mail accounts, perform advanced searches, control spam with filters, automate tasks with rules, and learn advanced calendar and contact management skills. This course builds upon the foundational knowledge presented in the Outlook Essentials course and will help you customize a communication system well-suited to your work styles.

Master Microsoft Word's essential shortcuts and techniques in one day. Prepare and send mass emails, letters, and labels with one click. Learn everyday functions used in firms throughout New York City. Eliminate formatting blunders with bullets and page numbers. By the end of this class, you'll be able to apply shortcuts that save hours on daily tasks and optimize your time in Microsoft Word. 

Advance your career with training in Microsoft Word's most advanced functions and features. Automate useful tools like mail merge. Record tasks and write macros to save time. Create custom document styles and templates to improve productivity within your entire team. By the end of this course, you'll master advanced techniques that expedite your workflow. If you use Microsoft Word daily, this course provides essential training in everything you need to know.