Product Id : 400026
Overview: Attendees will create and edit basic mathematical formulas.
Attendees will create and edit basic mathematical formulas. You will build formulas in Excel with function autocomplete or by typing them manually, while learning essential functions like SUM, MIN, MAX, AVERAGE and COUNT. You will also learn the difference between relative and absolute cell references as well as learning how to copy and paste formulas in Excel and apply autofill options.
Cathy Horwitz is a highly experienced Microsoft Office instructor, specializing in Excel, Word, PowerPoint, Outlook, and Access. With over 30 years of expertise in both in-person and online training, she has helped thousands of professionals boost productivity, streamline workflows, and master essential Microsoft Office skills.
Cathy has been teaching Microsoft Office since its inception, offering tailored training programs that meet the unique needs of individuals and businesses. Her courses cover everything from Excel formulas, PivotTables, and automation with macros to Word document formatting, PowerPoint presentation design, and Outlook email management. Workshops from beginning level through advanced are available.
Known for her engaging, hands-on teaching style, Cathy incorporates real-world business scenarios to ensure students gain practical skills they can immediately apply. Whether you're looking for corporate training, individual coaching, or advanced Microsoft Office workshops, Cathy delivers results-driven instruction that enhances efficiency, problem-solving, and software proficiency.
Product Id : 400026
Overview: Are you a self-taught Excel user, and you like to mix it up and venture into advanced features and formulas, occasionally getting stuck along the way?
Are you a self-taught Excel user, and you like to mix it up and venture into advanced features and formulas, occasionally getting stuck along the way?
This seminar is perfect for you! We will show you the latest innovations in data clean-up, data analysis, and data presentation.
You'll be learning from a 25+ year Excel Certified Expert, who shares amazing tips and tricks from beginner to advanced.
Andy Lanning, owner, trainer, and Chief Nerd of Computer Software Training, LLC.
Andy has 25+ years of experience teaching computer software in the corporate and university environments. She teaches basic to advanced levels in most Microsoft Office programs. She is adjunct faculty at Boise State University, since 1994 to present, where she specializes in computer training for the Center for Professional Development. She also travels to teach at company conferences across the U.S.
Andy’s background includes corporate training, private training, and freelance data analysis. She has recorded several online training courses for Udemy.com, GoSkills.com, and in her career has delivered hundreds of courses and webinars on a variety of Microsoft topics.
Product Id : 400026
Overview: Leery of those cryptic Excel Functions and syntax? The ultimate goal is to empower the attendee by demonstrating the most common formulas so they understand formula syntax to build and fix their own calculations as needed.
Leery of those cryptic Excel Functions and syntax? The ultimate goal is to empower the attendee by demonstrating the most common formulas so they understand formula syntax to build and fix their own calculations as needed. And in this seminar, we have time to move into more advanced formula features.
Plus, have you ever wished someone would just tell you what you didn't know about Excel? It is amazing what has been around the program since the beginning, and we will reintroduce some of those features in this seminar.
Andy Lanning, owner, trainer, and Chief Nerd of Computer Software Training, LLC.
Andy has 25+ years of experience teaching computer software in the corporate and university environments. She teaches basic to advanced levels in most Microsoft Office programs. She is adjunct faculty at Boise State University, since 1994 to present, where she specializes in computer training for the Center for Professional Development. She also travels to teach at company conferences across the U.S.
Andy’s background includes corporate training, private training, and freelance data analysis. She has recorded several online training courses for Udemy.com, GoSkills.com, and in her career has delivered hundreds of courses and webinars on a variety of Microsoft topics.
Product Id : 400026
Overview: This Microsoft Excel training session covers THREE intermediate to advanced features of Excel that provide automation within the application.
LEARNING OBJECTIVES
This Microsoft Excel training session covers THREE intermediate to advanced features of Excel that provide automation within the application.
Formulas are equations that can perform calculations, return information, manipulate the contents of other cells, test conditions, and more. Explore what is considered the top 10 functions.
Lookup functions in Excel are far superior to manually searching for specific data elements in a spreadsheet. VLOOKUP, HLOOKUP, INDEX, and MATCH are some of the most well-known (and most useful) functions in Excel.
Being able to create and edit macros is one of the must-have skills for Excel Power Users. Having this knowledge will save you hours of time by allowing you to automate any Excel-based task or process. If you’ve never created macros or used VBA before, this advanced Excel training is for you.
Cathy Horwitz is a highly experienced Microsoft Office instructor, specializing in Excel, Word, PowerPoint, Outlook, and Access. With over 30 years of expertise in both in-person and online training, she has helped thousands of professionals boost productivity, streamline workflows, and master essential Microsoft Office skills.
Cathy has been teaching Microsoft Office since its inception, offering tailored training programs that meet the unique needs of individuals and businesses. Her courses cover everything from Excel formulas, PivotTables, and automation with macros to Word document formatting, PowerPoint presentation design, and Outlook email management. Workshops from beginning level through advanced are available.
Known for her engaging, hands-on teaching style, Cathy incorporates real-world business scenarios to ensure students gain practical skills they can immediately apply. Whether you're looking for corporate training, individual coaching, or advanced Microsoft Office workshops, Cathy delivers results-driven instruction that enhances efficiency, problem-solving, and software proficiency.
