Excel advanced level (+ VBA) for professionals and MBA students

Optimize Your Efficiency with Microsoft Office: Unleash Your Creativity at Every Level! If you're looking for a solution to improve the efficiency, creativity and productivity of your daily tasks, look no further than Microsoft Office. Why Choose Microsoft Office? Unleash Your Creativity: Word, Excel, PowerPoint and many other applications give you powerful tools to bring your ideas to life, whether you're creating professional documents, building impactful financial dashboards or designing impressive presentations. Save Time with Automation: Excel simplifies complex tasks with smart formulas, pivot tables, and other nifty features. Available Anywhere: Whether you're in the office, on the road, or at home, Microsoft Office is accessible on all your devices, allowing you to work wherever and whenever you want. Join the Microsoft Office Revolution! Don't let daily challenges slow down your progress. Invest in the power of Microsoft Office to unlock your full potential. Transform the way you work, create easily, and reach new heights with Microsoft Office. Sign up now to master Microsoft Excel, Microsoft Word, and Microsoft PowerPoint at every level, whether you're beginner, intermediate, or advanced.

Hello dear students and participants, As a former teacher, I had the privilege of supporting more than 40 students over the past year in their academic progress. I teach the following subjects: mathematics, physics, chemistry, engineering sciences and Excel. Thanks to my personalized and structured approach, I help my students develop their skills, their self-confidence and their autonomy. By working with me you will learn: *Effective resolution methods, *Intensive practice of exercises, *Educational coaching adapted to your needs, *The development of summary revision sheets, *Career guidance to inform your future choices, *Practical practical work in engineering sciences, to anchor concepts in reality. At the same time, as an information technology consulting engineer, I have in-depth expertise in the technical field, with the ability to design and implement innovative solutions in complex environments. Passionate about aeronautics and piloting aircraft, I cultivate essential qualities such as rigor, discipline and rapid decision-making in dynamic environments. This passion fuels my teaching by adding a practical and inspiring perspective.

Improve yourself with the Italian language with mathematics applied to a good motivation. I am a native speaker in Italian and have been familiar with Excel for 25 years and have been motivated all my life. Let's develop together a growth path made of tangible results that you can use immediately on a practical level.

Are you looking for efficiency, creativity and productivity in your daily tasks? Do not look any further. Microsoft Office is there to meet all your expectations. Why choose Microsoft Office? Create with Power: Word, Excel, PowerPoint and many other applications give you powerful tools to bring your ideas to life, whether it's for a professional document, a financial dashboard or a stunning presentation. Collaborate with ease: OneDrive and Teams allow you to collaborate with your colleagues or friends, no matter where you are. Work together in real time, share files and communicate easily. Save Time with Automation: Excel simplifies complex tasks with smart formulas, while Outlook organizes your emails and calendar so you can focus on what matters. Advanced Security: Protect your data and privacy with advanced security features, such as two-step verification and access management. Advanced Programming: As a specialist, I master programming in VBA (Visual Basic for Applications) to automate your tasks and personalize your Office applications. Additionally, in the latest version of Microsoft Office you also have the option to program in Python, a language that I also master. Available Everywhere: Whether you're in the office, on the road, or at home, Microsoft Office is accessible on all your devices, allowing you to work wherever and whenever you want. Join the Microsoft Office Revolution! Don't let everyday challenges slow you down. Invest in the power of Microsoft Office and unlock your potential. Transform the way you work, create with ease, and reach new heights with Microsoft Office.

Improve your French by following our online French courses. I teach courses and help organize foreign companies in matters of organization and fixed obligations such as monthly expenses and scheduling client appointments.

Technology is now the order of the day, as a computer Instructor for over 10 years with many experiences, I would be happy to help you be a computer literate from beginner to professional. You will learn how to operate the computer starting from the mouse to the system unit. You will learn how to be a data analyst, you will learn so much about the AI tools which is now the popular to the world. I am also happy to adapt our session according to the topic you wish to cover, etc. I am very flexible, my only goal is to help you improve and be a computer literate.

Looking to master Microsoft Office tools? This course covers the three most popular Microsoft Office products: Word, PowerPoint, and Excel. Designed primarily for beginners, the course also offers support for those already familiar with the basics, helping you achieve proficiency with these tools. The course can be tailored for individual or group learning. With our assistance, you'll be mastering Microsoft Office in no time. If you have any questions, please do not hesitate to contact us.

Whether you are asked to create a spreadsheet for statistical analysis, a database of customers, or an engaging presentation of a new product, Microsoft Office is usually your choice. Many users know the basics of what Office can do, but being aware of the more advanced capabilities of Office programs gives you many opportunities for impressive results. This course includes one or more of the following modules: - Documents with Word - Spreadsheets with Excel - E-mail with Outlook - Presentations with PowerPoint - Communication with Teams - Databases with Access If learners are advanced or not interested in any of the above modules, I could happily exclude those modules from the course.

Excel is more than just a spreadsheet—it’s a powerful tool for data analysis, problem-solving, and automation. This course is designed to take you from foundational skills to advanced techniques, enabling you to harness Excel's full potential in real-world scenarios. Whether you're managing data, building models, or optimizing workflows, this hands-on course will equip you with the knowledge and practical expertise to excel (pun intended) in any professional environment. Introduction & Foundations - Overview of Excel’s interface and advanced formatting tools - Key functions like LOOKUP for efficient data handling Working with References & Logical Functions - Mastering relative and absolute references, INDIRECT function - Using ranges, lists, and logical/information functions Formatting, Functions, & Shortcuts - Conditional formatting for data insights - Text functions and essential keyboard shortcuts Data Import & Advanced Operations - Importing data from external sources - Working with dates, times, and matrices Data Analysis Tools - Creating and managing data tables - Data validation and pivot tables for deep analysis Advanced Functions & Formula Auditing - Math, statistical, and financial functions - Troubleshooting and auditing worksheets Advanced Analysis & Automation - Form controls, regression analysis, and scenario building - Introduction to macros for automation

Course description: Introduction to Office Tools 💼📊📎 This introductory office tools course is designed to provide participants with a solid foundation in the effective use of commonly used business software, such as Microsoft Word, Excel and PowerPoint, as well as other essential applications such as e -emails. 🖥️📧 Graduate teacher in Information Systems and Service Science (Bachelor) and holder of a Bachelor's degree in Computer Networks, as well as an M1 in Digital Systems and Services, I am passionate about teaching essential digital skills to succeed in the modern professional world. 🎓💻 This course covers the basics of creating professional documents, managing data, and designing visually appealing presentations, while emphasizing effective communication via email. By the end of the course, participants will have acquired the skills to use these tools confidently and effectively, improving their productivity and employability. 🚀📈

In this Course you will learn everything you need to know about Excel. To get your new job. Forms, functions, tables. dynamic tables. Queries. We can also automate your daily work. You will learn how to update your tables as you receive new information.

From simple sums to cost overviews and pivot tables, Excel is a powerful tool that has become an indispensable part of the workplace for many of us! Do you have a specific problem or would you like a general introduction to Excel? Feel free to message me!

✅ Introduction and getting started with Word Interface and essential features Customizing the work environment ✅ Advanced formatting and document structuring Professional styles and layout Header, footer and automatic numbering management Precise columns, tabs and alignments ✅ Advanced element insertion and management Dynamic tables and graphs Images, SmartArt and Graphic Objects Automatic table of contents and indexing ✅ Automation and advanced tools Interactive templates and forms Insertion and management of bibliographic references Using Macros and Automating Repetitive Tasks ✅ Collaboration and sharing Track changes and comments Document protection and sharing options Convert and export to PDF and other formats ✅ Final project: Creation of a professional document Application of acquired skills to a specific project (academic report, professional file, CV, cover letter, etc.)

Excel lessons based on exercises. Learn to use formulas, pivots, useful shortcuts. Demonstration and practice via exercises. The lessons depend on the level of the student and depending on their needs, this can be adapted gradually. I have a Master 2 in Audit and Management Control and 10 years of experience in finance with multinationals (in different countries). As well as experiences in coaching and mentoring in international competitions for students.

>>> What is Excel? Microsoft Excel is a spreadsheet that allows you to do calculations, analyze data with formulas, tables and graphs. >>> What about pedagogy? I favor the learning by doing method >>> Who am I? For information, I am consultant / trainer and certified Microsoft Excel Expert. I have considerable experience in training. Indeed, I have trained hundreds of people whether in groups, or in private. >>> Location of the training? The place is to be agreed with the apprentice. Training can also be organized remotely (Teams, Zoom, Google Meet, Skype...) >>> Content of the training I can adapt to your level and your needs in terms of content. Here is a non-exhaustive example of the subjects taught. **** Excel Training (Beginner and Intermediate) **** Part I: Basic Concepts What is Excel? Discover the Excel window. Workbooks, spreadsheets, cells. Use the toolbars, the menu, the help. Part II: Working in a spreadsheet Identify basic concepts Manage cells: capture and copy Set up formulas. Master the modes of referencing cells: absolute, relative. Insert, delete rows or columns, move fields. Part III: Formatting a spreadsheet Format cells: present numbers, text, titles. Define conditional formatting. Print the entire sheet or part. Build the layout: titles, pagination Part IV: Workbook Management Save, edit a workbook. Divide your data over several sheets. Insert, delete, move, copy a sheet. Edit multiple sheets simultaneously Part V: Data Analysis Using Functions Calculate percentages, establish ratios. Perform statistics: AVERAGE, MAX, MIN Apply conditions: SI. Use functions: NOW, TODAY. Consolidate multiple sheets of a workbook with the SUM function. Part VI: Linking spreadsheets Transfer data from one table to another Copy / paste with link. Create summary tables. Part VII: Illustrate with graphics Create a chart from a table Change the type: histogram, curve, sector. Add or delete a series. **** Excel Training (Advanced) **** Part I: Configure Excel Options Set up Excel options. Customize the interface. Part II: Gaining time to present his paintings Define styles, use themes. Define conditional formats. Insert Sparklines charts. Part III: Creating simple and complex calculation formulas Master the various modes of referencing: relative, absolute, mixed. Name cells. Set up simple and complex conditions: IF, OR, AND. Calculate statistics: NBVAL, NB, NB.SI. Use mathematical functions: Sum and SUM. Retrieve data with search functions: VLOOKUP Calculate dates, times: DATE(), DAY() and MONTH() ... Manipulate text: CAPITAL, MINISCULE and CONCATENATE. Protect formulas, sheets or binders. Part IV: Consolidation of data Link multiple cells in a workbook. Manage connections between workbooks. Consolidate tables in a workbook. Consolidate data from multiple workbooks. Part V: Exploiting Data Lists Tris multicriteria. Custom sorting: Numeric, Textual and Chronological. Extract data: advanced filters. Delete duplicates. Part VI: Implementing Pivot Tables / Charts Create charts / pivot tables Group the information by period and by slice. Filter and sort Segment filters Show / hide data. Add ratios and percentages.