facebook
Become a Tutor

Microsoft excel lessons in Canada

Find your perfect private microsoft excel tutor in Canada.
Learn microsoft excel with our teachers at home or in their studio.

Private lessonsMicrosoft Excel

14 microsoft excel teachers in Canada

0 teachers in my wish list
+–

14 microsoft excel teachers in Canada

(12 reviews)
Anas - Brussels, Belgium$36
$36Master Microsoft Excel (Beginner - Intermediate - Advanced)
Trusted teacher: >>> 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.
Computer science · Microsoft excel
Translate this text using Google Translate.
Ainhoa - Milton Keynes, United Kingdom$34
$34Welcome to the personalised course of Office Suite and Excel, designed specifically for you!
Trusted teacher: In this course, I will help you acquire practical skills and fundamental knowledge in the use of the Office Suite, with a special focus on Excel. Office Suite refers to the collection of computer applications used to enhance productivity in an office environment. Excel is a widely-used tool in the business field for calculations, data analysis, and chart creation. Throughout the course, we will explore the basics of the Office Suite, including programs such as Microsoft Word, Excel, and PowerPoint, among others. You will learn how to create professional documents using Microsoft Word, deliver effective presentations with PowerPoint, and manage data and perform complex calculations with Excel. Specifically regarding Excel, I will guide you through the fundamentals of the application, from entering data and basic formulas to using advanced functions and data analysis. You will learn how to create efficient spreadsheets, perform mathematical and statistical operations, utilize data analysis and visualization tools, and automate repetitive tasks using macros. Throughout the course, you will have access to practical exercises and case studies to apply your newly acquired knowledge. Additionally, you will have the opportunity to ask questions and receive personalized guidance from the instructor. By the end of the course, you will be proficient in using the Office Suite and have mastered the key functionalities of Excel. You will be prepared to apply your skills in professional and academic settings, whether it's organizing data, creating reports, conducting business analysis, or streamlining daily tasks. I am excited to accompany you on this learning journey and assist you in becoming an Office Suite and Excel expert!
Microsoft excel · Computer science · Microsoft office
Translate this text using Google Translate.
« Previous«
Showing results 26 - 50 of 23726 - 50 of 237
Next »»

Our students from Canada evaluate their Microsoft Excel teacher.

To ensure the quality of our Microsoft Excel teachers, we ask our students from Canada to review them.
Only reviews of students are published and they are guaranteed by Apprentus. Rated 4.8 out of 5 based on 53 reviews.

Python programming language explained very simply and interestingly for beginners (Vienna)
Ferdaws
I contacted Ferdaws via Apprentus for my 10 years old son. We were very satisfied with our lesson. My son left the lesson in a very positive mood. Ferdaws' communication with the children is great. This situation motivated us a lot. It is very nice to meet him. Thank you!
Review by GÖKÇEN
Computer courses in Office automation (Beginner, Intermediate, Advanced): "Word", "Excel", "PowerPoint"
Hajar
Hajar is the best tutor I’ve come across here! She is extremely helpful, kind and patient! She communicated clearly all throughout and is extremely knowledgable! I highly highly recommend her! Genuinely one of the nicest people imo :))))
Review by ÁDI
Distance English courses For all levels: ONLINE, TOEIC TOEFL TOESL IELTS (Gabrovo)
Youness
The first lesson was nice and I appreciate a lot the way Youness manage the lesson I highly recommend him for the patience and the calm... A very nice and postive moment
Review by CHANTAL

You are here

Private lessons
Microsoft Excel