Microsoft excel lessons in Casablanca

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

11 microsoft excel teachers in Casablanca

0 teachers in my wish list
+

11 microsoft excel teachers in Casablanca

Meet even more great teachers. Try online lessons with the following real-time online teachers:
Trusted teacher: Formation's goal : - Master and combine the most advanced features of Excel, - Discover new tools and new very useful functions, - Prepare, organize and control the data to facilitate analysis, - Exploit the potential of Excel to automate and make calculations more reliable, - Master the creation of advanced calculation formulas, - Use data lists with management and summary tools, - Prepare dashboards via PivotTables… The training will be enhanced with examples and practical case studies… Training content : ➢ General and Reminder on Level 1: Excel introduction, ➢ Simple functions then advanced functions, ➢ Calculation audits and advanced graphics, ➢ Excel databases and Management of large workbooks, ➢ PivotTables and PivotCharts, ➢ Hypertext Excel links, ➢ Sort / Filter and Advanced Filter options (Advanced), ➢ The validation rules and Conditional formatting, ➢ Import, export or link data… Training program: Reminder on Level 1: Excel introduction: • Discover the Excel Ribbon, • Name cells, ranges and tables, • The options to hide, display, insert and delete, • Concept of workbook and Excel sheet management, • Insertion of comments. Using time-saving tools • Create custom formats. • Define conditional formatting rules. • Facilitate and control data entry with data validation. Build simple and elaborate calculation formulas • Master the copying of formulas: relative and absolute references, • Make calculations more reliable: name cells or ranges of cells, • Set up simple, complex, nested conditions: IF, OR, AND, • Calculate statistics: NBVAL, NB, NB.SI, NB.VIDE,… • Relate data with the VLOOKUP function. • Calculate dates and times: MOIS.DECALER, FIN.MOIS… • Manipulate text: LEFT, RIGHT, STXT, NBCAR,… • Protect the sheet or filing cabinet. Using a data list • Put the data in tabular form. • Apply multi-criteria and custom sorts. • Query, extract data with automatic filters. • Filter one or more tables with segments. • Remove duplicates. Illustrate your data with graphs • Generate a graph from a data table, • Modify the type: histogram, curve, sector, • Add labels, • Adjust the source data. Lists / Sorts and filters • Create a list, • Use the lists with a data grid, • Sort the data in a grid (Sort orders, sort by columns), • Sorting and Filtering, • Personalized sorting, • Group the data in a list, • Display the subtotals of a column, of several columns, • Filter the data. Validation rules and Conditional formatting: • On drop-down lists • On numbers (integer, decimal) • On dates, • Conditional formatting. Set up pivot tables • Set up pivot tables in 1, 2 or 3 dimensions. • Group information by period, by tranche. • Filter, sort, hide data. • Add ratios, percentages. • Insert a cross graph.
Microsoft excel · Microsoft word · Microsoft powerpoint
Showing results 1 - 25 of 1611 - 25 of 161

Our students from Casablanca evaluate their Microsoft Excel teacher.

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

Private coding / programming lessons with python (Paris)
Matías
Highly recommended teacher!!! Matias teaching methods are great. Very clear and concise. Doesn’t waste your time explaining meaningless background information and always lectures with the intent to help you understand the material. He’s helped me understand content for my master course on Python and is one of the best lecturers that I’ve had. Your passion and dedication is beyond words! Thank you for getting me through this hard quick semester, I honestly would have never passed if it was not for your help! Thank you so much once again!
Review by JURIS
Econometrics & Statistics - For University & School Students. SAT, IB, A-Levels, University Courses (Amsterdam)
Nick
Nick's approach is patient and thorough, informative and imaginative as well. He always comes up with his own examples in order to test my knowledge on a given exercise and helps me get to the answer at my own pace, rather than handing it to me. He doesn't use a one-size-fits-all method, but rather tailors his lesson in order to get out my full potential, even in a field I find difficult. He makes himself available for additional questions and is overall great to work with!
Review by DENI
Statistical Analysis with Python and R (Rstudio) - Intro to Data Science (Casablanca)
Amin
I contacted Amin to help me with data analytics using R studio. Amin was very accommodating and quick to reply. Thanks to his flexibility we were able to fix a time and date easily. He is a thorough and highly knowledgeable tutor. He took careful measures in helping me grasp statistical concepts that I had forgotten. I have learned a lot even after one lesson! With clear explanations and a friendly approach, I can wholeheartedly recommend him
Review by SARAH